Usage.asp error access is denied
Updated: 21 May 2010 | 2 comments
KVS admin account can view the page fine, however, Role based admin(Message Administrators) are getting access denied. Checked IIS its using basic authentication only.
discussion Filed Under:
Comments
Hi,
I'm pretty sure that you'll need to give the RBA users access to sql as well(directory and vault store databases)
Yes, you do. At least I did.
Below is a link to a tech note that tells what to do. The extra access required here was enough for my client to realize that usage.asp is really a VSA report, and not meant for all users. EV Reports have an equivalent report that works great, and they are happy with that. That said, here's the link:
http://seer.entsupport.symantec.com/docs/287580.htm
It boils down to this:
Add the RBA user as a login in SQL Server
Add it as a user mapping to the EV Vault Store databases
In all the vault store databases:
GRANT EXECUTE ON usps_Usage TO domain\user
GRANT SELECT ON view_ListVaults TO domain\user
HTH,
Rob
Would you like to reply?
Login or Register to post your comment.