Fail to connect to a remote SQL server with SQL Server 2008 Management Studio -
Fail to connect to a remote SQL server with SQL Server 2008 Management Studio -
i'm trying connect remote database sql server 2008 management studio. got next error:
a network-related or instance-specific error occurred while establishing connection sql server. server not found or not accessible. verify instance name right , sql server configured allow remote connections. (provider: named pipes provider, error: 40 - not open connection sql server) (microsoft sql server, erreur : 53)
i think have wrong config:
can help me please ?
steps find out reason is:
does sql server allow remote connections? main settings sql server is tcp/ip enabled client connections , hear on right ip address / nic? does firewall on server allow incoming traffic sql server port (default 1433)it 1 of 3 points above.
sql-server sql-server-2008 ssms
Comments
Post a Comment