How to connect to a SQL server using SQL Server Management Studio

Winhost > Databases
Before you attempt to connect, make sure you have created a database in Control Panel using the MS SQL Manager tool.

Creating a New MS SQL Database in WinHost

  1. Log in to your WinHost Control Panel at
    https://cp.winhost.com

  2. In the navigation menu under the WinHost logo, click the Sites tab.

  3. Click the site link for which you would like to create a database.

  4. Click the MS SQL Manager button.

  5. Click the Add button.

  6. Choose the desired database version.

  7. Enter the database suffix and quota for the new database.

  8. 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, , Modified: 1/29/2026 at 6:46 AM

Was this article helpful?

Share this article
Bluesky
Facebook
Threads
X / Twitter
Other Social Networks
Print