Failed to access IIS metabase?

Please help!

All of sudden, I cannot connect to the reporting services through MS SQL Server management studio. error message is "Failed to access IIS metabase".

As I checked the system:

1. reporting services is working properly (status is "started")

2. cannot access http://localhost/ReportServer$SQL2005 , the same error

3. Run:"C:\>cscript metaacl.vbs IIS://localhost/w3svc", it shows:
Microsoft (R) Windows Script Host Version 5.6
Copyright (C) Microsoft Corporation 1996-2001. All rights reserved.

XP\ASPNET
Access: R E
BUILTIN\Administrators
Access: RWSUED
Everyone
Access: E
XP\VS Developers
Access: RWSUE
XP\ASPNET
Access: R
XP\ASPNET
Access: R

I reinstall IIS and it doesn't work. Please help, thank you so much!

Are you able to access http://localhost/reportserver from IE? Are you able to access any web pages from IE?|||

Thank you for your reply.

The first answer is no, I cannot access http://localhost/reportserver from IE(The instance of SQL server 2005 is "SQL2005".)

The second answer is yes, I can access IIS' default web page and the other web pages.

|||Anybody can help, please?|||

I think you need to figure out what are the required ACLs. Maybe you can start by giving everybody full access. If that works start reducing the permissions.

BTW, I thought the error message would give you more details about what ACLs are missing, but I could be wrong.

|||One more thing, if you uninstalled IIS, you may run into some problem when you try to uninstall RS later on: http://lab.msdn.microsoft.com/productfeedback/viewfeedback.aspx?feedbackid=735b5260-f6bf-4ea5-94b2-6c41ae387a9a

Failed to access IIS metabase

