Documentation Center

Verifying Microsoft SQL System Administration role permissions

If you use Microsoft SQL Server as your database, then after installing or upgrading Content Manager, grant the isource user system administrator permissions. This ensures that the database upgrade tool (DBUpgradeTool or DBUT) works properly.

About this task

To allow DBUT to fully execute all necessary tasks to update your Microsoft SQL Server database now and for each new release, follow the procedure below to ensure the database user has the necessary permissions.

Procedure

  1. Access the SQL Server Management Studio.

    Windows 2012: To access the SQL Server Management Studio if not readily accessible, use the Windows Powershell icon on the bottom toolbar then at the prompt type: Ssms.exe.

  2. Under the folder for the MSSQL server in the left pane, open Security > Logins.
  3. Right-click on the isource user and select Properties.
    A Login Properties - isource window displays.
  4. In the left pane of the Login Properties - isource window select Server Roles.
  5. In the right pane for Server Roles select public and sysadmin.
  6. Click OK.
  7. Click File > Exit to exit and close the Microsoft Server Management window.