Environment
LTA+ 2013 – MS SQL Server
Situation
A user attempts to login to the LTA+ Management Console/Report Console using MSSQL authentication. That results in the following error being returned:
“Error occurred when connecting to database. Reason: User does not have sufficient permissions on database objects.”
Resolution
The MS SQL user needs to have the database role membership of db_owner for that LTA+ database. The attached Microsoft script (LoginUserRolePermission.sql) can be run against the LTA+ database to which you are attempting to connect, by the SQLDBA in order to determine whether or not the user has that database role membership.
Properties of the sql user – the user needs the database role membership of db_owner of the LTA+ database.
Executing the LoginUserRolePermission.sql script against the LTA+ database.
Results after executing the above sql script:
