SQL Server 2005 client connection issues

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

SQL Server 2005 client connection issues

Author

Topic

satishvsh
Starting Member

41 Posts

Posted - 2008-06-30 : 15:51:25

Friends:

we are facing this error, when i am trying to connect from sql server 2005 client.

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: TCP Provider, error: 0 - No such host is known.) (Microsoft SQL Server, Error: 11001)

Server Details :

SQL Server 2005 Enterprise Edition SP2
Active/Passive cluster
Created alias successfully
tcp port : 1433
add sqlservr.exe under exceptions tab
sql server browser services is running

Still we are not able to connect to the server from the client

please advise on this

cheers :)
satish

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-06-30 : 15:53:16

See this: http://weblogs.sqlteam.com/tarad/archive/2008/05/23/60609.aspx

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

buzzi
Starting Member

48 Posts

Posted - 2008-06-30 : 16:11:53

Go to surfacearea configurations and under remote connections allow to have both local and remote connections, and select the option Using both TCP/IP and named pipes. Hope this should work

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources