August 21, 2006 at 2:23 pm
On a single server, I have SQL Server 2000 SP3 installed. I have a default SQL Server installed. I also installed another instance of SQL Server, call it "SQLInstanceA". Using Query Analyzer on the server to connect to the instance SQLInstanceA, I'm able to connect successfully. However, when using Query Analyzer from a client workstation, I am unable to connect to SQLInstanceA. How can I connect to SQLInstanceA from my client workstation? Thank you!
August 21, 2006 at 9:09 pm
First, make sure that network connections are enabled for the named instance.
Make sure that you can connect remotely to the default instance. Make sure the account you are using has correct rights.
I had the same problem several months ago. I'm not sure if the situation is the same, though. I used different startup accounts for the two instances and the accounts were not in the local administrators group. To fix this problem, if you have the same set up as I had, you can either add the start up accounts to the local admins group OR make sure that the startup account of each instance has read permission of the registry settings for the other instance. HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server.
Aunt Kathi Data Platform MVP
Author of Expert T-SQL Window Functions
Simple-Talk Editor
August 21, 2006 at 10:52 pm
I am not sure if my answer will be the right solution, but I usually from the client workstation give the servername\instancename in query analyzer to connect followed by the user id / pwd (if its a sql authentication)
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply