Connect to a named instance over the internet

Question

Connect to a named instance over the internet

GRN

Hall of Fame

Points: 3260
More actions
August 2, 2001 at 7:51 am

#77652

How do i connect to a named instance of sql server over the internet using a IP i tried a combination of the IP/[instance name] the IP:Server Port
Any ideas

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Chris Hedgate One Orange Chip Points: 25041 More actions · Answer 1

By default, a named instance uses a dynamically chosen (at startup) port number to listen on. You can change this behaviour and force it to listen on a specified port number (server properties in SQLEM -> network config -> TCP/IP properties). SQL Server also listen on port 1434 for client requests for information on which ports are available to connect to.

Chris Hedgate @ Apptus Technologies (http://www.apptus.se)

--
Chris Hedgate http://www.hedgate.net/
Contributor to the Best of SQL Server Central volumes
Articles: http://www.sqlservercentral.com/columnists/chedgate/

Chris Hedgate One Orange Chip Points: 25041 More actions · Answer 2

Hmm...forgot to answer...

It should be IP:Port, but you have to know which port.

Chris Hedgate @ Apptus Technologies (http://www.apptus.se)

--
Chris Hedgate http://www.hedgate.net/
Contributor to the Best of SQL Server Central volumes
Articles: http://www.sqlservercentral.com/columnists/chedgate/

GRN Hall of Fame Points: 3260 More actions · Answer 3

thanks chris..

just found out it was the firewall..it seems that the sa "forgot" to open it

aarrrrrrrrrgggghhhhhh

Mrcic Zeljko SSC Veteran Points: 222 More actions · Answer 4

Hi.....this is for Chris....

I dont knoe what I'm doing wrong....but I just can not connect to SQL2005 over internet....can you please, steep by steep explain adjustmets on server machine and on machine trying to access sql2005 over internet....

thanks