Dreamweaver - connect to MSSQL database local from remote???

Author

connect to MSSQL database local from remote???

jamesy

2006-02-24, 10:15 am

Hi,
I have a few websites that use an MSSQL database. At the moment, the websites
are sat on a windows server in the same datacenter as the SQL server...

Everything is fine..

If I move the SQL server to my clients web accessible local SQL server... and
then change the connection string in the website to reference the IP of this
new server instead of the name of the other SQL server... would that still work?

The reason I ask is that I've just tried it and it didn't.. however I was
actually on their local network whilst doing it, so behind their web IP.. so I
suspect that may be the case.. but is it possible?

James

Lionstone

2006-02-24, 10:15 am

> The reason I ask is that I've just tried it and it didn't.. however I was
> actually on their local network whilst doing it, so behind their web IP..
> so I
> suspect that may be the case.. but is it possible?

Of course it is. :)
There are a few things to check though:
1. Check the database name (initial catalog).
2. Make sure the user for the web page has been created on the new server.
3. Make sure any firewalls are allowing traffic on port 1433. If the new
server is not a default setup, make sure whatever port was chosen for TCP/IP
connections to SQL Server is open, and specify that port in your connection
string (Data Source=000.000.000.000,1000; where 1000 is the port to use to
connect to the server at IP 000.000.000.000)
4. If the SQL Server allows both TCP/IP and Named Pipes connections, then
specify Network Library=DBMSSOCN; as part of your connection string to force
a TCP/IP connection.

Chris In Madison

2006-02-24, 10:15 pm

Sounds reasonable enough to me :-) Once you take your security concerns
into account, the steps Lionstone described is the way to go about it.

Best regards,
Chris