Settings

The Microsoft SQL Settings screen is divided in three main panels, Database information, Database settings and Database usage.

Database Information

This panel displays the database name, the server name and your usernames. The server and login information are the same as that you received via e-mail when you activated your service.

Add description allows you to add a description of your database. If you have several databases you can easily add a description about the content of the site it is connected to. Once you have added the description, you are able to modify it by clicking Edit description.

Here you are also able to view the three available users, one administrator, one writer and one reader.

The user defined as the Administrator is able to administrate the database. The Administrator is sometimes needed when you self-install CMS systems where the database is setup automatically in the process. The user defined as the Administrator is a modified db_dlladmin user with both additional and denied privileges.

The additional privileges allow dbo schema control, showplan, alter any application role, create schema and view database state. The denied privileges include alter any assembly, asymmetric keys, certificates, data space or database DLL triggers, create full text catalogue, alter any full text catalogue and checkpoint.
The user defined as the Writer (db_datawriter) is allowed to add, change and delete data from any user table in the database. The Writer user is necessary when an application has functionality for both reading, editing and/or deleting data from the database.
The user defined as the Reader (db_datareader) is allowed to read all data from any user table in the database. The Reader is often used in applications that only read and/or display data from the database.

If you want to create a new password for your users, you are able to do so through the Create Password screen.

We recommend that you download Microsoft Management Studio; you are able to do so by clicking on the Download link. Microsoft Management Studio is an integrated environment that allows you to access, configure, manage, administer and develop components of the Microsoft SQL Server. In addition, it combines a broad group of graphical tools and rich script editors that provide access to the Microsoft SQL Server for developers and administrators of all skill levels.

Database settings

This panel allows you to define the compatibility level of your database, as well as the collation set.

In order to change the compatibility level or the collation, click on Edit, use the corresponding drop-down list to modify your selection and click Save.

Compatibility level is only needed when you are moving or copying a database from an older version of Microsoft SQL to our Microsoft SQL 2008 platform. Note that selecting the same version from which the database is copied from will guarantee the same behaviour as before.

Collation is a regional setting for your database and should be set matching most users of the database. The selection will effect dictionary order, case sensitivity and uppercase performance to name a few.

The collation is or can be set on four levels; server, database, column and expression. In myMamut the database collation is set. The server is set up with Latin1 General CI AS and cannot be changed. Column and expression collation is set by using queries.

Read more about the different types of collation sets here (external link).

Database usage

The database usage panel provides you with information about the total storage of your database, as well as specific details on how much storage is assigned to database data (data storage used) and transaction log files (log storage used).

The Quota ratio shows how much of your total storage is used for data storage and log files. Use the Change ratio button in order to change the relation in percentage between the data and the log file designated storage.