Overview

You can configure the Surveyor database independently of installation so that the installer does not need to access the database server. This article provides information to achieve this. 

The manual process described in this article can be done before or after installation. For example, if your database administrator has time and the server is ready to go, but you are still waiting for the Surveyor server hardware, the database administrator can get started while you’re waiting for the other server.

Requirements

• Administrative access to the database server that will host the Surveyor database.
• The supported version of Microsoft SQL Server already installed.

Process

1. In the Surveyor distribution folder, navigate to the Surveyor6xx\Surveyor Server\Resources\Database folder, which contains the EnterprisePowerManagementDb.sql script:
   
   Note: Other scripts may exist in the folder. You need only the one specified here.
   
   

2. Use the process most straightforward to you to make the script file available from the database server. For example, copy it to a shared network location.

3. In SQL Server Management Studio, create a new database and name it 'EnterprisePowerManagementDB.'

4. Right-click the Users folder for the database, and choose Add Log in.

5. Add the user that you designated to run the Surveyor services.

6. Add the user to the appropriate role or configure permissions manually. The minimum required permissions are db_datareader and db_datawriter.

7. Click on New Query, and in the list of available databases, select EnterprisePowerManagementDB.

8. In Windows Explorer, navigate to the location of the script file listed in step 1, drag it to the empty new query tab in SQL Server Management Studio, and click the Execute button to run it.