I have installed SQL Server 2005, including Reporting Services 2005 on
Windows XP Professional in a standalone environment. I can see the Reports
and ReportServer folders in IIS in Administrative Tools and all settings
appear to be appropriate.
My first problem is that, when I try to access
"http://localhost/ReportServer", I get an error "Failed to access IIS
metabase". I have looked at KB article
"http://support.microsoft.com/?kbid=267904" which is referred to in the error
message but it appears to relate to Windows Server 2003.
Secondly, I expected to get the same error when trying to access
"http://localhost/Reports" but in this case I get a message "Directory
Listing Denied" which seems to indicate that the metabase is not an issue
here. I can see the directory listing if I activiate this option in IIS in
Admin Tools but I can't browse the contents of the Reports web page.
Can anyone provide me with a solution? I have also listed this problem in
Windows Server - IIS in case it is an IIS problem.
Thank you.The ASP.NET 2.0 is not registered properly in IIS. RS2005 uses ASP.NET 2.0
Try registering in the command line using the following ..
C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_regiis.exe -i
and reset the iis. I think that will solve all the problem.
Let me know.
Thanks
Bava
"NeilW" wrote:
> I have installed SQL Server 2005, including Reporting Services 2005 on
> Windows XP Professional in a standalone environment. I can see the Reports
> and ReportServer folders in IIS in Administrative Tools and all settings
> appear to be appropriate.
> My first problem is that, when I try to access
> "http://localhost/ReportServer", I get an error "Failed to access IIS
> metabase". I have looked at KB article
> "http://support.microsoft.com/?kbid=267904" which is referred to in the error
> message but it appears to relate to Windows Server 2003.
> Secondly, I expected to get the same error when trying to access
> "http://localhost/Reports" but in this case I get a message "Directory
> Listing Denied" which seems to indicate that the metabase is not an issue
> here. I can see the directory listing if I activiate this option in IIS in
> Admin Tools but I can't browse the contents of the Reports web page.
> Can anyone provide me with a solution? I have also listed this problem in
> Windows Server - IIS in case it is an IIS problem.
> Thank you.
>|||Your solution worked perfectly. Thanks very much.
"Bava Mani" wrote:
> The ASP.NET 2.0 is not registered properly in IIS. RS2005 uses ASP.NET 2.0
> Try registering in the command line using the following ..
> C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_regiis.exe -i
> and reset the iis. I think that will solve all the problem.
> Let me know.
> Thanks
> Bava
> "NeilW" wrote:
> > I have installed SQL Server 2005, including Reporting Services 2005 on
> > Windows XP Professional in a standalone environment. I can see the Reports
> > and ReportServer folders in IIS in Administrative Tools and all settings
> > appear to be appropriate.
> >
> > My first problem is that, when I try to access
> > "http://localhost/ReportServer", I get an error "Failed to access IIS
> > metabase". I have looked at KB article
> > "http://support.microsoft.com/?kbid=267904" which is referred to in the error
> > message but it appears to relate to Windows Server 2003.
> >
> > Secondly, I expected to get the same error when trying to access
> > "http://localhost/Reports" but in this case I get a message "Directory
> > Listing Denied" which seems to indicate that the metabase is not an issue
> > here. I can see the directory listing if I activiate this option in IIS in
> > Admin Tools but I can't browse the contents of the Reports web page.
> >
> > Can anyone provide me with a solution? I have also listed this problem in
> > Windows Server - IIS in case it is an IIS problem.
> >
> > Thank you.
> >|||I have this same problem, however the solution given here did not work. Here
is what I have done:
1) Run a repair install of .Net 2.0
2) Totally reinstall .Net 2.0
3) Run aspnet_regiis.exe -i
4) Run aspnet_regiis.exe -ga ASPNET
Still have the problem. Any more ideas?
--
James
"Bava Mani" wrote:
> The ASP.NET 2.0 is not registered properly in IIS. RS2005 uses ASP.NET 2.0
> Try registering in the command line using the following ..
> C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_regiis.exe -i
> and reset the iis. I think that will solve all the problem.
> Let me know.
> Thanks
> Bava
> "NeilW" wrote:
> > I have installed SQL Server 2005, including Reporting Services 2005 on
> > Windows XP Professional in a standalone environment. I can see the Reports
> > and ReportServer folders in IIS in Administrative Tools and all settings
> > appear to be appropriate.
> >
> > My first problem is that, when I try to access
> > "http://localhost/ReportServer", I get an error "Failed to access IIS
> > metabase". I have looked at KB article
> > "http://support.microsoft.com/?kbid=267904" which is referred to in the error
> > message but it appears to relate to Windows Server 2003.
> >
> > Secondly, I expected to get the same error when trying to access
> > "http://localhost/Reports" but in this case I get a message "Directory
> > Listing Denied" which seems to indicate that the metabase is not an issue
> > here. I can see the directory listing if I activiate this option in IIS in
> > Admin Tools but I can't browse the contents of the Reports web page.
> >
> > Can anyone provide me with a solution? I have also listed this problem in
> > Windows Server - IIS in case it is an IIS problem.
> >
> > Thank you.
> >|||Can you give me the error msg that it says. send me more details of when and
where you get the error.
Thanks
Bava
"James" wrote:
> I have this same problem, however the solution given here did not work. Here
> is what I have done:
> 1) Run a repair install of .Net 2.0
> 2) Totally reinstall .Net 2.0
> 3) Run aspnet_regiis.exe -i
> 4) Run aspnet_regiis.exe -ga ASPNET
> Still have the problem. Any more ideas?
> --
> James
>
> "Bava Mani" wrote:
> > The ASP.NET 2.0 is not registered properly in IIS. RS2005 uses ASP.NET 2.0
> > Try registering in the command line using the following ..
> > C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_regiis.exe -i
> > and reset the iis. I think that will solve all the problem.
> > Let me know.
> >
> > Thanks
> > Bava
> >
> > "NeilW" wrote:
> >
> > > I have installed SQL Server 2005, including Reporting Services 2005 on
> > > Windows XP Professional in a standalone environment. I can see the Reports
> > > and ReportServer folders in IIS in Administrative Tools and all settings
> > > appear to be appropriate.
> > >
> > > My first problem is that, when I try to access
> > > "http://localhost/ReportServer", I get an error "Failed to access IIS
> > > metabase". I have looked at KB article
> > > "http://support.microsoft.com/?kbid=267904" which is referred to in the error
> > > message but it appears to relate to Windows Server 2003.
> > >
> > > Secondly, I expected to get the same error when trying to access
> > > "http://localhost/Reports" but in this case I get a message "Directory
> > > Listing Denied" which seems to indicate that the metabase is not an issue
> > > here. I can see the directory listing if I activiate this option in IIS in
> > > Admin Tools but I can't browse the contents of the Reports web page.
> > >
> > > Can anyone provide me with a solution? I have also listed this problem in
> > > Windows Server - IIS in case it is an IIS problem.
> > >
> > > Thank you.
> > >

