Microsoft SQL isapi extension ERROR and SQLXML 3.0

Hi,

I'm using WinXP SP 2, IIS 5.1, SQL Server 2005 Standard, and Visual Studio 2005 Professional.

When I create a virtual directory with IIS Virtual Directory Management for SQLXML 3.0, I get a Microsoft SQL isapi extension error when going to the default page.

If I delete the virtual directory, and then add it directly in the IIS snap-in, with executable permissions, all goes well.

My website is from the Wrox book, Beginning ASP.NET 2.0. An appendix in the book says to add the virtual directory with the SQLXML 3.0 tool, and not to use IIS. I'm very new to this, so I'm not sure if I'll lose functionality down the road or not, by using IIS.

Has anyone run into this before or have any ideas how to get sqlxml 3.0 virt. dir's to work?

The error according to Microsoft support is related to permissions in SQL Server, I also found a FAQ from the SQLXML experts so you will find the answers to all your questions. Hope this helps.

http://support.microsoft.com/kb/820874

http://sqlxml.org/faqs.aspx?faq=79

Microsoft Reporting Service

I have the following Question:

Is it possible to install a Reporting Service at IIS Webserver without
SQL Server 2000 on the same machine.

We have a Enterprise SQL Server at another machine and i don't want to
install another SQL Server at a IIS.

Thank you for all responses

Flecki"flecki" <thorsten.fleckenstein@.de.cpm-int.com> wrote in message
news:f2626ae2.0409222330.309f741f@.posting.google.c om...
>I have the following Question:
> Is it possible to install a Reporting Service at IIS Webserver without
> SQL Server 2000 on the same machine.
> We have a Enterprise SQL Server at another machine and i don't want to
> install another SQL Server at a IIS.
> Thank you for all responses
> Flecki

Yes - you can use a remote database:

http://msdn.microsoft.com/library/d...grs_v1_8k82.asp

Simon