SQL Server Performance Forum – Threads Archive
Can not deploy my reportHi, I create a report by using Visual Studio.
When I tried to "deploy report", I got the error:
Error rsAccessDenied : The permissions granted to user ‘server01IUSR_server01’ are insufficient
for performing this operation." Are there any recommendation or suggestions to help me to fix this error? Thanks for your help!
As per the error message the first thing to check is privileges for IIS user on the SQL server. In Books Online, there’s a topic called "Configuring Security Through Role Assignments" that should explain the vaious pemermissons and what they’re useful for. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.