To ensure that the database upgrade tool (DBUpgrade) works properly, the isource user must have system administrator permissions.
About this task
To allow the DatabaseUpgradeTool (DBUT) to fully execute all necessary tasks to update your MS SQL database now and for each new release, follow the procedure below to ensure the database user has the necessary permissions.
Note: This procedure applies only if you are using SQLServer. This procedure does not apply to Oracle.
Procedure
- Access the SQL Server Management Studio.
Windows 2008: To access the SQL Server Management Studio click Start
Windows 2012: To access the SQL Server Management Studio if not readily accessible, click 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.