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 execute 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 VRA01MSSQL01.rainpole.local by using a Remote Desktop Protocol (RDP) client.
    1. Open an RDP connection to the virtual machine VRA01MSSQL01.rainpole.local.
    2. Log in using the following credentials.

      Setting

      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 doesn't 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 Object Explorer, expand the server instance VRA01MSSQL01.
  5. Right-click the Security folder, click New, and click Login.




    The Login Properties dialog box opens.

  6. Select the General page of the Login Properties dialog box. 
  7. From the Object Explorer Details pane, select the General page, and enter Rainpole\Svc-vRA in the Login name text box.




  8. In the Object Explorer Details pane, select the Server Role page. 
  9. In the Server roles list item field select the sysadmin check box, and click OK.