July 5, 2012 at 1:27 pm
Dear All
I have installed a developer version of SQL Server 2008R2 on a Server machine. I created alias for the SQL Server instance on it. Alias name is same as SQL_instance_name. Except via Server\SQL_instance_name, I can connect simply by just typing SQL_instance_name i.e. the alias created. Everything on the server machine is OK.
All protocols except VIA are enabled. Default port 1433 is enabled in Windows Firewall.
Identical aliases are created on the Server and remote machines.
Then I try to connect to sql server from remote machine with the alias created but it fails. If I try with Server\SQL_instance_name it connects (from remote machine).
Can anyone help or suggest something …
Regards,
IgorMi
Igor Micev,My blog: www.igormicev.com
July 5, 2012 at 3:33 pm
I would check that you also have UDP 1434 open through the firewall. This is required for the SQL Browser which gets used anytime you attempt to connect to a named instance.
July 5, 2012 at 3:47 pm
Nicholas Cain (7/5/2012)
I would check that you also have UDP 1434 open through the firewall. This is required for the SQL Browser which gets used anytime you attempt to connect to a named instance.
Hi,
Thank you for your reply.
Actually I have opened ports 4500 and 500 for UDP, and my SQL Browser service is started.
Only one instance of sql server is on the machine...
Expect more suggestions...
Thank you
Igor Micev,My blog: www.igormicev.com
July 5, 2012 at 4:31 pm
Yes, but you need 1434 which is what SQL Browser listens on.
netsh firewall set portopening UDP 1434 "SQL Browser"
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply