How do I connect to the MSSQL server with my ASP.Net script?

The database server is on a separate server so you will need to use the server IP in your connection string.

Here is an example of what the connection string should look:

Driver={SQL Server};Server=your_database_server_ip;Database=some_database;User ID=some_user;Password=some_password;

IPs of our MSSQL servers are listed below: 
208.101.11.244 (All new accounts use this server. Hence, if your account was setup recently, you need to use that IP in your connection string)

  • 9 Users Found This Useful
Was this answer helpful?

Related Articles

What are the connection settings for my MySQL database?

The hostname to connect to is "localhost" if connecting from a script on the server, or your...

How do I create a database in MySQL?

You can create a database via your control panel by clicking on the mySQL icon. Here is a link...

How do I connect to my database from Dreamweaver MX?

We're going under the assumption that you have already set up a MySQL database on your server....

How do I connect to MS ACCESS Database on Windows 2003 Server ?

Upload your MS Access database on the root folder. Create a System DSN and give the Access mdb...

How do I connect to MS SQL Server 2005 ?

We provide a MS SQL login and password for your SQL database. Connect to the online SQL server...