Connecting to SQL Server using SQL Server Management Studio (SSMS)
The article will show you how to connect to your SQL Server via SQL Server Management Studio (SSMS) -- an integrated environment to manage a SQL Server infrastructure.
1. Locate the target SQL Server deployment
Please log in to the Control Panel https://clients.cloudclusters.io/ with your credentials and locate your target deployment on the Home page or the My Applications page.
2. Creating Databases and Users
If there is not any database or user, create the database and user first. Click the "Manage" button on the Home page or the My Applications page. Then Click the “DB & User” tab in the menu bar on the left. On the page, you can create your databases and users.
3. Get CMD / Shell connection string
Go to the "Connection Information" section on the "Overview" page to get CMD / shell connection string.
4. Connect to SQL Server using SQL Server Management Studio (SSMS)
Step 1: Install SQL Server Management Studio (SSMS)
Please refer to the guidance of installing the SQL Server Management Studio (SSMS) on Windows system.
Step 2: Connect to SQL Server
- Start SQL Server Management Studio. The first time you run SSMS, the Connect to Server window opens. If it doesn't open, you can open it manually by selecting Object Explorer > Connect > Database Engine.
Open SSMS and enter Server name, Authentication, Login and Password. On the Option page, tick the Encrypt connection and Trust server certificate option. Then connect to SQL Server.
In the Connect to Server window, follow the list below:
- For Server type, select Database Engine (usually the default option).
- For Server name, enter the name of your SQL Server instance. Please make sure to include the port at the end.
- For Authentication, select SQL Server Authentication.
- For Login, enter the name of the SQL Server user you'd like to connect with
- For Password, enter the password for the login.
Note: The Server name must contain SQL Server Port such as mssql-35988-0.cloudclusters.net,35988
- Click Options to modify connection options. Check the boxes before Encrypt Connection and Trust Server Certificate
- After you've completed all the fields, select Connect.
5. Edit and Manage your database
Congratulations! You've connected to your SQL Server successfully if you can see the database you created. Now you are ready to manage your database as you like.