Re: Connecting to a SQL Server 2005 DB on a Remote Web Server

Mike Webb wrote:
Bob

TCPIP IS an enabled Protocol under Network Configuration For Port
1433 on IP1 of 192.168.1.20

I have also enabled Local and Remote connections - for TCPIP ONLY -
with the SQL Surface Area Configuration Tool.

FYI
If I use the local IP address 192.168.1.20 for the Data Source it
works, if I use my external static IP address on the internet
213.162.108.132 then I get these problems

I've only had experience connecting via LAN, so I will not be able to
provide further assistance. It sounds like a firewall issue, but I'm not
sure. If no one else chimes in, you should try one of the sqlserver
newsgroups.

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.


.