This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.
Track-It! 2020 R2
While Upgrading to Track-It! 2020 on the "SQL Server Administrative Login" screen after entering credentials, the following error is received:
"The user you have selected does not have SA privileges.
Select another user before continuing."
A SQL Login that does not have SysAdmin (SA) privileges is being used.
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: