Verify SQL Server Management Studio Permissions

If your attachments are not working as expected, verify SQL Server Management Studio permissions.

  1. Log in to SQL Server Management Studio as a System Admin.
  2. Expand the database that stores your Vista attachments.
  3. Expand Security, and then expand Users.
  4. Right-click on the portal service account, and select Properties.
  5. In the Database User window:
    1. In the left pane, under Select a page, select Securables
    2. In the main area of the window, select the Search button shown above the grid.
    3. In the Add Objects window, select All objects of the types..., and select OK.

    4. In the pop-up window, select Stored Procedures, and select OK to return to the Database User window.
    5. Under Securables, locate vspHAQFInsert.
    6. In the Permissions section of the window, select the Grant checkbox for the Execute permission (if it is not already selected), and select OK.