Fail to install RS 2k on windows 2k3 with IIS configuration error

***Environment:
Windows 2003 Standard, IIS 6.0, SQL Server 2000
***Error:
When installing, warning message appears as:
"IIS is either not installed or not configurated for a server component
installation"
After the installation is finished by ignoreing the preceding warning, no
virtual dir is crated for RS to run.
***My idea:
After reading the setup document, I find out that:
"If you are using IIS 6.x, Setup uses the default application pool. If the
default Web site or application pool is not available, Setup will continue,
but your installation will not work once Setup is finished." That might be
the major cause of the problem...
***My problem:
Actually, I have the Default Application Pool (DefaultAppPool) in my IIS
6.0. The only thing is that RS can not recognize it...
Is there anybody could give some advice? Thanks in advance!!!i found this once when i hadnt got aspnet reg'd for iis
i went to
C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_regiis.exe -i
i then went into start > programs > sql server 2005 > reporting
services configuration
and you can get it to have another go at creating the websites (an
option on the left). this worked for me.
db
--
http://www.osix.net
the open source institute
home of the geek programming challenges
CrazyCalculator wrote:
> ***Environment:
> Windows 2003 Standard, IIS 6.0, SQL Server 2000
> ***Error:
> When installing, warning message appears as:
> "IIS is either not installed or not configurated for a server component
> installation"
> After the installation is finished by ignoreing the preceding warning, no
> virtual dir is crated for RS to run.
> ***My idea:
> After reading the setup document, I find out that:
> "If you are using IIS 6.x, Setup uses the default application pool. If the
> default Web site or application pool is not available, Setup will continue,
> but your installation will not work once Setup is finished." That might be
> the major cause of the problem...
> ***My problem:
> Actually, I have the Default Application Pool (DefaultAppPool) in my IIS
> 6.0. The only thing is that RS can not recognize it...
> Is there anybody could give some advice? Thanks in advance!!!|||Thank bb for your suggestion :)
However, I am install Reporting services 2000 on SQL Server 2000 and my
ASP.NET 1.1 seems to be perfectly registed...|||then sorry friend, cant really help as ive not tried with 2000
tell your techies to get update with the latest stuff!
good luck
db
CrazyCalculator wrote:
> Thank bb for your suggestion :)
> However, I am install Reporting services 2000 on SQL Server 2000 and my
> ASP.NET 1.1 seems to be perfectly registed...|||At last, with the inspiration of the goddess in my dream, I solve the evil
problem...
(1) Cause
SQL Server 2000 Need the "Default Web Site" as one of its installation
prerequisite. When I say "Default Web Site", I mean the Site with the
identifier 1. You can view the indentifier once you click "Web Sites" in your
IIS Manager.
(2) Why I fail
Really simple, I deleted the "Default Web Site" long time ago. The install
program can not find one Web Site with identifier 1, so it fails.
(3) How to do
Create a Web Site with identifier 1. This could be done by "IIS 6.0 Resource
Kit Tools, with Metabase Explorer", Download it from
http://www.microsoft.com/downloads/details.aspx?FamilyID=56fc92ee-a71a-4c73-b628-ade629c89499&DisplayLang=en
(4) And there is a document to help you
"http://www.gafvert.info/notes/IISDefaultWebsite.htm"
Hope you lucky.|||Hi, I have the same problem, it is just that I have a nr 1 and when I tried
to change I got the erroe that I didn´t have IIS installed, prior to this I
"only" have the error that I dont have asp.net installed or configured,
despite that it is installed and configured, I have both asp.net 1.1 and 2.0,
I have tried to switch between both, but the result is the same error, any
ideas?
DQ
"CrazyCalculator" wrote:
> At last, with the inspiration of the goddess in my dream, I solve the evil
> problem...
> (1) Cause
> SQL Server 2000 Need the "Default Web Site" as one of its installation
> prerequisite. When I say "Default Web Site", I mean the Site with the
> identifier 1. You can view the indentifier once you click "Web Sites" in your
> IIS Manager.
> (2) Why I fail
> Really simple, I deleted the "Default Web Site" long time ago. The install
> program can not find one Web Site with identifier 1, so it fails.
> (3) How to do
> Create a Web Site with identifier 1. This could be done by "IIS 6.0 Resource
> Kit Tools, with Metabase Explorer", Download it from
> http://www.microsoft.com/downloads/details.aspx?FamilyID=56fc92ee-a71a-4c73-b628-ade629c89499&DisplayLang=en
> (4) And there is a document to help you
> "http://www.gafvert.info/notes/IISDefaultWebsite.htm"
>
> Hope you lucky.|||SOLUTION that helped me!!
FIX: Error "ASP.NET v1.1 not Installed" while installing Sql Server 2000
Reporting Services
I finally had the chance to rebuild my dev machine with the RTM version of
Sql Server 200 Reporting Services [SQL2kRS] and ran into an unusual error.
During the "Check Prerequisites" stage of installation, it said that I didnt
have ASP.NET v1.1 installed on my PC. Considering that I do web-development
with VS.NET 2003 on this PC I was a bit perplexed why it said that.
After much digging and exploring, I finally discovered the problem. A
recent install of the new XP version of the Longhorn Command Shell had
installed the .NET Framework v2.0.31113.33 and set it as the Root Version of
the framework for ASP.NET.
So, the fix is pretty trivial, just update the RootVer registry value to
correctly (or temporarily) show v1.1.4322.573.
[\\HKLM\SOFTWARE\Microsoft\ASP.NET\RootVer] = "1.1.4322.573"
Strangely enough, this didnt seem to be affecting my ASP.NET applications.
*shrug*
None of this was documented in the verbose Help files that shipped with
SQL2kRS. This got me thinking about the nature of help files. Far too
often, I see FAQ's and "Common Issues" under the Troubleshooting section of
help files, yet rarely do I have those "common" problems.
I would much prefer a generic section on, "How to troubleshoot", "Where to
look for error clues", and provide deep lists of "Why an application or
installation might fail".
In this case, I actually did find a good reference in the Help entitled "Log
Files Used During Installation". This section explained how to locate the
log files created during installation, and this is how I eventually solved
the problem.
For reference, in SQL2kRS there are 3 main places to look for log files;
C:\Program Files\Microsoft SQL Server\80\RS Setup Bootstrap\Log\RSStp_.cab
(inside the CAB)
AND
%temp%\rsstp<integer>.log
(<integer> = number to make filename unique. e.g. rsstp2.log)
AND
%temp%\RSMSI<integer>.log
The latter 2 log files are the same ones that get copied into the CAB file
listed above, but its still useful knowledge in case something fails before
they get added to the CAB.
"DQ" wrote:
> Hi, I have the same problem, it is just that I have a nr 1 and when I tried
> to change I got the erroe that I didn´t have IIS installed, prior to this I
> "only" have the error that I dont have asp.net installed or configured,
> despite that it is installed and configured, I have both asp.net 1.1 and 2.0,
> I have tried to switch between both, but the result is the same error, any
> ideas?
> DQ
> "CrazyCalculator" wrote:
> > At last, with the inspiration of the goddess in my dream, I solve the evil
> > problem...
> >
> > (1) Cause
> > SQL Server 2000 Need the "Default Web Site" as one of its installation
> > prerequisite. When I say "Default Web Site", I mean the Site with the
> > identifier 1. You can view the indentifier once you click "Web Sites" in your
> > IIS Manager.
> >
> > (2) Why I fail
> > Really simple, I deleted the "Default Web Site" long time ago. The install
> > program can not find one Web Site with identifier 1, so it fails.
> >
> > (3) How to do
> > Create a Web Site with identifier 1. This could be done by "IIS 6.0 Resource
> > Kit Tools, with Metabase Explorer", Download it from
> >
> > http://www.microsoft.com/downloads/details.aspx?FamilyID=56fc92ee-a71a-4c73-b628-ade629c89499&DisplayLang=en
> >
> > (4) And there is a document to help you
> > "http://www.gafvert.info/notes/IISDefaultWebsite.htm"
> >
> >
> > Hope you lucky.