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.

Screen Shot 2015-02-19 at 12.51.53 PM

Executing the LoginUserRolePermission.sql script against the LTA+ database.

image006

Results after executing the above sql script:

image012