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

Popular posts from this blog

formatting - SAS SQL Datepart function returning odd values -

c++ - Apple Mach-O Linker Error(Duplicate Symbols For Architecture armv7) -

php - Yii 2: Unable to find a class into the extension 'yii2-admin' -