Options > System > Database

SpaceObServer uses a database to store structures and sizes of scanned directories. We recommend using the newest supported version of MS SQL Server, because it offers the best performance with the current version of SpaceObServer.

If you want to use a SQL Server database, but you have no licensed copy, you can use the free "MS SQL Server Express" database.
Use the link "Download and Install free MS SQL Server Express" in the Options dialog to start the download and installation.
The default name of the MS SQL Express installation is "<machine name>\SpaceObServer".
The password of the default user "sa" is set to "SpaceObServer_Pwd1".

Please note: The maximum database is limited to 10 GB allocated space, 1 socket/4 cores and 1 GB cache (RAM) in the Express version.

We also offer SpaceObServer in combination with a Microsoft SQL Server Standard Edition, incl. 1 Client Access License, Runtime License" on our website.

Please note: The Standard Edition supports up to 128 GB Cache (RAM), 4 sockets/24 cores and up to 524 PB database space.

In some cases a reboot of your system is needed after the installation of the MS SQL Server is complete.

If you do not use the integrated MS SQL Express installation or you want to use another user account for the database, please read the following sections.

In order to communicate with the database, you can you can use the built-in "Windows Authentication" (for Microsoft database systems) or the "SQL Server authentication".

Below you will find the steps to create a new MS SQL user with the necessary permissions to let SpaceObServer communicate with the database:

Note: You need at least ALTER ANY USER permission on the database to perform the operations below.

1.Open the Microsoft SQL Server Management Studio and connect to the SpaceObServer database server.

2.In the Object Explorer, expand the folder of the SpaceObServer database instance to create the new login.

3.Select the "Security" folder and select "New> Login ..." via the context menu.

4.Under "General" in the upcoming dialog you can select a desired user name, e.g. "SpaceObServer Admin". Then select the underlying radio button "SQL Server authentication" and specify a desired password for the user. This information can be used to connect SpaceObServer to the database.

5.Disable the checkbox "User must change password at next login".

6.Now select the "Server Roles" tab. Select the role "dbcreator" in addition to the already selected role "public", in order to grant the user the permission to create a new database.

7.Close the dialog by clicking the 'OK' button. The permissions can be changed at any time via the context menu ("Security> Login> username -> right-click" Properties ") of the new user.

After creating the new database user you can create a new database via the SpaceObServer user interface using the newly created user. To do so, the following steps must be performed:

1.Start SpaceObServer and open the options dialog via "Tools > Options...".

2.Select the "Database" tab.

3.Choose "MS SQL Server" as database type. Enter the name of the SpaceObServer database server in the dropdown field below. You can also choose a server from the accessible SQL Servers which are available in your network.
Note: Sometimes not all SQL servers can be listed. If your server is not listed, please type its name manually into the field! When you have selected a server you may select a database on this server using the "Database" drop down box. If you do not select a database, the default database of the selected database user is used.

4.Before you can create a new database, please choose "SQL Server authentication" in the "Login Info" section below and enter the user credentials of the previously created user.

5.Afterwards click the button on the right to create a new database and enter a database name in the upcoming dialog.

6.Confirm your input by clicking the "OK" button and close the options dialog by clicking the "OK" button again.

The new database is now in use. You can add new scans to the database via "Scan > Configure Scans...". The scans can be executed via the "Scan now" button.

Additional information how to create and configure a new user login can be found here.