March 26, 2012 at 3:36 pm
Hello,
I have 4 instaces on the local machine. I am able to connect to default instance(Ins1) with TCP/IP. It has the default port number(1433).
When I try to connect to another named instance(Ins2) by TCP/IP I am getting an error. I did enable the TCP/IP on that Instance. It has random port no(50897) assigned to it. I did restart the service after enabling TCP/IP. I did configure Ins2 to accept remote connections.
**Note** I am connecting using SSMS
I dont understand whats causing the problem.
The error message is like this below.
Cannot connect to NAWAZ-PC\NAWAZINS1.
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 am able to connect by default protocol(i.e Shared memory).
What could be the reason?
March 26, 2012 at 3:38 pm
Can you connect to the named instances using the IPADDRESS\INSTANCENAME? Do you have SQL Browser running on the server?
March 26, 2012 at 3:45 pm
Actually I am not in the network. I am working on a Single home PC. When I started the sql server browser service. I was able to login using TCP/IP.
May I know what it has to do with SQl Server browser?
I am a newbie and have no Idea about Sql server browser service.
Thank u for the help.
Regards,
na1774
March 26, 2012 at 3:52 pm
Named instances use dynamic ports. The SQL Brower service is used to identify the port that a named instance is using. These can change between restarts of the instances unless you fix the ports used.
March 26, 2012 at 3:56 pm
Thank you very much.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply