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 |
sarma100
Starting Member
2 Posts |
Posted - 2008-06-16 : 23:35:44
|
We have installed SQL 2000 SP4 on Windows 2000 Server. We created named instances on the SQL server. When trying to connect to named instances from a remote sql client which is on windows 2000 and windows 2003, its throwing an error message saying that remote connections are disabled. But, remote connections are enabled on the SQL server. After changing the component services settings on windows 2003 where sql client is installed, we are able to connect to named instances. But, after applying the same settings on another windows 2003 machine, we are unable to connect to the same instances. We have another machine where we installed SQL 2005 on windows 2003 SP1. When trying to connect to named instances from any remote client, its throwing an error message saying that remote connections are disabled. But, remote connections are enabled in SQL server settings. We tried connecting to the instances by changing the component services settings but still we are facing the same issues. Can you please help me on above issues? |
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-06-17 : 09:27:41
|
Is your SP of SQL 2005 upto date ? |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-06-18 : 23:17:49
|
Tried connect with ip address and port number instead of instance name? |
|
|
mdubey
Posting Yak Master
133 Posts |
|
|
|
|