Skip Navigation

How do I use MS SQL Management Studio to connect to my SQL Workgroup database on my Windows VPS?

The following article explains how to use SQL Management Studio to connect to your SQL Workgroup database on your Windows VPS. Through SQL Management Studio, you can manage the information in your database directly, from your local machine, rather than having to connect to your VPS server. If you do not have a copy of Management Studio, you can obtain a copy from Microsoft by clicking here (Microsoft requires you to register first).

To connect to your database, please follow these steps:

  1. On your local machine, click Start, Programs, Microsoft SQL Server 2005 and select SQL Server Management Studio. Click Start, Programs, Microsoft SQL Server 2005 and select SQL Server Management Studio.
  2. Enter the requested information:
    • Server Type: select Database Engine
    • Server Name: enter your IP address
    • Authentication: select SQL Server Authentication
    • Login: enter the username for your database
    • Password: enter the password for your database
    Enter the requested information:
  3. Click Connect.

Management Studio will now connect you to your SQL Workgroup database.