Answer:
- If a server migration or new installation was completed, back up the NpsSqlSys from the previous system: File > Backup > NpsSqlSys.
- Copy the NpsSqlSys into the SQL backup folder on the new system.
- Restore the NpsSqlSys to the new system: File>Restore>NpsSqlSys and choose the back file to restore from.
- If a server migration or new installation was not performed, then the NpsSqlSys might have become corrupt.
- Contact support to have a blank NpsSqlSys restored and then create new users.
Additional Information:
Backing up Database
You can back up and restore all organization databases and the system database (NPSSQLSYS) for the current version.When running a backup, the system creates an uncompressed copy of the database. You can back up any database while users are in the system. However, to restore a database, all users must exit the system.
- Find the backup directory on your server.
- Log on to Administration.
- Open the File>Backup form.
- Select the database you want to back up from the Database to Backup drop-down list.
- Accept the default name (the database name, date, and time) or enter another name in the Backup to File box.
- If needed, click the Browse button and select the backup directory.
- Click the Start button, and the log on screen appears. Log on to the system.
Restoring Database
- Log on to Administration.
- Open the File>Restore form.
- Select the database to restore from the drop-down list. If this is the first time a database has been restored, its name is not available in the drop-down list; you must enter a name here.
- Enter the name in the Restore to File box.
- Click the Browse button to locate the file.
- Click the Start button.