March 3, 2008 at 7:40 am
Hi,
am trying to study up on the subjects to upgrade my 2000 certs to 2005. whilst doing this i am trying to connect to a server in its own workgroup lets call this server homeserver. the other server i am using is on my workstation with a work domain. lets call this workserver.
I want to connect to a named instance of SQL server across a firewall. I have changed the default instance(homeserver) port to 1435 and changed the named instance (homeserver/sql2005) port to 1433. Both these ports are open on my firewall. Now this connects no problems using an alias and tcpip. however some tools require you connect to the server without using an alias. ie. replication subscription wizard.
I put a entry in my hosts file to map the server name at my house to the ipaddress i connect to it via. i.e.
homeserver 111.111.111.111
if i try and connect via the subscription wizard i get a message telling me that
"sqlserver requires an actual servername to connect to the server connections through an alias,ipaddress or any other alternative name are not supported, specify the actual servername, 'homeserver\sql2005' (Replication.Utilities)." This doesn't work. Any suggestions? Incidentally 2005 is a named instance as i have 2000 as the default instance which is required for other work.
cheers
Tim
March 3, 2008 at 7:50 am
Is the sql browser service running? The browser service is able to resolve the ports dynamically, without the use of an alias.
March 3, 2008 at 7:55 am
Erm it is running at work yes. Do i need to open some more ports? i have (before anyone mentions it) put a rule in my firewall to only allow these open ports to my work ipaddress.
Cheers
Tim
March 3, 2008 at 8:04 am
Additioanlly.
If i put an entry in my hosts file as below.
62.49.61.233homeserver/sql2005
i can connect via isqlw (sql2000) but still unable via 2005 managementstudio.
Cheers
Tim
March 3, 2008 at 8:26 am
You also need to open up udp 1434. The browser service uses this port to determine the port numbers of remote named instances.
more info:
March 3, 2008 at 8:41 am
Hi Adam,
thanks mate i just found this myself. not that easy to find. I opened up the tcpip and udp ports for 1433-1435 to be sure and it starting working. Awesome. Thanks for your help.
Incidentally any idea what TCPIP port 1521 is used for? as my firewall has a service rule i can add for SQL-NET which is this port?
Cheers
Tim
March 3, 2008 at 8:56 am
All that I know of is ORACLE or SQL-NET.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply