Create a SQL Server Account For Use By Meridian

Ideally, the SQL Server account used by Meridian should have the dbcreator server role. If your organization's security policy prohibits this, you can create an account with the necessary permissions.

Note:

A custom SQL Server account for use by Meridian may only be created and assigned after the SQL Server database has been created by Meridian as described in Configure the SQL Server Account Used By Meridian.

If you use Meridian Enterprise Server Clusters, the Publisher local user account must also be added to the SQL Server security logins on the Publisher Server PC node. The user should have the same server roles and securables permissions as the SQL Server account used by Meridian. However, if you have configured Enterprise Server to not run as a service on this PC, then the SQL Server account used by Publisher must have a user mapping to the configuration database with the dbowner database membership role.

To create a SQL Server account for use by Meridian:

  1. In SQL Server Enterprise Manager, create a new database user.

  2. In the SQL Server Login Properties dialog, on the General page select SQL Server Authentication and the vault database as the default database from the Database list.

  3. In the SQL Server Login Properties dialog, on the User Mapping page, select the user and assign the db_owner role to the user.

  4. In the SQL Server Login Properties dialog, on the Securables page, select the server you want to configure.

  5. Select Grant for the following permissions:

    • Alter Any Database

    • Connect Any Database

    • Connect SQL

    • Create Any Database

    • External Access Assembly

    • View Any Database

  6. Configure Meridian to use the new account name as described in Configure the SQL Server Account Used By Meridian.

2022 R2