Home   Help Login Register  
Welcome, Guest. Please login or register.

Login with username, password and session length

Search
Pages: [1]
Print
Topic: connect MS SQL 2005 database from MS SQL Management studio  (Read 570 times)
0 Members and 1 Guest are viewing this topic.
« on: July 20, 2009, 10:13:34 PM »
Janak
Administrator
Full Member

View Profile
*****
Posts: 119



In order to connect MS SQL 2005 database from MS SQL Management studio follow below mentioned steps:

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:

    * Server Type: Database Engine
    * Server Name: Enter the Public IP Address of the database server and port number in the format IP address, port number. (For example, 12.14.1.1,1533)
    * Authentication type: SQL Server Authentication
    * Login: The database username you created in your Database Manager within your Helm Control Panel for the domain.
    * Password: The database username password you created in your Database Manager within your Helm Control Panel for the domain.

5. Connect.

Thanks!

Janak
Logged

Pages: [1]
Print
Jump to:  

� 2006 VPS forum, VPS hosting forums, VPS discussions, VPS web hosting solutions, issues, providers, virtual web hosting questions, VPS hosting
Powered by SMF 1.1.11 | SMF © 2006-2009, Simple Machines LLC | Forum style designed by PixelSlot
| Sitemap - XML Sitemap