July 22, 2015 at 2:30 pm
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 22, 2015 at 3:04 pm
what is 'dynamics'?
Is it an DNS Alias name?
July 22, 2015 at 3:13 pm
Marsha,
Yes, it is a DNS alias name for the server.
Thanks
July 22, 2015 at 4:07 pm
Is the SQL Browser running on the server?
Can you take me through the steps you used to create the instances?
July 22, 2015 at 7:52 pm
Marsha (7/22/2015)
Is the SQL Browser running on the server?Can you take me through the steps you used to create the instances?
this. if you don't have the service running, you must explicitly set the port in the connection info.
so for your SSMS connection, as well as any connection string, should be server\instance{comma} port
dynamics\FINANCE,1450
Lowell
July 24, 2015 at 6:46 am
You need to restart the SQL Server browser service if it's already running otherwise start it if it's not running.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply