Creating a New MS SQL Database in WinHost
Log in to your WinHost Control Panel at
https://cp.winhost.com
In the navigation menu under the WinHost logo, click the Sites tab.
Click the site link for which you would like to create a database.
Click the MS SQL Manager button.
Click the Add button.
Choose the desired database version.
Enter the database suffix and quota for the new database.
Click the Create button to finish.
Note: You will need to download and install SQL Server Management Studio to connect to a SQL database. Also make sure to update your MS Management Studio to the latest version. You can download the latest Management Studio from Microsoft site
here.
Open SQL Server Management Studio. The "Connect to Server" window will open. Select/enter the following:
- Server Type: Database Engine
- Server Name: [The SQL server name can be found in Control Panel in Sites -> MS SQL Manager -> Manage]
- Authentication: SQL Server Authentication
- Login: [SQL database Login name]
- Password: [SQL database Password]
Click "connect" and you will be connected to the SQL server.
If you are planning to use one of the Contained Database users (SQL 2012 and 2022 only) to log into your database you will need to specify the database:
- Go to Options/Connection Properties
- Go to "Connect to database" and enter your database name
In addition to backing up your site files, our SiteBackup service can also back up your databases. Now you can control backup retention and schedule.
Automate your backups with SiteBackup.
Article ID: 1033, Created: 3/27/2012 at 4:18 PM, Modified: 1/29/2026 at 6:46 AM