Web Toolbar by Wibiya connect MS SQL 2005 database from MS SQL Management studio
   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 950 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: 160



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