Connecting to SQL Server using Command Prompt (Windows) or Shell (Linux).
The article will show you how to connect to your SQL Server via command prompt (Windows) or Shell (Linux).
Note: For security reasons, only the accounts have passed our verification will be granted permission to the Shell / SSH service. If you would like to enable it, please update your billing information. Our staff will finish verifying your information within 2 hours.
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 the SQL server
Step 1: Install sqlcmd utility
Please refer to the guidance of installing the sqlcmd utility on Windows or Linux system.
Step 2: Connect to SQL Server
Please copy the connection string to the command window. Replace the
<Password> with the user and password of your database in order to connect to the MSSQL Server.