Configuring an SQL Server Service Account

By default, the SQL Server Setup creates a virtual service account for executing SQL Server services with the name "NT SERVICE\MSSQLSERVER".

This account only will work correctly if you have an environment with a single Windows domain.

In an environment with complex domains (Forest, Trust Relationship , etc.) the virtual service account will often not work correctly. One result can be that in Citavi the team members in a DBServer project cannot be displayed.

Perform the following steps in a complex domain environment: 

When reinstalling MS SQL Server

1. Manually create a service account in the same domain that contains the user accounts for Citavi for DBServer .
2. Use the original Microsoft Setup file for the installation.
3. Assign the created account in the corresponding Setup Assistant step as the SQL Server Service account .

In an existing installation of MS SQL Server

1. Manually create a service account in the same domain that contains the user accounts for Citavi for DBServer .
2. On the server computer, start the SQL Server Configuration Manager.
3. In the left column, select SQL Server Services.
4. Double-click SQL Server in the right column.
5. On the Log On tab, select the account you created. SQL Server Configuration Manager assigns the necessary rights automatically when the service account is changed. 

Please note:

Do not use the Windows Services program. Services does not change any permissions. That means that SQL Server would no longer work after changing the account when using this method.