Sql user canot use standard reports using MS SQL Management studio
Posted on 2013-06-20
A user using SQL authentication via MS SQL Management Studio would like to use some standard reports on some databases, however errors are returned.
e.g. All transactions report (the main one to be used) returns
"Unable to retrieve data for this report. Following error occurred.
Msg 297, Level 16, State 1
The user does not have permission to perform this action"
(The same happens if I connect using this authentication, however all works if I use my Windows Authentication)
I cannot identify needed permission.
server: MS SQL Server Developer Edition x64 2008 R2
OS: Windows 2008 R2 Enterprise edition x64
The sql user used to get the report is the owner of the database