 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / Services / Reporting Services / July 2008Windows Authentication not Working in Report Manager
Each time we go to Report Manger, IE requires us to enter id and password. It will not save passsword and will not pass Windows Authentication. I HAVE done the folowing IIS-Default Website-Reports-Properties -Directory Security - [X] Integrated WIndows Authentication Anonymous login is not checked, The report server IS part of the domain, I am logging on to an app- server (also in domain) as a domain account user, opening IE and going to http://rptserver/reports and it is requiring log in credentials Am I missing something somewhere? Bob <bob@ebearings.com> wrote in news:587b4071-19a4-481f-a39f-62a3dbd35815 @t54g2000hsg.googlegroups.com: > Each time we go to Report Manger, IE requires us to enter id and > password. It will not save passsword and will not pass Windows [quoted text clipped - 10 lines] > > Am I missing something somewhere? what about ntfs permissions? what happens if you log onto the workstation you use to access rep server using a domain admin account?  SignaturePaolo opg BE AWARE that this post uses a fake reply-to address to contact me write to: janickg ( at ) hotmail ( dot ) com -- > Bob <b...@ebearings.com> wrote in news:587b4071-19a4-481f-a39f-62a3dbd35815 > @t54g2000hsg.googlegroups.com: [quoted text clipped - 26 lines] > janickg ( at ) hotmail ( dot ) com > -- I logged in to the app-server as mydomain\admin and went to explorer and then reporting services and it STILL asked for user and password. What you are seeing is the issue with Windows 2003 advanced IE security. If you tried this from XP you wouldn't see this problem. To disable this do the following: Disabling Internet Explorer Enhanced Security Configuration (on Win2k3 member server) http://www.visualwin.com/IE-enhanced-security/ SignatureBruce Loehle-Conger MVP SQL Server Reporting Services > Each time we go to Report Manger, IE requires us to enter id and > password. It will not save passsword and will not pass Windows [quoted text clipped - 10 lines] > > Am I missing something somewhere? On Jun 5, 12:34 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@hotmail.com> wrote: > What you are seeing is the issue with Windows 2003 advanced IE security. If > you tried this from XP you wouldn't see this problem. [quoted text clipped - 25 lines] > > - Show quoted text - Bruce, I checked that out on the server and it is NOT enabled Caution: Internet Explorer Enhanced Security Configuration is not enabled I still got the log in requirement and I was mydomain\administrator Bob OK, now comes stupid time.... I just figured out that if I use http://192.168.1.144/reports, it asks for a user and password everytime. If I use the server name http://report-serv/reports and I am logged into domain, it does NOT require authentication. Why is that? Bob No idea but interesting. I'll try and remember that the next time someone has a problem. I tend to use names instead of a sequence of numbers in my URL <g> SignatureBruce Loehle-Conger MVP SQL Server Reporting Services > OK, now comes stupid time.... > [quoted text clipped - 6 lines] > > Bob > OK, now comes stupid time.... > [quoted text clipped - 6 lines] > > Bob I wish my IE would ask for a username/password!! I also use http://192.168.1.144/reports but WITHOUT an authentication challenge. In fact I summarily get "You are not authorized to view this page"! Infuriating! How am I supposed to tell the server who I am? I someone knows the answer, PLEASE let me know. Thanks, Gerhard It should automatically expand what you typed to this but just in case, use this link: http://yourserver/reports/Pages/Folder.aspx Assuming that makes no difference. It sounds to me like it is working as it should. You are logged into Windows. Your box knows who you are. It authenticates with RS and it knows who you are. And whoever you are does not have rights. If you use a file server this is the same thing. Accessing folders on the file server does not prompt you for a username and password. It knows who you are. Same thing here. Is your domain account a member of the local administrators group on the box running RS. By default everyone in that group is an admin for RS and should be able to see reports. If not, then someone who is needs to add you to a role in RS. SignatureBruce Loehle-Conger MVP SQL Server Reporting Services "> I wish my IE would ask for a username/password!! > > I also use http://192.168.1.144/reports but WITHOUT an authentication [quoted text clipped - 8 lines] > > Gerhard Bruce L-C [MVP] wrote: > It should automatically expand what you typed to this but just in case, use > this link: [quoted text clipped - 13 lines] > be able to see reports. If not, then someone who is needs to add you to a > role in RS. Bruce, Thank you for your reply. I am not on a domain. We have set up the report server with an account to log on as to view reports. This has always worked! Upon investigation I've discovered that the RS is not running and it won't start. I am uncertain what changed, I'm busy investigating now. I did notice that the server was updated recently (Windows Update). I'll see if that has anything to do with it. > Bruce L-C [MVP] wrote: >> It should automatically expand what you typed to this but just in [quoted text clipped - 26 lines] > did notice that the server was updated recently (Windows Update). I'll > see if that has anything to do with it. Solved it. For some reason the web server was configured to allow anonymous access. Don't ask me how that happened!! |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.