Question

php远程连接sql server失败SQLSTATE] => 08001

我在本地测试远程连接服务器A的sql server没问题，但是我在服务器B上远程连接服务器A的sql server，出现此错误，跪求解决办法。
Array
(
[0] => Array
(
[0] => 08001
[SQLSTATE] => 08001
[1] => 1231
[code] => 1231
[2] => [Microsoft][SQL Server Native Client 10.0]Named
Pipes Provider: Could not open a connection to SQL Server [1231].
[message] => [Microsoft][SQL Server Native Client
10.0]Named Pipes Provider: Could not open a connection to SQL Server
[1231].
)

[1] => Array
(
[0] => HYT00
[SQLSTATE] => HYT00
[1] => 0
[code] => 0
[2] => [Microsoft][SQL Server Native Client 10.0]Login
timeout expired
[message] => [Microsoft][SQL Server Native Client
10.0]Login timeout expired
)

[2] => Array
(
[0] => 08001
[SQLSTATE] => 08001
[1] => 1231
[code] => 1231
[2] => [Microsoft][SQL Server Native Client 10.0]A
network-related or instance-specific error has occurred while
establishing a connection to SQL Server. Server is not found or not
accessible. Check if instance name is correct and if SQL Server is
configured to allow remote connections. For more information see SQL
Server Books Online.
[message] => [Microsoft][SQL Server Native Client 10.0]A
network-related or instance-specific error has occurred while
establishing a connection to SQL Server. Server is not found or not
accessible. Check if instance name is correct and if SQL Server is
configured to allow remote connections. For more information see SQL
Server Books Online.
)

)

Answer 1

GRANT ALL PRIVILEGES ON 数据库.* TO 'root'@'localhost' IDENTIFIED BY '密码' with grant option;
GRANT ALL PRIVILEGES ON 数据库.* TO 'root'@'%' IDENTIFIED BY '密码'with grant option;