nitayalevette
asked on
Unable to Connect to Server\Instance Name SQL Server 2008 R2
I'm able to connect to SQL Server locally, and I'm able to telnet into the server from another macine; however when attempting to connect to the server via ssms from another machine, I'm receving the following error message when attempting to connect to a SQL Server Instance (server\instance) "Error locating server/Instance specified" I've enabled "allow remote connections", I've enabled "sql browser", I've doubled and triple checked the instance name, I've enabled TCP/IP.
ASKER
Backslash is there, and going in the right direction
ASKER
The local server is able to see the instance and connect; however we are unable to connect to the instance from another server or computer
Is there any firewall is running in server, if yes try to disable or add the SQL Port in exception
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
We are able to connect via sqlcmd; however we are still unable to connect via ssms. Firewall is OFF, and we have restarted the services.
Please make sure Remote connection is enabled in configuration. TCP/IP and other protocol is configured well, Firewall has proper exception.
ASKER
TCP/IP Connections are enabled; however we are going through port 2153 for this connection. We have another instance running over port 1433. How can I make SSMS go through port 2153 vs 1433?
Did you try Connecting via SSMS as
Servername\InstanceName,21 53 or tcp:Servername\InstanceNam e,2153
Thanks,
Servername\InstanceName,21
Thanks,
Try the following. Sql Server Configuration Manager -> SQL Native Client Configuration -> Client Protocol Disable VIA.
On SQL Server Network Configuration -> Protocol for <Instance Name> Disable NamedPipe and VIA and enable.
On SQL Server Network Configuration -> Protocol for <Instance Name> Disable NamedPipe and VIA and enable.
"Error locating server/Instance specified"
Make sure its a backslash
server\Instance