How to create an installation without system administrator privileges

If you do not have the appropriate permission to create SQL Server databases, you cannot use the New Installation wizard to create the management database without the assistance of a database administrator.

If you do not have system administrator privileges, the wizard prompts you to specify another set of credentials or generate SQL scripts to give to a database administrator.

If you don’t have a database administrator immediately available who can enter the credentials for you, you cannot continue with the installation.

To create an installation when you don’t have system administrator privileges:

  1. Select the option to generate the SQL scripts, then click Next.
  2. Select the folder location for the scripts, then click Next.
  3. Review details about the installation and management database you want created, then click Next.

    The wizard generates two scripts: Script1 prepares the SQL Server instance for the management database and Script2 creates the database.

  4. Click Finish to exit the New Installation wizard.

  5. Send the scripts to a database administrator with a service or change-control request.

    Note:   You should notify the database administrator that the scripts must be run in the proper sequence and not modified in any way. Changes to the scripts could render the database unusable.

  6. After the database administrator creates the database using the scripts, open the Audit Manager console to run the New Installation wizard again.

  7. Type the name of the installation, then click Next.

  8. Select Use an existing database and verify the database server and instance name, then click the Database name list to browse for the database name that the database administrator created for you.

    If the server does not use the default TCP port, specify the port number as part of the server name. For example, if the port number is 1234, the server name would be similar to ACME\BOSTON,1234.

    If you're installing on a SQL cluster, enter the SQL cluster name in the SQL Server computer name field.

  9. Select the database name from the list of available databases, click OK, then click Next.

    You should only select an existing database if the database was created using scripts provided by Centrify.

  10. Select Use the default NT AUTHORITY\SYSTEM account to use the internal account or select a specific SQL login account with sufficient privileges, then click Next.

    A SQL login account is required to run the stored procedures that read and write information to the management database. The account must a member of the system administrator (sa) fixed server role on the selected database server.

  11. Type a license key or import licenses from a file, then click Next.

  12. Review details about the management database to be installed, then click Next.

  13. Select the Launch Add Audit Store Wizard option if you want to start the Add Audit Store wizard, then click Finish.