SQL RS Custom Authentication and WSS

Hi,

I am trying to implement custom authentication as per the instructions in the following documents:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/ufairs.asp

http://www.devx.com/dotnet/Article/27133

But, I was able to make it work without Windows Sharepoint Services(WSS) but not with it.
I was wondering that has anyone tried to extend the security of RS and make it work with WSS installed on the same machine.

My Machine information is:

1. Windows 2003 Server
2. SQL Server 2K with SP3a and SP4
3. SQL server 2000 Reporting Services
4. Visual Studio .NET 2003
5. WSS

I have tried to get a workaround WSS problem for almost 2 days now and nothing seems to work.

The reason I want to have my own security extension for RS is that I want to use RS from an existing Web Application which has thousands of users and we already have our own authentication mechanism for it.
We dont want the Reporting Server to be run from one specific Windows account or by the annonymous user IUSR_MACHINE Windows account.

Thanks
-Paresh

[1665 byte] By [pgupta] at [2007-12-16]
# 1
Do you have Reporting Services and SPS playing nicely on the same box without using your custom authentication? There are some additional steps that you have to take:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSinstall/htm/gs_installingrs_v1_9fdy.asp

If it's working without the custom authentication scheme, can you give us some more information on how it is failing when you enable custom auth?

JamesKovacs at 2007-9-9 > top of Msdn Tech,SQL Server,SQL Server Reporting Services...

SQL Server

Site Classified