Assign the SQL Server system role sysadmin to the vRealize Automation service account.

About this task

vRealize Automation uses the SQL Server system role privilege to create and run scripts on the SQL Server database. By default, only users who are members of the sysadmin system role, or the db_owner and db_ddladmin database roles, can create objects in the database. 

Procedure

  1. Log in to the SQL Server virtual machine by using a Remote Desktop Protocol (RDP) client.
    1. Open an RDP connection to the vra01mssql01.rainpole.local virtual machine.
    2. Log in using the following credentials.

      Settings

      Value

      User name

      Windows administrator user

      Password

      windows_administrator_password

  2. From the Start menu, click All Programs, click Microsoft SQL Server, and click SQL Server Management Studio.
    Note:

    If SQL Server Management Studio does not appear in your All Programs menu, you may not have successfully installed SQL Server Management Studio. Verify that you have successfully installed SQL Server Management Studio, and then continue with this procedure.

  3. In the Connect to Server dialog box, leave the default value of the Server Name text box, select Windows Authentication from the Authentication drop-down menu, and click Connect.
    Note:

    During the SQL Server installation, the Database Engine configuration wizard prompts you to provide the user name and password for the SQL Server administrator. If this user was not added during the SQL Server installation, select SQL Authentication from the Authentication drop-down menu, and enter the user name sa in the User name text box, and the password sa_password in the Password text box.

  4. In the Object Explorer pane, expand the VRA01MSSQL01 server instance .
  5. Right-click the Security folder, click New, and click Login.

  6. In the Login Properties dialog box, click the General page and enter rainpole\svc-vra in the Login name text box.

  7. Click the Server Roles page, select the sysadmin check box, and click OK.