Unable to manage MSSQL 2005 Database




Lack of knowledge in managing MSSQL 2005 database.


Step 1: Download the Microsoft SQL Server Management Studio Express from here or you may use the Microsoft SQL Server Management Studio installed from MSSQL Standard/Enterprise Installation CD.

Step 2: Kindly ensure MS XML 6 is installed in your local PC/Workstation before proceeding with the installation of Microsoft SQL Server Management Studio Express. You can download the MS XML 6 installation file from here.

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

Step 4: After you have done the installation. Click Start -> All Programs -> Microsoft SQL server 2005 -> SQL Server Management Studio Express CTP or SQL Server Management Studio.

Step 5: Following screen will appear.

Enter the following as to connect to the remote MSSQL Server.

  • Server Name: YOURDOMAINNAME,1733 (e.g:,1733)
  • Authentication: SQL Server Authentication
  • Login: DatabaseUserName (Where you have created under Helm Control Panel/WebSitePanel)
  • Password: DatabasePassword (Where you have assigned to the Database User via Helm Control Panel/WebSitePanel)

Step 6: Click on the Connect button and you will be connected remotely to your MSSQL2005 server as to manage your database.

Additional Information

If the problem still persist, kindly issue a ticket to Support Team