I am trying to set up a stand lone test desktop with Windows XP pro and a
trail version of SQL Servrer 2005 edition.  I have installed SQL Server 2005
Analysis Services, Data Engine, Notification Services, and Reporting
Services.

I have made sure the Configure Report Servers do not have any errors.

When I open the Internet Explorer and type in http://localhost/reports I
received the following error.

Server Error in '/Reports' Application.

Failed to access IIS metadata.

The process account used to run ASP.NET must have read access to the IIS
metadase.

Please help me resolve this error.

Thanks,

[ Post a follow-up to this message ]

On Nov 16, 2:59 pm, Joe K. <Joe K...@discussions.microsoft.com> wrote:
> I am trying to set up a stand lone test desktop with Windows XP pro and a
> trail version of SQL Servrer 2005 edition.  I have installed SQL Server 20
05
> Analysis Services, Data Engine, Notification Services, and Reporting
> Services.
>
> I have made sure the Configure Report Servers do not have any errors.
>
> When I open the Internet Explorer and type inhttp://localhost/reportsI
> received the following error.
>
> Server Error in '/Reports' Application.
>
> Failed to access IIS metadata.
>
> The process account used to run ASP.NET must have read access to the IIS
> metadase.
>
> Please help me resolve this error.
>
> Thanks,


Which edition of SQL Server 2005 are you trying to install on XP Pro,
and is it documented to be supported on XP Pro?

If the edition is not supported on XP Pro, then I think your test
desktop setup is invalid and not worth fixing the error.

In particular, by default ASP.Net applications run with ASPNET
identity on XP Pro and Network Service identity on Windows Server
2003. The former does not have
read permissions to the IIS metabase while the latter does. Are you
sure that is the only problem? Configure Report Servers setup cannot
verify that your existing setup actually works -- it can only validate
that pre-reqs are existing but not the functionality of those pre-
reqs.

You can download free trial versions of SQL Server 2005 along with
trial versions of the Windows Server OS you plan to eventually install
it on, to make a more complete temporary test desktop. You can even
run the entire thing inside a Virtual Machine of Windows Server 2003
with SQL Server 2005 completely free for evaluation purposes on XPSP2,
so you need not taint a client OS setup with a server product.


//David
http://w3-4u.blogspot.com
http://blogs.msdn.com/David.Wang
//

[ Post a follow-up to this message ]