Issue
Unable to manage MSSQL 2005 Database
Symptoms
None
Cause
Lack of knowledge in managing MSSQL 2005 database.
Workaround
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: netonboard.com,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