Sync Server Database

Each Specops Password Sync Server maintains a local SQL server Compact Edition database. The database keeps the passwords configured in all the Sync Providers in a secure location. The database also temporarily stores pending password changes.

When the Sync Server is started for the first time, it will copy an empty database file from the service installation directory to the designated database path. The default path will differ depending on the version of Windows the service is running on:

Windows version Default database path
Windows Server 2003
Windows Server 2003 R2
 C:\Documents and Settings\Default User\Local Settings\Application Data
Windows Server 2008
Windows Server 2008 R2
Windows Server 2012
Windows Server 2012 R2
 C:\Windows\System32\config\systemprofile\AppData\Local

If you need to change the database location, you will need to follow the below steps:

  1. Stop the Specops Password Sync Server service.
  2. Copy the existing database file to the new location.
  3. Change the “DatabaseFilePath” registry setting to point to the new location.
  4. Restart the Specops Password Sync Server service.