EV SQL Server Reporting Servicess Authentication Error

[koray_alkan]

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 

[GertjanA]

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

[TonySterling]

Koray,

What version of EV and SQL RS?

Regards, 

[koray_alkan]

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 

[TonySterling · Accepted solution]

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>

[koray_alkan]

Tony,

It solved the problem!

Thank you very much

Regards,

Koray 

[TonySterling]

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