Search  
   
Browse by Category
 
Netfirms 24/7 Support .: WINDOWS HOSTING .: How do I manage my MSSQL databases?

How do I manage my MSSQL databases?

Your Control Panel includes an interface to manage your MSSQL databases:

1. Login to your Netfirms Control Panel at https://controlpanel.netfirms.com
2. Click Hosting
3. Choose Databases
4. Click
 MSSQL

To add a MSSQL database:

5. From the Add Database tab, enter a Description of the new database
7. Click Create 
8. Note the database id, username, and password OR check your admin contact email address for the information

To administer a MSSQL database:

5. For the database you wish to administer, click the corresponding mssqladmin link

To add a user login for a MSSQL database:

5. Click the Add Database User tab
6. From the Database pull-down menu, select the Database Name you wish to add a user account for
7. From the Type pull-down menu, select the permission level you wish to assign the user account

NOTE: Read and Write permissions will allow administrative privileges to the user account. Read permissions will allow non-administrative privileges.

To change a user password for a MSSQL database:

5. For the database you wish to change a user login for, click the corresponding plus sign to the left of the Database Name
6. Click the Password tab
7. In the Enter New Password box, enter a new password
8. In the Confirm Password box, enter the new password again to verify
9. Click Update to modify the password. Wait a few moments for the new password to become active.

To delete a MSSQL database:

5. For the database you wish to delete, click the corresponding Delete link
6. Click Yes to confirm the deletion 

How helpful was this article to you?


.: Powered by Lore 1.5.6
Visit Netfirms.com Web Hosting | Copyright © 1998 - 2009 Netfirms, Inc. All Rights Reserved.