Hello, Now in the absense of Annoy. Auth. in SQL Server 2008 Std. edition Reporting Service If I want to pass a dmain name and password while calling an Report using url as a parameter how can I do that? Any help will be appriciated. I am using domain user account to access the SSRS. Thanks Nilkanth Desai

Can you elaborate a little bit on what you are trying to achive? Why using domain user and pass as a parameterBest Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/

Thx for your response, I have to publish my SSRS reports over my ASp.NET web application. In order to achive this everytime when I want to access hosted SSRS reports I have to provide necessarry Domain\username and password. I want to provide access to those users only who pass my web app credentials. So, user need not to provide again seperate credentials to SSRS. I want to define one internal domain user who can access SSRS reports. And then use the same username and password from my web application internal calls to these SSRS reports. Now if you are clear about my objective please tell me how to achive it. Thanks, With Regards, Nilkanth Desai

Hi Nilkanth, Check the below link for complete details. http://blog.infotoad.com/post/2009/07/02/Integrating-Reporting-Services-with-Web-Applications.aspx In ASP.NET applications, the default credentials are the user credentials of the logged-in user, or the user being impersonated. Hope it works, Regards, PS

Hi Nilkanth, You can follow http://blogs.msdn.com/b/jameswu/archive/2008/07/15/anonymous-access-in-sql-rs-2008.aspx to build an anonymous authentication for your SQL Server 2008 Reporting Sevices. Also, you can impersonate the logon user as one internal defined domain user to access the report. See http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/c7e71f15-740f-412c-b1a1-cbb212a9dca7/ on how to enable impersonation authentication in your case. thanks, Jerry