Documentation Center

Verifying Microsoft SQL System Administration role permissions

To ensure that the database upgrade tool (DBUpgradeTool or DBUT) works properly, the isource user must have system administrator permissions.

About this task

To allow 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.

Procedure

  1. Access the SQL Server Management Studio.

    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

  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.