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)
