Using Microsoft SQL Server Management Studio

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.
2. In the left sidebar, click Databases.
3. In the right sidebar, click User Management:

   

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

   

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

      

5. In the Database username 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:

   

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 checkbox.
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.