MS SQL Connection Settings
From Lunarpages Web Hosting Wiki
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? | Web Hosting Support Categories: Beginner | Billing & Sales | Web Design | LPCP | cPanel | Plesk | Quicksite | PageMason | E-mail | Databases | Domain Names | Reseller | Dedicated | VPS | ASP | JSP | PHP | Third Party Scripts | Affiliates | Misc |
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!
