Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jassimmunir
Starting Member
9 Posts |
 Posted - 2010-01-24 : 08:46:09
|
| 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 those articles:http://msdn.microsoft.com/en-us/library/ms365173(SQL.90).aspxhttp://support.microsoft.com/kb/938245http://msdn.microsoft.com/en-us/library/ms159133.aspxSo 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. Best Regards,Jassim Munir |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-01-24 : 09:34:07
|
| what data source you are using for reports? is it a shared one? what credentials you're using on it? |
 |
|
|
jassimmunir
Starting Member
9 Posts |
Posted - 2010-01-26 : 07:15:41
|
| i am using Shared Data source for reports and In Credentials i am using "Use Specific username and Password" and giving sa and sa's password in User ID and Password fieldBest Regards,Jassim Munir |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-01-26 : 07:21:52
|
quote:
Originally posted by jassimmunir
i am using Shared Data source for reports and In Credentials i am using "Use Specific username and Password" and giving sa and sa's password in User ID and Password fieldBest Regards,Jassim Munir
is the other user also using same login to logon to report url? |
|
|
|
jassimmunir
Starting Member
9 Posts |
Posted - 2010-01-27 : 02:39:55
|
| yes exactly, other user is also giving same user name and passwordBest Regards,Jassim Munir |
|
|
|
|
|
|
|
|
Why Asking for Authentication Credentials... ?