Preparing the database server

Follow these instructions to prepare the database server.

Before you begin, run or verify that you have a valid and up-to-date backup of the current Discover databases.

Before you upgrade the databases, verify the following:

  • If you are upgrading on a remote server, you must create the filegroup paths on the remote SQL Server before you upgrade.
  • If you are not logged in as a user with admin privileges on the database, make the following entries or selections in the Authentication box:
    • Manual Authentication
    • User name: <SQL Server login>
    • Password: <password>
    Note: Do not use Discover authentication during an upgrade.
  • The user that installs the databases must have access to a user account that has permissions to create databases on the remote SQL Server. You must be logged in as a trusted user that has admin privileges, or you must have the user name and password for an authorized SQL Server login.
    Note: To upgrade the databases, the database user account must have SA privileges.