Create an SQL account for SQL Server logon

Every user that should be able to use the SafeGuard Management Center must have a valid SQL User account when using Windows authentication to connect to the SafeGuard database.

The description of the individual configuration steps below is aimed at SQL administrators. It relates to Microsoft Windows Server 2008 (all editions) with Microsoft SQL Server 2008 Standard Edition.

As an SQL administrator, you need the right to create an SQL user account.

  1. Open SQL Server Management Studio. Log on to the SQL Server with your credentials.
  2. Open the Object Explorer, right-click Security and select New > Login.
  3. In Login - New on the General page, select SQL Server authentication.
  4. On the General page, in Login name, do the following:
    1. Enter the name of the new user, for example SGN SQLSERVICE.
    2. Enter and confirm a password for the account.
    3. Clear Enforce password policy.
    4. In Default Database, if a script has not been used to create a SafeGuard Enterprise Database yet, select Master. Click OK.

    Take a note of the authentication method and the credentials. You have to inform the SafeGuard Management Center security officer about them.

  5. To create the database automatically during SafeGuard Management Center first-time configuration, you have to change the access rights as follows: In Login - New on the General page, assign the access rights/roles by clicking Server Roles on the left. Select dbcreator. Once SafeGuard Enterprise has been installed, the database role can be reset to dbowner.

The SQL user account and the access rights are now set up for the SafeGuard Enterprise security officer.