Control Panel MSSQL


How to setup and configure various aspects of MS SQL in your control panel.


Creating Microsoft SQL Logins

Logins are used to access Microsoft SQL server and to create database users. You should create logins for as many users you will have.

To create an Microsoft SQL login:

  1. Navigate to Databases > MS SQL > MS SQL Logins.
  2. Select the Add icon.
  3. Input the details for the new database login and click Submit.
  4. Agree to any additional charges if there are any.

Deleting Microsoft SQL Logins

  1. Navigate to Databases > MS SQL > MS SQL Logins.
  2. Select the delete icon next to the login you wish to delete.
  3. Agree to any refunds you may be suitable for

Changing Microsoft SQL Database Quota

Total quota size is the disk space allocated for the database file and the transaction log file. Database/Transaction Log file quota ratio is the portion of disk space allocated for the database file. If you set the total quota size to 100 MB and the database/transaction log file quota ratio to 40%, then the maximum database file quota is 40 MB and the maximum log file quota is 60 MB. The more dynamic your database is, the bigger transaction log file quota ratio should be.

To change the quota:

  1. Navigate to Databases > MS SQL > MS SQL DBs.
  2. Click the Edit icon next to the domain that you wish to change the quota for.
  3. Click the Edit icon in the Database Quota section.
  4. Enter the new database:log ratio and the new quota size you wish to use. Click Submit.

Creating Microsoft SQL Databases

Databases are created under logins and there can be several databases under one login.

To create a Microsoft SQL database

  1. Navigate to Databases > MS SQL > MS SQL DBs.
  2. Click the Add database icon.
  3. Input the name of the new database and select the database login you wish to assign to the database. Click Submit.
  4. Agree to any additional charges if there are any.

Important: When Microsoft SQL creates a database, it automatically creates a user with the same name as the login this database was created under.


Deleting a Microsoft SQL Database

  1. Navigate to Databases > MS SQL > MS SQL DBs.
  2. Select the Delete Icon next to the database you wish to delete.
  3. Agree to any eligibility you have to a refund.

Adding New Microsoft SQL Database Users

  1. Navigate to Databases > MS SQL > MS SQL DBs.
  2. Click the Edit icon next to the domain that you wish to add a user to.
  3. Click the Add icon in the database users section.
  4. Input the username and MSSQL login you wish to add the user to. Click Add.
  5. Agree to any additional charges.