Once all of the prerequisites for the DB Precision Database Server have been installed, proceed with the following steps on the database server.

However, if this is a new installation of SQL Server, you may first want to review our topic on SQL Server Installation before proceeding.

• 1) Database Creation: open SQL Server Management Studio (SSMS) and create the following 3 databases: PSCommon, PSPrecision, PSArchive.
  
  Please note that all 3 databases may be located on the same server or each may reside on separate servers.
• 2) Database Restore: right-click each newly created database (under the Databases item within Object Explorer of SSMS) and select Tasks - Restore - Database... from the resulting menu.
  
  On the General page of the Restore Database screen, under Source, select the Device option and then navigate to the backup file for each database (provided to you by us). Each backup file will correspond to the 3 databases named above. For example, for PSPrecision, you will want to restore the database PSPrecision using the file PSPrecision.bak.
  
  On the Options page of the Restore Database screen, under Restore options, make sure that the box Overwrite the existing database (WITH REPLACE) is checked and that no other boxes on this screen are checked.
  
  Press the OK button on the Restore Database screen to complete the database restore.
  
  Repeat this step for all 3 databases (PSCommon, PSPrecision, and PSArchive).
• 3) Create SQL Login: expand out both the Security item and then the Logins item of Object Explorer of SSMS. Then create a new SQL Login by right-clicking Logins and selecting New Login... from the resulting menu.
  
  This will open the Login - New screen where, on the General page, you will then enter PSUser for Login name. Select SQL Server authentication and uncheck Enforce password policy.
  
  Choose a password that is no more than 16 characters in length. Make sure to keep this in a secure place as you will need this for each Network Client Installation.
  
  On the User Mapping page, check the Map box for the 3 database PSCommon, PSPrecision and PSArchive. Make sure for all 3 databases that db_owner and public are checked under the Database role membership section of this page.

If you have completed the steps above, then you should proceed with the Network Client Installation.