Web Wiz - Solar Powered Eco Web Hosting

Connecting to your SQL Server Databases

You can create SQL Server databases in your Web Hosting accounts Hosting Control Panel. Once you have created your SQL Server database use the connection information shown below to connect to your SQL Server database from within your ASP or ASP.NET applications.

Connection Info

SQL Server Database Server 2 mssql2.WebSiteLive.net
SQL Server Database Server 4 mssql4.WebSiteLive.net
SQL Server Database Server 5 mssql5.WebSiteLive.net
SQL Server Database Server 6 mssql6.WebSiteLive.net
SQL Server Database Server 7 mssql7.WebSiteLive.net
SQL Server Database Server 8 mssql8.WebSiteLive.net

Please check the Space Summary email and/or by clicking on the 'View Space Summary' link in your Control Panel to see which of the above database servers you are using for your hosting account.

Example Connection Strings

Below you will find example connection strings for connecting to SQL Server from ASP.NET and Classic ASP.

ASP.NET Server=mssql1.websitelive.net; Database=databaseName; Uid=userName; Password=password;
Classic ASP Provider=SQLOLEDB;Data source=mssql1.websitelive.net;Initial catalog=databaseName;User Id=userName;Password=password;

MyLittleAdmin Management Tool

Together with your Hosting Package you have access to our online database management tools. myLittleAdmin for SQL Server is the first web-based management tool specially designed for MS SQL Server.

It lets you manage your SQL Server Databases, including new objects such as snapshots, schemas, and credentials, etc. through a web browser. Faster than SQL Server Management Studio, its intuitive interface will seduce all users, from the DBA's to the webmasters. View Demo >>

Back To Hosting Knowledgebase Menu

Become a Fan on Facebook Follow us on Twitter Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Policy

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2023 Web Wiz Ltd. All rights reserved.