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)

  • 59 gebruikers vonden dit artikel nuttig
Was dit antwoord nuttig?

Related Articles

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 set up my PC to connect to MSSQL Server database at Webcom Systems Web Hosting?

Setting up your PC to connect to your SQL Server database at Webcom Systems Web Hosting is...

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 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 create a database in MySQL?

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