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 2000 Forums
 SQL Server Administration (2000)
 Connecting to named instance of SQL Server

Author  Topic 

sarma100
Starting Member

2 Posts

Posted - 2008-06-16 : 23:37:40
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?

jezemine
Master Smack Fu Yak Hacker

2886 Posts

Posted - 2008-06-16 : 23:48:34
dupe

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=104949


elsasoft.org
Go to Top of Page
   

- Advertisement -