"spitapps" wrote:
|I have webspace running on a machine with IP address 82.165.206.115
| through 1and1.com.  Then I have an internal server running on my
| network which is running SQL Server 2000.  I have yet to be able to
| make a connection to my internal server from my webspace.  I have
| forwarded port 1433 to the server on my internal network and have SQL
| Server 2000 listening on port 1433.  My connection string looks like
| this:
|
| "Data Source=xx.xx.xx.xx, 1433;" & _
|                                     "Initial Catalog=DataWarehouse;" &
| _
|                                     "User ID=WEBUSER;" & _
|                                     "Password=*********"
|
| So when i try and connect to the server from my website i get this:
| An error has occurred while establishing a connection to the server.
| When connecting to SQL Server 2005, this failure may be caused by the
| fact that under the default settings SQL Server does not allow remote
| connections. (provider: TCP Provider, error: 0 - A connection attempt
| failed because the connected party did not properly respond after a
| period of time, or established connection failed because connected host
| has failed to respond.)
|
| Which i think is weird because I am running SQL Server 2000 not 2005,
| also I have some exceptions on the server to allow port 1433 to come
| through and sqlserver.exe to come though also, and still nothing.  Just
| wondering if anyone has run into this or has any suggestions.  Thanks
| in advance.
|