August 6, 2010 at 10:55 am
I have a server with 2 instances. One is the default and one is named. I can remote into the default instance, but not the named. Both have the Allow Remote Connections checked off. I can log into both when local.
August 6, 2010 at 11:00 am
If SQL Server is running on a Cluster and certain other conditions apply, such as VPN, then this is a known bug.
SQL = Scarcely Qualifies as a Language
August 6, 2010 at 11:01 am
I'm not running this one on a cluster.
August 6, 2010 at 11:52 am
By "remote in", do you mean RDP in? There's only one node to RDP into if so and therefore you are done. If you mean "connect", you've confused the issue. I suspect you meant that you only can connect when you are logged on locally, and cannot connect from a different machine. Please confirm before we go further, otherwise we may troubleshoot the wrong problem.
August 6, 2010 at 12:20 pm
There are some confusion with this question. With the exception of default instance all instance are called named instance in standalone system. You can RDP only to the Default instance name or physical host name.
Hostname: Server1
Default Instance Name: Server1
All additional instance name as follow: Server1\VS1, Server\VS2, Server\VS3 .....
Good luck
August 6, 2010 at 12:26 pm
sorry about that. i am trying to connect using Management Studio from my client. I can connect to the default instance, but not to the named instance. If I RDP into the server, I can connect to both instances locally.
August 6, 2010 at 12:58 pm
OK, so we ARE trying to connect here. My guess is that default is on 1433 and that you don't have the SQL Browser running. Can you confirm the status of the SQL Browser?
August 6, 2010 at 1:31 pm
The browser was running on the server. it's not on the client, but I'm assuming that is not necessary since i am not trying to connect to the client.
TITLE: Connect to Server
------------------------------
Cannot connect to gpdev-01\test1.
------------------------------
ADDITIONAL INFORMATION:
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=-1&LinkId=20476
A specified SQL Server instance name is not valid. name is correct
The TCP, or named pipes protocols are not enabled. enabled
The firewall on the server has refused the connection. <shrug> I can connect to default instance, wouldn't that mean I should be able to connect to the named instance?
The SQL Server Browser service (sqlbrowser) is not started. started
August 6, 2010 at 2:06 pm
If the named instance has been moved to a static port, then no, the firewall could still be an issue. The firewall opens up both addresses and ports, and while the Browser can route dynamic ports, it won't do static ports. Try to telnet to the port in question remotely and see if anything is listening on that port/if it makes it past the firewall.
August 6, 2010 at 2:09 pm
This looks like a VERY helpful article about your exact issue:
August 6, 2010 at 3:15 pm
that should give me something to mess with for a while. i'll let you know how it turns out.
thanks
August 9, 2010 at 8:25 am
It was the firewall. I shut it down on the server and it works fine. Now I'll work on the firewall on Server 2008 to get it to work right.
Thanks
August 9, 2010 at 9:35 am
Try connecting by specifying the port no of the named instance
e.g. gpdev-01\test1,<port no>
August 9, 2010 at 9:49 am
Use configuration manager to set a specific port for the named instances, then enable the firewall, allow traffic through for those ports. Specify as listed above.
server, port
Viewing 14 posts - 1 through 13 (of 13 total)
You must be logged in to reply to this topic. Login to reply