asked
SQL Server 2012 Named instance - Remote connectivity
All, we have installed SQL Server 2012 Business edition. There is Database engine, and SSAS Server on the machine. Both db engine and the ssas servers have default and named instances. These machines are on the AWS environment. I have opened up the the following ports 1433, 1434, 2382 and 2383. I have verified that the sqlservr.exe is listening on 1433. and sql browser listening on 2382. I have opened up the UDP port 1434, for the named db server, so that browser can resolve named db instance. Hence I have no issues connecting to the default instance remotely. it works while I try to connect via public ip. Now coming to the named instance, I am having lot of problem connecting. I have tried ip:1434, ip\instance name nothing works. I have configured on the surface configuration for the named instance- to listen to port tcp/ip port 1434, and deleted the "0" so the named instance works on 1434 and does not listen to any dyanmic ports. I am bit confused, the bol says on 1434 for sql browser for db engine, and 2382 for SSAS instance. Does browser listen to on both the ports. I am not sure what to do at this point. Connecting to the named instance just does not work. i have the tcp/ip enabled for the named instance as well. Just to make sure that firewall is not the issue, we have local firewalls are off and the aws firewall is also completely open. I am able to telnet to the ports-1433, 2383,2383. What am I missing? Appreciate all the help! Thanks, pk
have you tried forcing the named instance to a different port number ? then connect. that would allow you t5o rule out any port conflicts.. there is also a quick article about resolving this issue (when an app is badly coded and forces you to use 1433)
http://www.rickygao.com/how-to-use-the-same-port-for-multi-instance-in-a-single-sql-server/
19 People are following this question.
