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

• Chris Hedgate

  One Orange Chip

  Points: 25041

  More actions

  August 2, 2001 at 8:22 am

  #417389

  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

  August 2, 2001 at 8:23 am

  #417390

  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

  August 2, 2001 at 9:01 am

  #417392

  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

  May 22, 2007 at 12:15 am

  #707972

  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