Using Microsoft SQL Server Management Studio to Connect Microsoft SQL Database

1. Download the Microsoft SQL Server Management Studio Express from Microsoft website that you may get by clicking here.

2. You will also need to install the MS XML 6 on your local terminal before proceeding the installation of Microsoft SQL Server Management Studio Express. You can download the MS XML 6 from here.

3. Follow the installation instruction as shown in the Microsoft SQL Server Management Studio Express.

** Please be reminded to have take note on the requirements listed on the download page.

4. Once the application has been installed on your local terminal, click Start > All Programs > Microsoft SQL server 2005 > SQL Server Management Studio

5. You will get a login screen as follow:

SQL  2005 Login Prompt

Please fill in the details as follow:

Server name: Our Server IP Address is stated in your Hosting Welcome Email ( refer notes below )

Authentication: SQL Server Authentication
Login: YourMSSQLDatabaseUsername
Password: YourMSSQLDatabasePassword

6. Once you have enter the above information, click the 'Connect' button and you will be connected remotely to your MS SQL database hosted in our SQL 2005 server.


- Please make sure your local firewall is not blocking Port 1533.

Kindly create database first and assign user to it using Plesk Control Panel before you can connect to it via SQL Managament Studio

  • 1 Users Found This Useful
Was this answer helpful?

Related Articles

How can i access MSSQL 2005?

There are 2 options to access MSSQL 2005 database. You can use Enterprise Manager web...

Can I connect to MS SQL 2005 database server using MS SQL 2000 Enterprise Manager?

You are not able to connect using the MS SQL 2000 Enterprise Manager to the MS SQL 2005...

Using Enterprise Manager to Connect Microsoft SQL 2000 Database

1. Open the SQL Server Client Network Utility: Start > Programs > Microsoft...

Connect to MS SQL Server Database

Connection String "Provider=SQLOLEDB; " & _ "Data Source =...

Microsoft OLE DB Provider for SQL Server error '80004005'

Error Message: Microsoft OLE DB Provider for SQL Server error '80004005'...