Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
imarchenko
Yak Posting Veteran
57 Posts |
 Posted - 2010-08-13 : 14:32:06
|
| Hello! I am troubleshooting connectivity from client computer to SQL Server 2008 named instance. We have opened 1433 and 1434 ports to allow connectivity. I am able to connect using <SQLServerName>\<InstanceName>,<PortNumber> syntax. But I would like to connect without specifying port number. SQL Server Browser service is running on SQL Server. Also, IPall settings in TCP/IP protocol is configured to use dynamic port in question. I am not sure if there any other ports that I have to open to allow connection without specifying port nunber. I am able to connect using <SQLServerName>\<InstanceName> from clients that don't go through firewall (for exmaple, inside SQL Server network). That makes me think this is firewall restrictions. Any help is greatly appreciated.Igor |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-08-13 : 15:00:37
|
| Created alias in SQL Configuration manager? |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2010-08-13 : 15:01:02
|
| If it works with specifying the port, then you can simply add an alias.To do that, you can use SQL Server Configuration Manager or regedit. I prefer regedit:HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\ConnectToNew string valueValue name = the name you want to use when connecting, perhaps ServerName\InstanceName, but it can be anything reallyValue data = DBMSSOCN,ServerName,PortNumberTara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
|
|
|
|
|
|
Problem connecting to SQL Server over firewall