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

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

Procedure

  1. Log in to the Microsoft SQL Server virtual machine as an administrative account by using a Remote Desktop Protocol (RDP) client.
  2. From the Start menu, click All Programs, click Microsoft SQL Server, and click SQL Server Management Studio.
    Note: If Microsoft SQL Server Management Studio does not appear in your All Programs menu, the component might not have successfully installed. Verify that you have successfully installed Microsoft 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 Microsoft 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 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 server instance (for example, vra01mssql01).
  5. Right-click the Security folder, click New, and click Login.
  6. In the Login Properties dialog box, click the General page and enter the service account name (for example, rainpole\svc-vra) in the Login name text box.
  7. Click the Server Roles page, select the sysadmin check box, and click OK.