Documentation Center

Verifying Microsoft SQL System Administration role permissions

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.

Procedure

  1. Access the SQL Server Management Studio.

    Windows 2008: To access the SQL Server Management Studio click Start All Programs > Microsoft SQL Server > 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.