"The user you have selected does not have SA privileges" Error while Upgrading Track-It! 2020

Version 1
    Share This:

    This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.


    PRODUCT:

    Track-It!


    COMPONENT:

    Track-It! 2020 R2


    APPLIES TO:

    Track-It! 20.xx



    PROBLEM:

    While Upgrading to Track-It! 2020 on the "SQL Server Administrative Login" screen after entering credentials, the following error is received:
    User-added image

    "The user you have selected does not have SA privileges.
    Select another user before continuing."


    CAUSE:

    A SQL Login that does not have SysAdmin (SA) privileges is being used.


    SOLUTION:

     

      Make sure that the SQL Login being used has the required SysAdmin (SA) privileges. Using SQL Server Management Studio (SSMS), once you expand Security -> Logins, right click on the respective Login to ensure this is set as follows:  
     
      User-added image 
     
    Also check that the SQL Server's Authentication is set to "SQL Server and Windows Authentication mode". Using SSMS, once you right click on the Server (top level) in the Object Explorer and select Properties. Click the Security page and ensure it is set as follows:  
     
      User-added image

     


    Article Number:

    000254836


    Article Type:

    Solutions to a Product Problem



      Looking for additional information?    Search BMC Support  or  Browse Knowledge Articles