MsSQL

Creating Microsoft SQL Logins

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

To create an Microsoft SQL login:

  1. Select Microsoft SQL in the Databases menu.
  2. Click the Add New Microsoft SQL login icon at the bottom of page:

  3. Enter login and password into the Microsoft SQL Login Creation Form that shows:

    Note: you can change password by clicking the Change icon against the login name in the Controls section.

  4. Click the Submit button.
  5. Agree to additional charges.

To delete login, click the Trash icon against the login name, in the Controls section.

Important: With deleting a login, Parallels H-Sphere will delete all databases created under it and also all users under the databases. Also if you have some users under this login that are associated with another database, these users will be deleted as well. Please make sure you want to delete the login before clicking Trash.

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. Select Microsoft SQL databases in the Databases menu.
  2. Click the Add database icon at the bottom of the page that appears.
  3. Fill the MSSQL Database Creation form:

  4. Click the Submit button.
  5. Agree to additional charges.

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

To delete a database, click the Trash icon against the database name in the Controls section. Deleting a database will delete all its users.

Adding New Microsoft SQL Database Users

Users have only public, db_datareader and db_datawriter roles that allow to access database, read and write tables. Within a database, one login can be used only by one user. Mind, that the login used to enter the database is already used by you and it can’t be used to create a new user on this database. Therefore, when you create a new user to the database, the system will offer you to choose from the logins that aren’t used by this database.

To add a new user to individual Microsoft SQL database:

  1. Select Microsoft SQL databases in the Databases menu.
  2. On the page that appears, click the name of existing database or click the Edit icon in the Controls section. The following form will show:

  3. At the bottom of the page click Add icon against the Database users field. The following form will appear:

  4. Enter user name.
  5. Choose login this user will belong to and click Add.
  6. Agree to additional charges if any.

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. Select Microsoft SQL databases in the Databases menu.
  2. On the page that appears click the name of an existing database.
  3. On the form that shows, click the Change quota icon against the Database quota field.
  4. Enter new database log file ratio and total quota size on the next page:

  5. Click Submit.
  6. Agree to additional charges if any.