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 |
|
sathyalan
Starting Member
5 Posts |
 Posted - 2006-10-03 : 04:00:54
|
| Hi Gents,i am administrating one remote SQlSelver 2000, on Windows 2000 server. but now i am not able to connect the server. when i try register the server in the Enterprise manager it gives the following error message. "SQL server registration failed because of the connection failure displayed below. Do you wish to Register anyway?SQL server does not exist or access denied.ConnectionOpen (Connect())"From other machine i am able to connect. i am using the correct tcp port server name, etc...Kindly help me guys.Regards,Thaya |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-10-03 : 04:32:48
|
| do a quick odbc connection from the connecting machine (create an entry)if the connection credentials you've supplied is correct and same as the one that is able to connect, then I'll take a guess and say it's probably firewall rules that's preventing the connection from that particular machine--------------------keeping it simple... |
 |
|
|
Westley
Posting Yak Master
229 Posts |
Posted - 2006-10-03 : 06:30:06
|
| Another vote for firewall :) |
|
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2006-10-03 : 07:24:13
|
| Firewall for me too please!--Lumbago"Real programmers don't document, if it was hard to write it should be hard to understand" |
|
|
|
|
|
|
Server Problem