User GuidesDeveloper ReferenceSupportFAQsLog in

Login to the SQL Server

Prerequisites: Make sure you are logged in to the Windows Server using the Remote Console in the DCD. For more information, see Connect via Remote Console. Alternatively, you can access the server using Remote Desktop Protocol (RDP) when connected to the internet.

Start SQL Server Management Studio

You can start the SQL Server Management Studio using one of the following options:

Option 1:

  • Start the SQL Server Management Studio from the taskbar.

Start SQL Server Management Studio from the taskbar

Option 2:

  • Type SSMS in the search box and start the program.

Start SQL Server Management Studio from search box

Option 3:

1. Press the Windows key + R. 2. Type SSMS in the next dialog box. 3. Click Enter.

Result: You have successfully started the SQL Server Management Studio.

Connect to Microsoft SQL Server

  • Once the login window is started, select Windows Authentication and adjust the Encryption to Optional to be able to connect to the SQL Server.

Note: The Optional encryption setting lets you connect to the SQL Server instance immediately without encryption. Alternatively, you need a valid certificate from trusted certificate authority.

SQL Server encryption type

Result: You have successfully connected to the SQL Server.

Note: By default, the local server's hostname is the Server name. All members of the Local Administrators group have system administrator rights to the SQL Server.

Microsoft SQL Server Management Studio (Administrator)
PreviousSelect a Microsoft SQL Server ImageNextSet Up Network and Firewalls

Last updated

Was this helpful?