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
- 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.
Note: If prompted and required, connect to the server.
- Under the folder for the MSSQL server in the left pane, open .
- Right-click on the isource user and select Properties.
A Login Properties - isource window displays.
- In the left pane of the Login Properties - isource window select Server Roles.
- In the right pane for Server Roles select public and sysadmin.
- Click OK.
- Click to exit and close the Microsoft Server Management window.