SQL Management Studio cannot connect.
-
Hey guys,
I'm a intern at my college and I'm trying to connect to a named instance of SQL 2005 using the SQL Server Management Studio. However, I cannot connect to the server if I specify the netbios name of the server (e.g. computername/instancename), but if I try to connect using the IP address instead of the computername, it works. I'm only trying to connect locally so I can't figure out why this doesn't work. Another oddity is that I also have a default instance on the machine, which I can connect to just fine using either netbios or IP. Please enlighten me!
Ryan
P.S. I'm getting the following message:
Cannot connect to COB-SV-SQL01\MSGP9.
------------------------------
ADDITIONAL INFORMATION:
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)
-
IF SQL Browser service not running on the server you might have some issues connection to named instance espeically if the TCP IP port is set to dynamic(default). Try connecting to the named instance by giving port number also. Find out which port number SQL server is listening to. And try connecting with port number like Servername\Instancename,portnumber
example : Srv1\Inst1,2433
-
You are wise beyond your years. That was exactly my problem. All I needed to do was specify the port. Thanks a bunch.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply