Knowledge Base

Using Microsoft SQL Server Management Studio

This article describes how to use Microsoft SQL Server Management Studio with your Windows Hosting account.

Creating a Microsoft SQL Server account

Before you can use SQL Server Management Studio, you must first create a SQL Server account in Plesk. To do this, follow these steps:

  1. Log in to Plesk.
    If you do not know how to log in to your Plesk account, please see this article.
  2. In the left sidebar, click Databases.
  3. In the right sidebar, click User Management:

    Plesk - Databases - User Management

  4. On the Database Users page, click Add Database User:

    Plesk - Databases - Add Database User button

    1. On the Adding Database User page, in the Database server list box, select the SQL cluster server for your account:

      Plesk - Databases - Adding Database User page

      The following table lists all of the SQL cluster servers currently in use:

      Server hostname Server IP address
      a2wsql1.a2hosting.com 70.32.28.3
  5. In the Database user name text box, type a username.
  6. In the New password and Confirm password text boxes, type a password for the new user.

    Alternatively, you can click Generate and Plesk generates a random, strong password for you. (Make sure you click Show so you can see what the password is!)
  7. In the Database list box, select Any.
  8. Click OK.

Accessing your Microsoft SQL Server account

After you create a Microsoft SQL Server account in Plesk, you are ready to connect to it using SQL Server Management Studio. To do this, follow these steps:

  1. Start Microsoft SQL Server Management Studio.
  2. On the File menu, click Connect Object Explorer. The Connect to Server dialog box appears:

    Microsoft SQL Server Management Studio - Connect to Server dialog box

  3. In the Server type list box, select Database Engine.
  4. In the Server name text box, type the name of the SQL cluster server for your account.
  5. In the Authentication list box, select SQL Server Authentication.
  6. In the Login text box, type the Microsoft SQL Server username you created in the previous procedure.
  7. In the Password text box, type the password for the Microsoft SQL Server username you created in the previous procedure.

    If you do not want to re-type the password every time you connect to the server, select the Remember password check box.
  8. Click Connect. After a few seconds SQL Server Management Studio connects to the server.
  9. Click the plus (+) sign next to Databases to expand the view, and then click the plus (+) sign next to your username to view the objects in your account.

More Information

For more information about Microsoft SQL Server Management Studio, please visit https://msdn.microsoft.com/en-us/library/hh213248.aspx.