Q: How can I connect to MS SQL located on another server?
A: To connect from an ASP page to your SQL server located on some IP address you will have to specify following SQL driver connection string:

ConnectionString = "DRIVER=SQL Server;SERVER={ipaddress};UID={username}; PWD={password};DATABASE={database}"

You will have to replacewhat is inside {} with the actual IP address (or hostname), username, password, and database name. For example:

ConnectionString = "DRIVER=SQL Server;SERVER=123.45.67.89;UID=sa; PWD=secret;DATABASE=mydatabase"

Article ID: 314
Keywords: sql