Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mvanwyk
Yak Posting Veteran
99 Posts |
 Posted - 2009-02-17 : 06:10:45
|
| Hi we have SQL 2005 + Win 2003 SRV + Report ServerI am now able to connect to Report Builder and I’m able to see the VIEW.I can even see / drag table columns to the report but the minute i run the report i get the following error.The permissions granted to user 'MYSERVER\myuser' are insufficient for performing this operation. (rsAccessDenied)I have looked at the at the model and the above user has all available access.Please assist. |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2009-02-17 : 06:38:20
|
| Do they have the correct access in Report Security as well as on the back end? |
 |
|
|
mvanwyk
Yak Posting Veteran
99 Posts |
Posted - 2009-02-17 : 06:57:29
|
| Sorry but what do you mean?The "myuser" is a User on Reports Server and it has the following permissions.Browser, Content Manager, My Reports, Publisher, Report BuilderDo i need to set other permissions for this user else where?Regards. |
|
|
|
|
|
|
rsAccessDenied