hi alli am facing a very commong issue but not able to resolve my problem. i have searched this issue on internet , found possible solutions but i am not able understand that where i am doing wrong.I have Reporting services installed on one server. when i deployed My Reporting Servies projecct to server and tried to access reports through this URL "http://[server ip address]/reports", it was asking me for User name and Password. i gave Administrator's User ID and Password, it started working. then i tried through "http://localhost/reports", and it was working without asking for authentication. To get rid of above problem, i went through several articles on internet, below is list of some articles:http://msdn.microsoft.com/en-us/library/ms365173(SQL.90).aspxhttp://support.microsoft.com/kb/938245http://msdn.microsoft.com/en-us/library/ms159133.aspx So finally i resloved this issue. now problem is that when some other user from Same domain acssess those reports by giving http://[server ip address]/reports, it again asks for authentication?? please can any body tell me how to get rid of this thing. Secondly, let say user gives correct UserName ([username]@[domain].com) and password, user is able to open reports. but now when user clicks on "Report Builder" button, it again asks for credentials.which kind of credentials i have to provide at this moment??? can any body help me.Jassim Munir

Please can any body help me in this matter??? i forgot to mention about my working environament. server (on which i have deployed reports) is Windows 2003 server (SP2), sql server enterprise editionJassim Munir

Hi Jassim,Based on my experience, the issue should be caused the Internet Explorer(IE) or other browser does not pass the current user's credential to the report server automatically.To solve the issue, please follow these steps(especially step13):1.Open a browser window with Run as administrator permissions. From the Start menu, click All Programs, right-click Internet Explorer, and select Run as administrator. 2.Click Allow to continue. 3.In the URL address, enter the Report Manager URL. For instructions, see How to: Start Report Manager. 4.Click Tools. 5.Click Internet Options. 6.Click Security. 7.Click Trusted Sites or Local Intranet. 8.Click Sites. 9.Add http://<your-server-name>. 10.Clear the check box Require server certification (https:) for all sites in this zone if you are not using HTTPS for the default site. 11.Click Add. 12.Click "Custom Level" 13.Check the item "Auto logon with current user name and password" 14.Click OK. Now, the logon dialog won't be prompted. If you have any more questions, please feel free to ask. Thanks, Jin ChenJin Chen - MSFT

This should help: http://blogs.msdn.com/lukaszp/archive/2008/03/26/solving-the-reporting-services-login-issue-in-the-february-ctp-of-sql-server-2008.aspxThis posting is provided "AS IS" with no warranties, and confers no rights.

OMG! Thank you so much. I have been trying to fault find this for ages. I new it was somewhere between IE and IIS but couldn't put my finger on it! Thank you so much!