Wednesday, March 7, 2012

Error connecting to remote server using sql server 2005 management studio

I have a sql server 2000 database on my server with following setting

Server name KamiServer and IP range: 201.134.180.180 - 201.134.180.190
The SQL login (read-only access) is: Kamran and the password is: Shahid

When I try to caonnect it through Sql server management studio I got Following error
Testing the registered server failed. Verify the server name, login credentials, and database, and then click Test again.

ADDITIONAL INFORMATION:

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)

I can connect to other local server on my lanThere are some pieces missing in your explanation. is that a firewalled server ? As the host is not reachable, Is the IP reachable from the connecting client ?

HTH, Jens Suessmeyer.

-
http://www.sqlserver2005.de
-|||

Refer the below blog for more information

http://blogs.msdn.com/sql_protocols/archive/2005/09/28/474698.aspx

No comments:

Post a Comment