MS SQL Connection Settings

From Lunarpages Web Hosting Wiki

Jump to: navigation, search

Connecting to the MS SQL server from your ASP.net scripts is a very easy thing to do here at Lunarpages. How do you connect to the MS SQL server with your 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 MS SQL servers are listed below:

  • Bois - 67.210.98.106
  • Castor - 209.200.235.3
  • Raptor - 209.200.224.115
  • Kendal - 74.50.25.63
  • Urmom - 64.50.162.71
Want to read this in another language?

Lunarpages Deal: Save $72 on your next Business web hosting plan! Starting at $18.95 per month, this an offer you can't miss. Perfect for business and e-commerce hosting sites, comes with free e-commerce tools and a TremenDesk Help Desk. Limited time offer!