Friday, March 9, 2012

Reporting Services fresh install Access Problem

Hi -
I installed SQL Server 2005 with RS2005 on a Windows 2003 server. I used
LocalSystem account as owner of services. I logged in as a local Admin of the
box where all services are on teh same box.
My SS2005 is a side-by-side name instance on same box where I have SS200
database.
I am getting the following error when I first try to access the ReportServer
with the following URL:
http://DBServer/ReportServer$SS2005
Reporting Services Error
----
--
The Report Server Web Service is unable to access secure information in the
report server. Please verify that the WebServiceAccount is specified
correctly in the report server config file. (rsAccessDeniedToSecureData) Get
Online Help
----
--
SQL Server Reporting Services
By the way when I clicked on the link for online help, the message was that
there was no data on the subject.
Not sure where I went wrong here.
Thank You
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200712/1You can open rsreportserver.config located in:
C:\Program Files\Microsoft SQL Server\MSSQL.1\Reporting
Services\ReportServer\
with notepad and change the following line:
<WebServiceAccount>NT Authority\NetworkService</WebServiceAccount>
to the account that your app services pool is using for its identity...
If that doesnt fix it it may be due to the fact that your service account
doesnt have the appropriate permissions so if you've change that or are using
a custom application pool try switching back to the default app pool.
"wiseteufel" wrote:
> Hi -
> I installed SQL Server 2005 with RS2005 on a Windows 2003 server. I used
> LocalSystem account as owner of services. I logged in as a local Admin of the
> box where all services are on teh same box.
> My SS2005 is a side-by-side name instance on same box where I have SS200
> database.
> I am getting the following error when I first try to access the ReportServer
> with the following URL:
> http://DBServer/ReportServer$SS2005
> Reporting Services Error
> ----
> --
> The Report Server Web Service is unable to access secure information in the
> report server. Please verify that the WebServiceAccount is specified
> correctly in the report server config file. (rsAccessDeniedToSecureData) Get
> Online Help
> ----
> --
> SQL Server Reporting Services
> By the way when I clicked on the link for online help, the message was that
> there was no data on the subject.
> Not sure where I went wrong here.
> Thank You
> --
> Message posted via SQLMonster.com
> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200712/1
>

No comments:

Post a Comment