July 18, 2012 at 10:08 am
I have 2 instance on my sql 2008 r2 server.One is default instance
I am able to connect to default instance from my local desktop machine with sqlauthentication.
But I am not able to connect to named instance.getting the below error
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: TCP Provider, error: 0 - No connection could be made because the target machine actively refused it.) (Microsoft SQL Server, ErrorL 10061)
SQL browser is running fine on this machine
Pls help
July 18, 2012 at 10:22 am
Hi,
Is TCP/IP enabled for the named instance?
Check in SQL Server Configuration Manager -> SQL Server Network Configuration -> Protocols for instancename
Cheers
July 18, 2012 at 11:20 am
Is the SQL Browser service running? Without the browser service running you need to know and specify the port that the named instance is running on as well.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
July 18, 2012 at 12:39 pm
...also check the firewall to be sure TCP/IP port used by named instance is allowed through inbound firewall.
July 18, 2012 at 1:14 pm
you can try this:
1) Look through the startup section in the SQL error log for the named instance and note down the port no
from the section which mentions the following.
Server is listening on "portno"
2) And then try connecting to the name instance using the following string:
Hostname\instancename,portno
In other words add a a comma folllowed by the port no as a suffix when you are trying to connect to the named instance.
July 18, 2012 at 9:55 pm
SQL Browser is running
TCP IP enabled
Port is dynamic port.
I tested that also
No luck
but I am able to connect to default instance
July 19, 2012 at 6:36 am
Can you connect to the named instance from the server itself?
What are you entering for a server name? Are you sure you are typing the name correctly?
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
July 19, 2012 at 7:02 am
I am able to connect from the server,other server in the same domain
Problem is from my laptop.
I am able to connect to the default instance from laptop
I am using <IPADDRESS>\Instancename to connect the server
July 19, 2012 at 7:35 am
Have you checked the firewall on your desktop? Perhaps it is blocking responses from that port? Outside my area of expertise now, but I'd definitely start by temporarily disabling the firewall on the desktop.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply