March 26, 2015 at 11:59 am
Hi,
I am getting problem with remote login to the sql instance
In machine Sql 2008R2 is installed as default later 2014 installed as named instance. Both TCP/IP, shared memory,namedpipes are enabled for both named & default instances. For the default instance I can used the remote connections but the named instance is not allowing remote connections
March 26, 2015 at 12:16 pm
ramana3327 (3/26/2015)
Hi,I am getting problem with remote login to the sql instance
In machine Sql 2008R2 is installed as default later 2014 installed as named instance. Both TCP/IP, shared memory,namedpipes are enabled for both named & default instances. For the default instance I can used the remote connections but the named instance is not allowing remote connections
Is the browser service running? Are you able to connect SERVERNAME,LISTENINGPORT ?
March 27, 2015 at 1:38 pm
For each instance needs one browser service?
I can see
Sql Integration servecies 11.0 & Sql Integration servecies 12.0,
Sql server (Named) & Sql server (default),
Sql Agent (named) & sql Agenet (default)
but only one sql broswer
March 27, 2015 at 3:24 pm
Most likely a firewall issue.
The following link provides step by step diagnosis.
http://blogs.technet.com/b/mdegre/archive/2011/06/04/resolve-sql-server-connectivity-issues.aspx
March 27, 2015 at 5:09 pm
When I check for TCP?IP ports
both default & named instances are using default 1433
March 28, 2015 at 9:47 am
My recommendation is to disable the SQL Server firewall completely and test it.
If still no connection, use
netstat -ano
It will show you which ports SQL Server processes (you have two process ids, one for each instance) are listening.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply