Pass Network Credentials for external users, No Prompt required!

[memdiscount]

Hi;

Here is the enviornment:

1- SQL Server 2000
2- SQL Server Reporting Services 2000
3- Windows Server 2003
4- We have desgined some reports in SSRS and made them available for external clients using the IP address of the server
5- We have setup on User which is part of our domain
6- For Reports we are using SQL Login to authenticate the data
7- In IIS we don't give access to ananymous users

Issue:

1- When we call reports, it prompts user to provide user name and password.

2- Even the users which are part of the domain needs to provide the username and password to access the report

3- For external users, they provide the fixed user name and passwords as we only setup on user for reports in our domain.

4- We want to remove that prompt and pass the network credentials thru programming or any other way.

Status of my research:

1- I have searched on internet and found that it is possible in Visual Studio 2005 using report viewer which has functions to get network credentials

2- I discussed with friends and other professionals, it sounds like that it is not possible in SQL Server Reporting Services 2000

Now, I thought I should post it to tek-tips professionals.

I need help from you.

Thanks