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.
| Author |
Topic |
|
kamii47
Constraint Violating Yak Guru
353 Posts |
 Posted - 2006-07-21 : 05:34:24
|
| I have a sql server 2000 database on my server with following settingServer name KamiServer and IP range: 202.144.180.180 - 202.144.180.190 The SQL login (read-only access) is: Kamran and the password is: ShahidWhen 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 lan |
|
|
KenW
Constraint Violating Yak Guru
391 Posts |
Posted - 2006-07-21 : 13:47:30
|
quote:
I have a sql server 2000 database on my server with following setting
quote:
When connecting to SQL Server 2005
So which is it? Are you running SQL Server 2000 or SQL Server 2005?Ken |
 |
|
|
kamii47
Constraint Violating Yak Guru
353 Posts |
Posted - 2006-07-22 : 01:26:16
|
| Remote server is sql 2000 I want's to coneect it from management studio ? |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-07-22 : 05:36:00
|
| ip range? what's the ip address of the sql server you are trying to connect to? verify the connection information in your surface configurationis the browser on?--------------------keeping it simple... |
|
|
|
|
|
|
Error connecting to server through management stud