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

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 ?
Go to Top of Page

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?
Go to Top of Page

mdubey
Posting Yak Master

133 Posts

Posted - 2008-06-19 : 12:30:06
Try to connect with TCP:servername\instancename or NP:servername\Instancename.

Please go thru this link.
http://blogs.msdn.com/sql_protocols/archive/2005/12/22/506607.aspx

Manoj
MCP, MCTS
Go to Top of Page
   

- Advertisement -