Connecting to your SQL Server Databases
In your Web Hosting Control Panel, it's possible to create SQL Server databases. After creating your database, use the connection information provided below to connect to your SQL Server database from within your ASP.NET or Classic ASP 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=;Database=;User Id=;Password=; |
| Classic ASP |
Provider=MSOLEDBSQL;Data source=;Database=;User Id=;Password=; |
SQL Server Managment Studio
Microsoft SQL Server Management Studio is a free software application developed by Microsoft that allows you to manage your database from your desktop. It enables you to manage your Web Wiz SQL Server Database.
You will need to use the latest version of SQL Server Management Studio with your Web Wiz hosted SQL Server Database which you can download from the folowing link; https://learn.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms
MyLittleAdmin Database Management Tool
As part of your Hosting Plan, we provide you with online database management tool myLittleAdmin for SQL Server, which is a web-based management tool created specifically for MS SQL Server. With it, you can easily manage your SQL Server Databases, including new objects like tables and store procedures, all through a web browser. To access MyLittleAdmin, simply log into your Control Panel and go to the 'Databases -> SQL Server' section. You'll see a 'Browse Database' link next to each of the SQL Server Databases you've added.
SQL Server Database Backup and Restore
The Web Wiz Hosting Control Panel provides tools for backing up and restoring your SQL Server Databases. For further informatiomn please see; Restoring SQL Server Databases and Backup SQL Server Databases.
Back To Hosting Knowledgebase Menu |
