Knowledgebase: Database
HOW TO: Connect to SQL Server using SQL Server Management Studio
Posted by on 03 October 2018 12:44 PM

Before you attempt to connect, make sure you have created a database in your hosting account. To connect to your SQL database using SQL Server Management Studio (SSMS), follow the steps listed below:

  1. Open SQL Server Management Studio, the Connect to Serverwindow will open. Select/enter the following:
    • Server Type: Database Engine
    • Server Name: [The SQL server name can be found in the Welcome message]
    • Authentication: SQL Server Authentication
    • Login: [Enter your database username, this is the username you chose when you created your database]
    • Password: [Enter your database password, this is the password you chose when you created your database]
  2. Click Connectand you will be connected to the SQL server.
  3. 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.

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

 

Tutorials on SQL Server Management Studio (SSMS) : https://docs.microsoft.com/en-us/sql/ssms/tutorials/tutorial-sql-server-management-studio?view=sql-server-2017

(0 vote(s))
Helpful
Not helpful

Comments (0)
Copyright © 1998 - 2021 Shinjiru International Inc. All Rights Reserved.