MS SQL Connection Settings

From Lunarpages Web Hosting Wiki
Jump to: navigation, search

Connecting to the MSSQL server from your ASP.net scripts is a very easy thing to do here at Lunarpages. How do you connect to the MSSQL server with your ASP.Net script? The MSSQL database is on a separate server so you will need to use the server IP in your connection string.

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:

  • Bois - 67.210.98.106 (eon, hod, mextli, necalli)
  • Castor - 209.200.235.3 (araki, celano, cephei, dulfim, kraz, mettalah, naiad)
  • Raptor - 209.200.224.115 (arcturus, chronos, indus, regor, tozi, voga, yed)
  • Kendal - 74.50.25.63 (blamo, crush, nahum, rocket)
  • Urmom - 64.50.162.71 (bash, tub, maimon, bassu)
  • Kassu - 209.200.244.70 (tressa)
Share |
Want to read this in another language?