01-29-2009 05:56 AM
Dear All,
I configured the EV SQL Reporting Services with the user Domain\evreport. i am able to connect to the url http://evreportingserver/Reports successfuly. When i click the Symantec EnterpriseVault !NEW i get the following error:
The permissions granted to user 'DOMAIN\evreport' are insufficient for performing this operation. (rsAccessDenied)
Does anybody here experienced such kind of problem before?
Regards
Koray
Solved! Go to Solution.
02-01-2009 04:47 PM
EV 8 introduces the ability to use EV Roles Based Administration with SQL Reporting. As such it replaces the Microsoft Security Layer with Symantec's security layer. There is an intermittent issue that is due to be fixed in sp1 but for now you make the following change in the RSReportServer.Config file.
In the RSReportServer.Config change this:
<Security>
<Extension Name="Windows" Type="Symantec.EnterpriseVault.Reports.SecurityExtension.Authorization,EVSecurityExtension"/>
</Security>
<Authentication>
<Extension Name="Windows" Type="Symantec.EnterpriseVault.Reports.SecurityExtension.Authentication,EVSecurityExtension"/>
</Authentication>
to what it used to be:
<Security>
<Extension Name="Windows" Type="Microsoft.ReportingServices.Authorization.WindowsAuthorization,Microsoft.ReportingServices.Authorization" />
</Security>
<Authentication>
<Extension Name="Windows" Type="Microsoft.ReportingServices.Authentication.WindowsAuthentication,Microsoft.ReportingServices.Authorization" />
</Authentication>
01-29-2009 06:05 AM
Hello Koray,
This might be a setting in the Reporting page. I believe you have to add the user there as 'creator' or something.
Check the Troubelshooting EV Reporting guide. ( http://support.veritas.com/docs/285815 )
See http://seer.entsupport.symantec.com/docs/308564.htm
Give the Vault Service account a 'Content manager' role on the Microsoft Reporting Services Report Server. Refer to the Microsoft Reporting Services documentation for instructions on assigning Microsoft SQL Server Reporting Services roles to user accounts
Gertjan
01-29-2009 01:30 PM
Koray,
What version of EV and SQL RS?
Regards,
01-29-2009 11:16 PM
Tony,
EV=8.0
SQL & SQL RS= 2005
Vault Admin has Local Admin rights in SQL RS Server
Reporting User has Content management right in RS Server
Thanks for advance
Koray
02-01-2009 04:47 PM
EV 8 introduces the ability to use EV Roles Based Administration with SQL Reporting. As such it replaces the Microsoft Security Layer with Symantec's security layer. There is an intermittent issue that is due to be fixed in sp1 but for now you make the following change in the RSReportServer.Config file.
In the RSReportServer.Config change this:
<Security>
<Extension Name="Windows" Type="Symantec.EnterpriseVault.Reports.SecurityExtension.Authorization,EVSecurityExtension"/>
</Security>
<Authentication>
<Extension Name="Windows" Type="Symantec.EnterpriseVault.Reports.SecurityExtension.Authentication,EVSecurityExtension"/>
</Authentication>
to what it used to be:
<Security>
<Extension Name="Windows" Type="Microsoft.ReportingServices.Authorization.WindowsAuthorization,Microsoft.ReportingServices.Authorization" />
</Security>
<Authentication>
<Extension Name="Windows" Type="Microsoft.ReportingServices.Authentication.WindowsAuthentication,Microsoft.ReportingServices.Authorization" />
</Authentication>
02-02-2009 12:53 AM
Tony,
It solved the problem!
Thank you very much
Regards,
Koray
02-02-2009 12:46 PM
Glad that sorted you out. One thing I forgot to mention is when that the config is reverted back to the Windows security layer Roles Based Administration will not function as intended. So if you are using RBA keep that in mind.
When sp1 comes out be sure to deploy the forms and it will add the EV security layer and you will be all set.
Regards,
Tony