The Database
Microsoft® SQL Server® Database
Mamut Business Software is based on the Microsoft SQL Server database. The Mamut Business Software installer will detect any previous Microsoft SQL Server installations automatically. Microsoft SQL Server will be installed if no previous installations are detected.®
If you choose the default single-user installation, the program will only be used on one computer; this computer will act as the database server.
If you choose a multi-user installation, one of the computers within the network will act as the database server. If no previous installation can be detected on this server, the Microsoft SQL Server will be installed.
If you choose a client installation - through which you connect to a database server already available within the network - you will not be required to install Microsoft SQL Server when installing the Mamut Business Software program files.
Note! You should avoid changing the
name of the computer containing the SQL Server database since this may
create problems for other programs using SQL Server.
Read more in About Installation
Read more in About Multi-user Installations
Instance
A database server can have several different instances. When installing Mamut Business Software, MAMUT will be suggested as the default instance name. You can enter a different instance name if you already have access to an existing instance for example. In order to get a full overview of the systems, it is recommended that you create your own instance for the Mamut Business Software database.
The database server name will often consist of the server name plus the instance name. An example of a database server can be: SERVERNAME\MAMUT.
Note! Instance name is only required
if you will be running several SQL Servers on the same computer.
An instance can contain one or several databases. The Mamut Business Software database consists of one system database and one or several company databases.
Read more in Installed Files
System Database
The program's database consists of company database files and system files. The company database files contain data relevant to the various company databases, while the system files contain data which is shared by all company databases. Shared information can, for example, include information about users and access information.
Tip! Information about the server name,
instance and system database is stored in the settings under View
- Settings - Other Settings - Other Programs.
Company Database
A company database represents one business or part of a business. Where book-keeping agencies refer to 'clients', other users handling several companies may view one company database as one company/organisation. It is possible to manage several company databases in a single program installation. The maximum number of company databases is determined by your license.
Read more in Company Databases
Security
The SQL Server installed with Mamut Business Software uses SQL Authentication by default. The system administrator can differentiate between the users' database access in the SQL Server.
Tip!
The system administrator can override this so that Windows Authentication
is used. You need SQL Server Management Studio Express to do this. Deactivate
login for the user <Mamut>, or deactivate all SQL Authentication
for all programs.
Database Maintenance
Maintenance tasks such as repairing, re-indexing, or compressing the database are performed using a separate application called DataTools. DataTools is a tool for database administration, and supports the most common administrative tools for the SQL Server-based databases. The application is automatically installed with the installation of Mamut Business Software and it can be launched by double-clicking the file MDataTools.exe. This is located in the DataTools folder, where the Mamut Business Software program files were installed. You can find the location of the program files by navigating to File - Database Utilities - Go to the System's Program Folder within Mamut Business Software.
In addition to maintenance tasks, you are also able to create and restore backup copies using DataTools. More information can be found within the DataTools help files.
Performance
The Mircosoft SQL Server has its own limitations which are handled by Microsoft. You can upgrade to a larger version of the SQL Server database software or install a larger version side by side of Microsoft SQL Server Express. Read more about this on our website.®®
Read more about:
Creating a New Company Database