How to connect to MSSQL database using SQL Server Management Studio?

To manage your MS SQL database using SQL Server Management Studio.
SQL Server Management Studio can be downloaded for free from Microsoft's website.

1. Open SQL Server Management Studio.
2. Fill in the following:

Server name: [THE MSSQL SERVER IP],[PORT NUMBER]
Authentication: SQL Server Authentication
Login: [YOUR MSSQL DATABASE USER]
Password: [YOUR MSSQL DATABASE USER PASSWORD]

3. Click Connect to connect to the database server.

Note: You can obtain your MS SQL Server IP address and custom port from the Welcome Email that we send to you when you first sign up your hosting account.
Note: If you unable to access the MS SQL database, it may be the port number is closed from external access for security reason. Submit a ticket at http://support.yeahhost.com.my and request to open the port in order to access the database.

  • 2 Users Found This Useful
Was this answer helpful?

Related Articles

SolidCP & MSPControl: Create MS SQL database

Please follow the steps below to create your MSSQL Server Database in control panel. * Please...

SolidCP & MSPControl: How to backup MSSQL database via control panel

You can backup the entire MSSQL database from hosting control panel.Please follow the steps below...

How to connect to older version MS SQL using Enterprise Manager?

To connect to older version of MS SQL database (such as MS SQL 2000), you can use Enterprise...

Connection strings for SQL Server

Connection string is a string that contains information about a data source and means of...

SolidCP & MSPControl: How to restore MSSQL database via control panel

You can restore the entire MSSQL database from the web hosting control panel.Please follow the...