Lounge Network - Knowledge Base

  View Printer Friendly Version Search
KNOWLEDGE BASE HOME » 14. INFORMATION: CORPORATE & BUSINESS HOSTING Viewing Answer
[MSSQL] How do I administrate a MSSQL database?

The following instructions apply only to our Corporate and Business Class Hosting Plans, and are paying for MSSQL access:

MSSQL 2005 databases can now be administered by using Enterprise Manager or SQl Server management Studio Express.
In order to get the SQL server address, please log into your control panel using the details provided, and navigate to ' MSSQL 2005' section, and then click on the 'Admin' Link. A popup window will appear that will tell you the server address that you need to enter into your local software.

The following applies to MSSQL 2000 databases, which have been depreciated.

Step 1: In your web browser, go to www.controlpanel.co.nz.


Figure 1

Step 2: Enter your Lounge Network Hosting Control Panel User Name and Password into the appropriate text fields, then click Logon.


Figure 2

Step 3: From the left side of the page, click MSSQL Databases under the Services tab. If MSSQL Databases is not visible, click the Services tab to expand it.


Figure 3

Step 4: All the Microsoft SQL databases currently in your account are listed on the right side of the page. Click the [Admin] link of the user that you wish to administrate the database as.


Figure 4

Step 5: The Microsoft SQL Web Database Administrator application will be launched in a new browser window. Click on the names of databases to view their tables and contents, or click the edit, query and delete links to alter the database.


Figure 5

Step 6: When you have finished editing Microsoft SQL databases you can close the Web Data Administrator window and log out of the Control Panel by clicking the logout button (shown in figure 6) in the top right corner of the screen.


Figure 6


KNOWLEDGE BASE HOME » 14. INFORMATION: CORPORATE & BUSINESS HOSTING Viewing Answer




Knowledgebase Manager

© Copyright Lounge Network 2001-2017