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.

 All Forums
 SQL Server 2005 Forums
 Other SQL Server Topics (2005)
 remote connection

Author  Topic 

stargon
Starting Member

2 Posts

Posted - 2010-10-27 : 09:43:36
Very new to sql. Have a sql 2005 server with 4 instances. Trying to connect remotely to a specific instance from the internet. I set the instance up with a static port. Configured the router/firewall to have the specific port opened. Also opened udp 1434 to the sql server.

I cannot connect from the internet.

Is there a specific way to test my connection from the internet to the sql instance?

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2010-10-27 : 10:53:35
We can't see what you have tried so far...
Do you know how to connect to an additional instance?

DefaultInstanceName\additionalInstanceName


No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page

stargon
Starting Member

2 Posts

Posted - 2010-10-27 : 11:36:17
During my most recent attempt to connect, I installed SQL Server Management Studio express on a remote laptop. Put in my outside router address xxx.xxx.xxx.xxx,1500 and was able to connect to the specific sql instance.
Go to Top of Page
   

- Advertisement -