This article explains the configuration values required in order to connect to a Microsoft SQL database
This article applies to Windows Shared Hosting and Windows Reseller accounts.
To access your Microsoft SQL Server database, use the following credentials:
Username: Your account username.
Password: The password you define when installing SQL Server.
Database: Your account username.
The database server host name you connect to depends upon whether you are accessing the database server from an ASP page on one of our web servers or from an external machine outside our network.
Internal connection: mssql2.
External connection: mssql2.turbodns.co.uk,5000.
Tip: In Enterprise Manager you can specify the port number by appending the hostname with a comma followed by the port number.
A suitable ASP connection string would therefore be as follows:.
"Provider=SQLOLEDB; Data Source=mssql2; Initial Catalog=Your account username; User ID=Your account username; Password=PASSWORD; Network Library=dbmssocn;"
Tip: Using the abbreviated host name as shown above for connections from ASP pages ensures that traffic to and from your database travels over our private switched network, yielding maximum performance and availability for your database driven web pages.