Back to Knowledge Base

How to Connect to Your Database using SSMS

Database

Connecting with SQL Server Management Studio

To connect to your SmarterWebhosting SQL Server database, you will need SQL Server Management Studio (SSMS) installed on your local machine.

Step-by-Step Guide

  1. Open SQL Server Management Studio.
  2. In the Connect to Server dialog, select Database Engine as the Server type.
  3. Enter the Server name provided in your Welcome Email (e.g., sql1.smarterwebhosting.com).
  4. Select SQL Server Authentication from the Authentication dropdown.
  5. Enter your Database Username and Password.
  6. Click Connect.

Note: Make sure you have whitelisted your local IP address in the Client Portal if you are having trouble connecting.