RS Errors even after reinstalls

After removing MSH beta2 which required me to remove FW2.0 and install
FW2.0Beta2, then remove MSH and FW2.0Beta2 and reinstall FW2.0 RTM, my
reporting server stopped working (at least I think that is the reason). I
have removed SQL and components and reinstalled 2-3 times fresh, but can
still not connect to Reports or deploy report projects. I think it is some
IIS config issue that remains between reinstalled, but don't know what to
"clean" up at this point. Any thoughts? What can I test to drill down on
the real issue?
http://localhost/Reports
Error
The report server is not responding. Verify that the report server is
running and can be accessed from this computer.
Home
=====
http://localhost/ReportServer
Reporting Services Error
----
The report server has encountered a configuration error. See the report
server log files for more information. (rsServerConfigurationError)
Access to the path 'C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting
Services\ReportServer\RSReportServer.config' is denied.
========
--
William Stacey [MVP]I am also having the same problem, only perhaps a bit more severe.
Although I never had any of the beta components installed, I have SQL 2K,
but uninstalled it and did a fresh install of SQL 2K5 (developer edition from
the msdn site). Just about every function of SQL 2K5 works, save anything
associated with the care and feeding of the reporting services component.
I can create reporting services projects without issue. However, I cannot
deploy them to the reporting server. If I go into the reporting server
configuration, the server is running and I can start / stop it without
problem. On the other hand, the Surface Area Configuration (surface are
configuration for features, reporting services, windows integrated security)
errors out with the same RSReportServer.config authorization issue that I get
during deployment, which was reported earlier.
In looking through the logs in C:\Program Files\Microsoft SQL
Server\MSSQL.3\Reporting Services\LogFiles, I saw the following entries:
ReportingServicesService!library!a!12/11/2005-22:21:19:: i INFO: Catalog SQL
Server Edition = Developer
ReportingServicesService!resourceutilities!a!12/11/2005-22:21:19:: i INFO:
Reporting Services starting SKU: Developer
ReportingServicesService!resourceutilities!a!12/11/2005-22:21:19:: i INFO:
Evaluation copy: 0 days left
Is reporting services failing because it thinks it's a demo? No matter what
permissions I try to give (either in IIS or the file system), the
"RSReportServer.config' is denied" message is consistent, so I don't believe
the message is truly indicative of the problem.
I am with a Microsoft gold partner and would be happy to provide any
additional information that might help resolve this issue.
Thanks!
"William Stacey [MVP]" wrote:
> After removing MSH beta2 which required me to remove FW2.0 and install
> FW2.0Beta2, then remove MSH and FW2.0Beta2 and reinstall FW2.0 RTM, my
> reporting server stopped working (at least I think that is the reason). I
> have removed SQL and components and reinstalled 2-3 times fresh, but can
> still not connect to Reports or deploy report projects. I think it is some
> IIS config issue that remains between reinstalled, but don't know what to
> "clean" up at this point. Any thoughts? What can I test to drill down on
> the real issue?
> http://localhost/Reports
> Error
> The report server is not responding. Verify that the report server is
> running and can be accessed from this computer.
> Home
> =====> http://localhost/ReportServer
> Reporting Services Error
> ----
> The report server has encountered a configuration error. See the report
> server log files for more information. (rsServerConfigurationError)
> Access to the path 'C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting
> Services\ReportServer\RSReportServer.config' is denied.
> ========> --
> William Stacey [MVP]
>
>|||I had the same problem you described and was wondering if you found a
solution. I am creating a test/demo environment so I am running on XP Pro
and wondering if this is part of the problem despite the fact that all other
aspects of the installation work fine. I took the following steps and made
some progress..
1. Added ASPNET user rights to the config file... got a bit further with the
error message changing to an "unable to connect to database server".
2. Added local ASPNET user to SQL Sever logins and granted appropriate DB
rights... got a bit further since I can now successfully bring up the
reports home page in a browser.
THe problem now comes in when I try and deploy a report from Studio. The
error reports that the process is attempting to use the local IUSR IIS guest
account to perfrom the operation and of course this does not have sufficient
rights. I am just starting to look for the place where this account is
specified but I haven't found it yet.
"William Stacey [MVP]" wrote:
> After removing MSH beta2 which required me to remove FW2.0 and install
> FW2.0Beta2, then remove MSH and FW2.0Beta2 and reinstall FW2.0 RTM, my
> reporting server stopped working (at least I think that is the reason). I
> have removed SQL and components and reinstalled 2-3 times fresh, but can
> still not connect to Reports or deploy report projects. I think it is some
> IIS config issue that remains between reinstalled, but don't know what to
> "clean" up at this point. Any thoughts? What can I test to drill down on
> the real issue?
> http://localhost/Reports
> Error
> The report server is not responding. Verify that the report server is
> running and can be accessed from this computer.
> Home
> =====> http://localhost/ReportServer
> Reporting Services Error
> ----
> The report server has encountered a configuration error. See the report
> server log files for more information. (rsServerConfigurationError)
> Access to the path 'C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting
> Services\ReportServer\RSReportServer.config' is denied.
> ========> --
> William Stacey [MVP]
>
>|||Hi Scott,
I am also using XP Pro and still haven't found a solution. Since I had
posted all of the technical documentation I could think of, I was hoping
someone from Microsoft would be able to provide some possible insight into
this problem.
I'm not about to uninstall then reinstall just to have the same issue. I
think if I had to do that, I would just uninstall, then reinstall SQL 2000.
Again, I would really welcome someone from Microsoft looking into this (given
that this problem has now aged over 60 days and there doesn't appear to be a
work around or other viable solution posted).
Please post if you have any luck.
Thanks!
- Wayne
"ScottT" wrote:
> I had the same problem you described and was wondering if you found a
> solution. I am creating a test/demo environment so I am running on XP Pro
> and wondering if this is part of the problem despite the fact that all other
> aspects of the installation work fine. I took the following steps and made
> some progress..
> 1. Added ASPNET user rights to the config file... got a bit further with the
> error message changing to an "unable to connect to database server".
> 2. Added local ASPNET user to SQL Sever logins and granted appropriate DB
> rights... got a bit further since I can now successfully bring up the
> reports home page in a browser.
> THe problem now comes in when I try and deploy a report from Studio. The
> error reports that the process is attempting to use the local IUSR IIS guest
> account to perfrom the operation and of course this does not have sufficient
> rights. I am just starting to look for the place where this account is
> specified but I haven't found it yet.
>
> "William Stacey [MVP]" wrote:
> > After removing MSH beta2 which required me to remove FW2.0 and install
> > FW2.0Beta2, then remove MSH and FW2.0Beta2 and reinstall FW2.0 RTM, my
> > reporting server stopped working (at least I think that is the reason). I
> > have removed SQL and components and reinstalled 2-3 times fresh, but can
> > still not connect to Reports or deploy report projects. I think it is some
> > IIS config issue that remains between reinstalled, but don't know what to
> > "clean" up at this point. Any thoughts? What can I test to drill down on
> > the real issue?
> >
> > http://localhost/Reports
> > Error
> >
> > The report server is not responding. Verify that the report server is
> > running and can be accessed from this computer.
> >
> > Home
> > =====> >
> > http://localhost/ReportServer
> >
> > Reporting Services Error
> > ----
> >
> > The report server has encountered a configuration error. See the report
> > server log files for more information. (rsServerConfigurationError)
> > Access to the path 'C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting
> > Services\ReportServer\RSReportServer.config' is denied.
> > ========> >
> > --
> > William Stacey [MVP]
> >
> >
> >
> >|||I'm with you as I do not know why Microsoft isn't either monitoring these
threads or responding to this particular issue. Did you try the steps I took
so far? I am interested to know if you find the solution steps acceptable
security wise and also if they worked for you. I am looking deeper to find
out why the deployment process is using the guest Internet account to perform
it's steps, when I find out, and correct the problem (hopefully :) ), I'll
post the steps.
Take care,
Scott
"Wayne" wrote:
> Hi Scott,
> I am also using XP Pro and still haven't found a solution. Since I had
> posted all of the technical documentation I could think of, I was hoping
> someone from Microsoft would be able to provide some possible insight into
> this problem.
> I'm not about to uninstall then reinstall just to have the same issue. I
> think if I had to do that, I would just uninstall, then reinstall SQL 2000.
> Again, I would really welcome someone from Microsoft looking into this (given
> that this problem has now aged over 60 days and there doesn't appear to be a
> work around or other viable solution posted).
> Please post if you have any luck.
> Thanks!
> - Wayne
> "ScottT" wrote:
> >
> > I had the same problem you described and was wondering if you found a
> > solution. I am creating a test/demo environment so I am running on XP Pro
> > and wondering if this is part of the problem despite the fact that all other
> > aspects of the installation work fine. I took the following steps and made
> > some progress..
> >
> > 1. Added ASPNET user rights to the config file... got a bit further with the
> > error message changing to an "unable to connect to database server".
> >
> > 2. Added local ASPNET user to SQL Sever logins and granted appropriate DB
> > rights... got a bit further since I can now successfully bring up the
> > reports home page in a browser.
> >
> > THe problem now comes in when I try and deploy a report from Studio. The
> > error reports that the process is attempting to use the local IUSR IIS guest
> > account to perfrom the operation and of course this does not have sufficient
> > rights. I am just starting to look for the place where this account is
> > specified but I haven't found it yet.
> >
> >
> > "William Stacey [MVP]" wrote:
> >
> > > After removing MSH beta2 which required me to remove FW2.0 and install
> > > FW2.0Beta2, then remove MSH and FW2.0Beta2 and reinstall FW2.0 RTM, my
> > > reporting server stopped working (at least I think that is the reason). I
> > > have removed SQL and components and reinstalled 2-3 times fresh, but can
> > > still not connect to Reports or deploy report projects. I think it is some
> > > IIS config issue that remains between reinstalled, but don't know what to
> > > "clean" up at this point. Any thoughts? What can I test to drill down on
> > > the real issue?
> > >
> > > http://localhost/Reports
> > > Error
> > >
> > > The report server is not responding. Verify that the report server is
> > > running and can be accessed from this computer.
> > >
> > > Home
> > > =====> > >
> > > http://localhost/ReportServer
> > >
> > > Reporting Services Error
> > > ----
> > >
> > > The report server has encountered a configuration error. See the report
> > > server log files for more information. (rsServerConfigurationError)
> > > Access to the path 'C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting
> > > Services\ReportServer\RSReportServer.config' is denied.
> > > ========> > >
> > > --
> > > William Stacey [MVP]
> > >
> > >
> > >
> > >|||This is a peer supported newsgroup UNLESS you are posting as part of MS
managed newsgroup (both postings show up here). The managed newsgroup
postings are if you have MSDN (not sure the version). You register a fake
email address used by your newsgroup software when posting and that allows
MS to monitor any posts to make sure you get a response (for instance, if I
answer it and they see it is answered they don't jump in). However, if it is
not a managed newsgroup posting then the only MS employees are those that
jump in on there own, usually not as part of their job.
In this case, I haven't jumped in because I don't have anything to offer for
a solution.
You can always call support and open a ticket with them.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"ScottT" <ScottT@.discussions.microsoft.com> wrote in message
news:6ED2DC2F-EBA3-4624-9101-8DDC037EDA8B@.microsoft.com...
> I'm with you as I do not know why Microsoft isn't either monitoring these
> threads or responding to this particular issue. Did you try the steps I
> took
> so far? I am interested to know if you find the solution steps acceptable
> security wise and also if they worked for you. I am looking deeper to
> find
> out why the deployment process is using the guest Internet account to
> perform
> it's steps, when I find out, and correct the problem (hopefully :) ), I'll
> post the steps.
> Take care,
> Scott
>
> "Wayne" wrote:
>> Hi Scott,
>> I am also using XP Pro and still haven't found a solution. Since I had
>> posted all of the technical documentation I could think of, I was hoping
>> someone from Microsoft would be able to provide some possible insight
>> into
>> this problem.
>> I'm not about to uninstall then reinstall just to have the same issue. I
>> think if I had to do that, I would just uninstall, then reinstall SQL
>> 2000.
>> Again, I would really welcome someone from Microsoft looking into this
>> (given
>> that this problem has now aged over 60 days and there doesn't appear to
>> be a
>> work around or other viable solution posted).
>> Please post if you have any luck.
>> Thanks!
>> - Wayne
>> "ScottT" wrote:
>> >
>> > I had the same problem you described and was wondering if you found a
>> > solution. I am creating a test/demo environment so I am running on XP
>> > Pro
>> > and wondering if this is part of the problem despite the fact that all
>> > other
>> > aspects of the installation work fine. I took the following steps and
>> > made
>> > some progress..
>> >
>> > 1. Added ASPNET user rights to the config file... got a bit further
>> > with the
>> > error message changing to an "unable to connect to database server".
>> >
>> > 2. Added local ASPNET user to SQL Sever logins and granted appropriate
>> > DB
>> > rights... got a bit further since I can now successfully bring up the
>> > reports home page in a browser.
>> >
>> > THe problem now comes in when I try and deploy a report from Studio.
>> > The
>> > error reports that the process is attempting to use the local IUSR IIS
>> > guest
>> > account to perfrom the operation and of course this does not have
>> > sufficient
>> > rights. I am just starting to look for the place where this account is
>> > specified but I haven't found it yet.
>> >
>> >
>> > "William Stacey [MVP]" wrote:
>> >
>> > > After removing MSH beta2 which required me to remove FW2.0 and
>> > > install
>> > > FW2.0Beta2, then remove MSH and FW2.0Beta2 and reinstall FW2.0 RTM,
>> > > my
>> > > reporting server stopped working (at least I think that is the
>> > > reason). I
>> > > have removed SQL and components and reinstalled 2-3 times fresh, but
>> > > can
>> > > still not connect to Reports or deploy report projects. I think it
>> > > is some
>> > > IIS config issue that remains between reinstalled, but don't know
>> > > what to
>> > > "clean" up at this point. Any thoughts? What can I test to drill
>> > > down on
>> > > the real issue?
>> > >
>> > > http://localhost/Reports
>> > > Error
>> > >
>> > > The report server is not responding. Verify that the report server is
>> > > running and can be accessed from this computer.
>> > >
>> > > Home
>> > > =====>> > >
>> > > http://localhost/ReportServer
>> > >
>> > > Reporting Services Error
>> > > ----
>> > >
>> > > The report server has encountered a configuration error. See the
>> > > report
>> > > server log files for more information. (rsServerConfigurationError)
>> > > Access to the path 'C:\Program Files\Microsoft SQL
>> > > Server\MSSQL.3\Reporting
>> > > Services\ReportServer\RSReportServer.config' is denied.
>> > > ========>> > >
>> > > --
>> > > William Stacey [MVP]
>> > >
>> > >
>> > >
>> > >|||I am including the response I received here since it is not part of the
thread... It solved the problem...
"On the report server, make sure that your Reportserver web site Anonymous
Access disabled, and Authentication Access set to Integrated WIndows
Authentication.
In Internet Explorer on your computer, put the Report server web site in
Trusted Sites, and turn on "Always prompt for username and password" under
the security settings.
Then make sure that your account is allowed to view and add reports to the
server, by going to the report server URL and try to log in and generally do
stuff. (If you get the Upload file-button, you should be allowed to add
reports.)
Try deploying the report again.
Kaisa M. Lindahl "
-Scott
"ScottT" wrote:
> I'm with you as I do not know why Microsoft isn't either monitoring these
> threads or responding to this particular issue. Did you try the steps I took
> so far? I am interested to know if you find the solution steps acceptable
> security wise and also if they worked for you. I am looking deeper to find
> out why the deployment process is using the guest Internet account to perform
> it's steps, when I find out, and correct the problem (hopefully :) ), I'll
> post the steps.
> Take care,
> Scott
>
> "Wayne" wrote:
> > Hi Scott,
> >
> > I am also using XP Pro and still haven't found a solution. Since I had
> > posted all of the technical documentation I could think of, I was hoping
> > someone from Microsoft would be able to provide some possible insight into
> > this problem.
> >
> > I'm not about to uninstall then reinstall just to have the same issue. I
> > think if I had to do that, I would just uninstall, then reinstall SQL 2000.
> > Again, I would really welcome someone from Microsoft looking into this (given
> > that this problem has now aged over 60 days and there doesn't appear to be a
> > work around or other viable solution posted).
> >
> > Please post if you have any luck.
> >
> > Thanks!
> >
> > - Wayne
> >
> > "ScottT" wrote:
> >
> > >
> > > I had the same problem you described and was wondering if you found a
> > > solution. I am creating a test/demo environment so I am running on XP Pro
> > > and wondering if this is part of the problem despite the fact that all other
> > > aspects of the installation work fine. I took the following steps and made
> > > some progress..
> > >
> > > 1. Added ASPNET user rights to the config file... got a bit further with the
> > > error message changing to an "unable to connect to database server".
> > >
> > > 2. Added local ASPNET user to SQL Sever logins and granted appropriate DB
> > > rights... got a bit further since I can now successfully bring up the
> > > reports home page in a browser.
> > >
> > > THe problem now comes in when I try and deploy a report from Studio. The
> > > error reports that the process is attempting to use the local IUSR IIS guest
> > > account to perfrom the operation and of course this does not have sufficient
> > > rights. I am just starting to look for the place where this account is
> > > specified but I haven't found it yet.
> > >
> > >
> > > "William Stacey [MVP]" wrote:
> > >
> > > > After removing MSH beta2 which required me to remove FW2.0 and install
> > > > FW2.0Beta2, then remove MSH and FW2.0Beta2 and reinstall FW2.0 RTM, my
> > > > reporting server stopped working (at least I think that is the reason). I
> > > > have removed SQL and components and reinstalled 2-3 times fresh, but can
> > > > still not connect to Reports or deploy report projects. I think it is some
> > > > IIS config issue that remains between reinstalled, but don't know what to
> > > > "clean" up at this point. Any thoughts? What can I test to drill down on
> > > > the real issue?
> > > >
> > > > http://localhost/Reports
> > > > Error
> > > >
> > > > The report server is not responding. Verify that the report server is
> > > > running and can be accessed from this computer.
> > > >
> > > > Home
> > > > =====> > > >
> > > > http://localhost/ReportServer
> > > >
> > > > Reporting Services Error
> > > > ----
> > > >
> > > > The report server has encountered a configuration error. See the report
> > > > server log files for more information. (rsServerConfigurationError)
> > > > Access to the path 'C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting
> > > > Services\ReportServer\RSReportServer.config' is denied.
> > > > ========> > > >
> > > > --
> > > > William Stacey [MVP]
> > > >
> > > >
> > > >
> > > >