Connecting to SQL Server 2006 through Internet

Question

Connecting to SQL Server 2006 through Internet

SQL Guy 1

SSCoach

Points: 15979
More actions
January 6, 2010 at 11:44 am

#137941

Recently I tried to connect, but it failed.
I have SQL Server 2005 Standard Edition installed on Windows XP Pro version 2002 SP2.
I got my IP address from ipconfig comand, passed it to my counterpart, and he entered it as xxx.xxx.xxx.xxx\instance_name format in Connect to SQL Server dialog, however connection failed with error 26 "A network-related or instance specific error occured while establishing connection to SQL server......"
We tried both Windows and SQL Server authentication mode, none of them worked. I also checked Surface Area Configuration tool and it allows local and remote connections with TCP/IP protocols.
What else should I check, like firewall, sp_configure, etc ?
Note: this is my home PC.
Thanks.

Viewing 7 posts - 1 through 6 (of 6 total)

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

Mike01 SSChampion Points: 11395 More actions · Answer 1

here's a link to some things you can try

http://www.sqlmusings.com/2009/03/11/resolving-a-network-related-or-instance-specific-error-occurred-while-establishing-a-connection-to-sql-server/

For better, quicker answers, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

AndrewSQLDBA SSC-Insane Points: 21827 More actions · Answer 2

You need the IP Address of the data modual, not the IP that it gives out to that particular box. You need too use the IP that the world sees, not that is on the private side of the data modual.

Then you have to modify the ports that the router will be allowed to open.

Andrew SQLDBA

Bru Medishetty SSC-Insane Points: 23606 More actions · Answer 3

Have you checked if the protocols needed are enabled? Check in SQL Server Configuration Manager.

Bru Medishetty

Blog -- LearnSQLWithBru

Join on Facebook Page Facebook.comLearnSQLWithBru

Twitter -- BruMedishetty

SQL Guy 1 SSCoach Points: 15979 More actions · Answer 4

Thanks all for your replies, but something is not clear for me:

1. Andrew: how can I get IP Address of the data modual ? That IP address that I have obtained with ipconfig, sounds like really my private one.

2. Bru: TCP/IP is enabled.

Thanks.

Bru Medishetty SSC-Insane Points: 23606 More actions · Answer 5

Check if Named Pipes protocol is enabled and try connecting using the Machinename\InstanceName.

Bru Medishetty

Blog -- LearnSQLWithBru

Join on Facebook Page Facebook.comLearnSQLWithBru

Twitter -- BruMedishetty

AndrewSQLDBA SSC-Insane Points: 21827 More actions · Answer 6

Yes, using ipconfig /all will give you the address of the private side, you need the address that the world sees. I use a Classic ASP page on the back of my own site that shows the public facing IP Address. This is what you use to connect to your own box from some where in the world. You can have your switch or router pass out any IPs that you like. I personally do not use the 192.168.x.x ip range. I use something else. That is a secret to help keep my network more secure.

http://www.computer-consultant.com/sendip2.asp

Andrew SQLDBA