Cannot connect to named instance (2nd instance) from local SSMS

Hello All,

I've two instances(Default, Named[dynamics\FINANCE]) running on SQL server 2014. However, when I try to connect to named instance say (dynamics\FINANCE) using SQL authentication from local SSMS, I get below error message:

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)

I assigned a static port number to the named instance [dynamics\FINANCE] 1450. I also setup the firewall rule to allow access to Port 1450.

What am I missing here? Any help is greatly appreciated.

Thanks

July 22nd, 2015 4:32pm

Is your SQL Server Browser Service Running?

SQL Server Browser service is what allows connectivity to named instances of SQL Server

If you dont want to turn on SQL Server Browser try connecting by specifing the port when connecting to your named instance, 

Connect promp: Server,1450

Let me know if that helps


Free Windows Admin Tool Kit Click here and download it now
July 22nd, 2015 5:19pm

refer this article..all the thingsg you need to check are explained here

http://www.sswug.org/articlesection/default.aspx?TargetID=44331

http://blog.sqlauthority.com/2009/05/21/sql-server-fix-error-provider-named-pipes-provider-error-40-could-not-open-a-connection-to-sql-server-microsoft-sql-server-error/

July 22nd, 2015 5:19pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics