Richard Elgert
asked on
SSRS 2005 can't deploy report
Permission issue but i can't figure it out
ASKER
Hmmm.... I will check that in AM but I don't believe that is it I think the report I built is not being save into the database
ASKER
OK I checked not sure what to check but folder said "Builtin\Administrators" and I gave it all permission - tried to deploy in visual studio
Build complete -- 0 errors, 0 warnings
------ Deploy started: Project: Adventure Works, Configuration: Debug ------
Deploying to http://programmer-pc/ReportServer
Error rsAccessDenied : The permissions granted to user 'Programmer-PC\Programmer' are insufficient for performing this operation.
Deploy complete -- 1 errors, 0 warnings
========== Build: 1 succeeded or up-to-date, 0 failed, 0 skipped ==========
========== Deploy: 0 succeeded, 1 failed, 0 skipped ==========
not sure what who's permission to set\
inURL i tried uploading same report and it did and it runs
Build complete -- 0 errors, 0 warnings
------ Deploy started: Project: Adventure Works, Configuration: Debug ------
Deploying to http://programmer-pc/ReportServer
Error rsAccessDenied : The permissions granted to user 'Programmer-PC\Programmer'
Deploy complete -- 1 errors, 0 warnings
========== Build: 1 succeeded or up-to-date, 0 failed, 0 skipped ==========
========== Deploy: 0 succeeded, 1 failed, 0 skipped ==========
not sure what who's permission to set\
inURL i tried uploading same report and it did and it runs
It would be the account you are connecting to sql with.
did you run the app as administrator when you started it (i.e. right click the shortcut and run as administrator)?
did you run the app as administrator when you started it (i.e. right click the shortcut and run as administrator)?
ASKER
I wound up using SQL sa account and works - but not elegant
Check if built in administrators ysers are granted security on report database
ASKER
they seem to but I set to run as sa and it works and good enough for me
ASKER
I want to close question I can live with the way it is
Just get sure the user you were using is a domain user to access and run the report service from services.msc
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
i don't know how to withdraw a question but I have it working not best solution that I used but will do for my purposes
Click on the down arrow beside the folder and select security
then check that the account your using is granted at least publisher permission.