Connection over internet

I need to connect to a sql server through the internet.
Inside the LAN everything works great, but if try to connect from a pc
outside the lan over the internet I get an error message saying SQLstate
01000 and SQL state 08001 error 17.
What's wrong '
Thank You since now to anyone can help me
Bye
PaoloGian,
How are you addressing the SQL Server? The external IP address should be
different to the one on your LAN. I personally would not be comfortable
with my SQL Server accessible over the internet.
1. Make sure that the correct ports are open on your firewall.
2. Check that SQL Server is listening on TCP/IP, and the port number
3. For named instances set up an alias and "hard code" the port using
the Server Network Utility.
4. Do not allow access through port 1434 on the firewall.
Take a look at this article also:
Potential causes of the "SQL Server does not exist or access denied"
error message
http://support.microsoft.com/?id=328306
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
Gian Paolo Piscopo wrote:
> I need to connect to a sql server through the internet.
> Inside the LAN everything works great, but if try to connect from a pc
> outside the lan over the internet I get an error message saying SQLstate
> 01000 and SQL state 08001 error 17.
> What's wrong '
> Thank You since now to anyone can help me
> Bye
> Paolo
>|||Hi
There are a few things you'll have to check.
1. Have you got a route from your external PC into the SQL server.? If you
connect via an IP address, you'll have to make sure that this IP address has
a route through your FireWall. If you connect via a name, you'll have to
make sure that this name is bound to the correct IP address.
2. Have you opened the right ports in your FireWall? By default SQL server
uses port 1433, so you need to have a rule in your FireWall that allows this
traffic.
Also, it might help if you tell how you try to connect to the server - with
EM, QA or an application?
Regards
Steen
Gian Paolo Piscopo wrote:
> I need to connect to a sql server through the internet.
> Inside the LAN everything works great, but if try to connect from a pc
> outside the lan over the internet I get an error message saying
> SQLstate 01000 and SQL state 08001 error 17.
> What's wrong '
> Thank You since now to anyone can help me
> Bye
> Paolo