SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Connecting to named instance of SQL Server
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

sarma100
Starting Member

2 Posts

Posted - 06/16/2008 :  23:35:44  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

USA
7174 Posts

Posted - 06/17/2008 :  09:27:41  Show Profile  Reply with Quote
Is your SP of SQL 2005 upto date ?
Go to Top of Page

rmiao
Flowing Fount of Yak Knowledge

USA
7266 Posts

Posted - 06/18/2008 :  23:17:49  Show Profile  Reply with Quote
Tried connect with ip address and port number instead of instance name?
Go to Top of Page

mdubey
Posting Yak Master

USA
133 Posts

Posted - 06/19/2008 :  12:30:06  Show Profile  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.19 seconds. Powered By: Snitz Forums 2000