Steps to Install Microsoft SQL Server 2014
Note: Install the database according to the vendor's instructions. Be sure to note the database installation user name and password for use later in the installation process.
The Microsoft SQL Server Management Studio is used to create the new databases and users, as well as restore the databases from the provided backups.
Create New Databases
Using Microsoft SQL Server Management Studio, create two new databases: one for the OIPA data, and one for the IVS data.
Create Database Users
Three new database users will need to be created: two for the OIPA database and one for the IVS database.
- OIPA database user with full privileges for the OIPA database
- OIPA database user with read-only privileges for the OIPA database
- IVS database user with full privileges for the IVS database
Restore the Databases
The OIPA Media Pack includes backups of both databases that can be restored using Microsoft SQL Server Management Studio. To restore the databases, right-click on the specific database in SQL Server Management Studio and select restore. Ensure that the correct backup file is used to restore each database.
- OIPA database: oipa_pas.bak
- IVS database: oipa_ivs.bak