Configure a Windows account for SQL Server logon

The description of the individual configuration steps below is aimed at SQL administrators and relates to Microsoft Windows Server 2008 and Microsoft SQL Server 2014 Standard or Express Edition.

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

  1. Open SQL Server Management Studio. Log on to the SQL Server with your credentials.
  2. Open the Object Explorer, right-click Security, point to New and then click Login.
  3. In Login - New on the General page, select Windows authentication.
  4. Click Search. Find the respective Windows user name and click OK. The user name is displayed as Login name.
  5. In Default Database, if a script has not been used to create a SafeGuard Enterprise Database yet, select Master.
  6. Click OK.
  7. To create the database automatically during SafeGuard Management Center first-time configuration, you have to change the access rights as follows: In Login - New, 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.