Knowledgebase: Database
Connecting to SQL 2005 Database using MS SQL Management Studio
Posted by - NA - on 23 May 2008 07:10 AM
Here are the steps to connect to the MS SQL 2005 Server Database using MS SQL Management Studio:

1. Start SQL Server Management Studio.

2. Click the 'Register Servers' icon on the toolbar.

3. The Register Servers panel should now be visible at the left hand frame, with a node 'Database Engine'. Right click on the node 'Database Engine' and from the context menu, select New -> Server Registration.

4. The 'New Server Registration' window will be visible:

    a. Server Type: Database Engine
 
    b. Server Name: Enter the Public IP Address of the database server and port number in the format ip_address,port_number. This information can be obtained from your Database Manager within your Helm Control Panel for the domain, for example 72.18.135.40,1533

    c. Authentication type: SQL Server Authentication

    d. Login: The database username you created in your Database Manager within your Helm Control Panel for the domain.

    e. Password: The database username password you created in your Database Manager within your Helm Control Panel for the domain.

5. Connect.

(402 votes)
This article was helpful
This article was not helpful

Comments (0)
Help Desk Software by Kayako Resolve