Web Wiz - Solar Powered Eco Web Hosting

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=mssql1.websitelive.net;Database=databaseName;User Id=userName;Password=password;
Classic ASP Provider=MSOLEDBSQL;Data source=mssql1.websitelive.net;Database=databaseName;User Id=userName;Password=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

Become a Fan on Facebook Follow us on X 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.