September 21, 2007 at 7:45 am
Hello All,
I just install SQL 2005 on my laptop that have Windows Vista Business. I install with all default settings. Everything is working fine except for the Reporting Service. When I open IE and enter http://localhost/ReportServer, a Windows popup and prompt for the username and password. I enter the username and password that I use to logon to the laptop and receive this message:
The permissions granted to user 'BRYAN\Crystal' are insufficient for performing this operation. (rsAccessDenied).
Can you please tell me what account do I use to access the Report Server. Any help/suggestion is greatly appreciated.
Thanks
September 23, 2007 at 10:05 pm
If you only want to browse through the reports then your account needs to have the browser permissions. You need to have the admin rights(content Manager) to assign a role to any other login.
September 24, 2007 at 8:44 am
Thank you for your response. How and where do I grant the permission you mention to the Crystal user? As I mention in the original post, Crystal is a user I logon to the laptop and has full-right to the machine. Thanks
September 25, 2007 at 6:40 am
Are you able to connect to reporting services through Management studio. What login you use to connect there?
September 26, 2007 at 6:12 am
Try this for setting up RS on Vista: http://www.jameskovacs.com/blog/ReportingServicesOnWindowsVistaRedux.aspx
When connecting to RS via Management Studio try using the web address; for example, https://localhost/reportserver
-Mike
September 26, 2007 at 9:13 am
Yes. the only option work when connecting to Reporting Service in SQL Server Management Studio is Windows Authentication. Any idea? Thanks
September 26, 2007 at 9:17 am
Hi Mike,
Thanks for the link. I follow the instruction and still do not see anything other than the HOME area where I can not do anything...I did see on the bottom of IE an indication of Trusted Site Protected Mode: Off.
I have Norton Antivirus software running on the laptop. Will Norton interfere with RS? Thanks
September 27, 2007 at 6:46 am
I can't see any reason why Norton would interfere. I use TrendMicro without issue so... I would walk through the instructions again and just make sure something wasn't missed. If you still don't have maybe try another web browser like FireFox or Opera and just see if it works. If it still dosen't work then I think it sounds like an RS issue otherwise it sounds like a Permissions issue. You could also try connecting to RS on your PC from another non-Vista PC. I am assuming you also have admin rights on your PC.
Hope this helps...
-Mike
September 27, 2007 at 7:53 am
Mike,
Thank you for your inputs. I'll definitely try the steps again. I'm thinking that it is the permission issue. I just don't know enough to resolve it. Hopefully other forum participant encounter this same issue and can offer the resolution. By the way, when I look in the Reporting Services Configuration Manager, under Windows Service Identity, a Built-in Account Local System radio button is check. I try to change it to Windows Account and use the user that have full right to the machine but
Setting up Windows Service Identity to Window Account Error
ReportServicesConfigUI.WMIProvider.WMIProviderException: The account name is not valid. Specify an account in the form domain\alias.
at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.SetWindowsServiceIdentity(String accountName, String password, Boolean useBuiltinAccount)
September 28, 2007 at 11:20 am
Hello,
I was experiencing the same Problem some time back
In the advance tab of the internet options uncheck enable windows authentication. Apply n reopen the browser
If Using Firefox
1) Open up Firefox and type in about:config as the url
2) In the Filter Type in ntlm
3) Double click "network.automatic-ntlm-auth.trusted-uris" and type in localhost and hit enter
4) Write Thank You To Blogger
I found both the solutions at Thescripts.com
Original post : http://www.thescripts.com/forum/thread590809.html
...Kumar
October 11, 2007 at 5:03 am
Well go to IIS manager, go to the Report Manager/Report Server virtual directories and go to Directory Security Tab, Edit the Anonymous access and Authentication settings and enable Integrated Windows Authentication. It should work.
Prasad Bhogadi
www.inforaise.com
October 25, 2007 at 2:08 pm
I feel your pain...
Here's what I did to get around it, and some things to avoid.
1) The solution that worked for me...
Open IIS Manager (Not IIS6 manager, although it is an option and was required for installing SSRS). Give yourself admin access when asked.
2) Open the computer, web sites, and defaul web sites tree.
Right click on ReportServer (unless you named it something different in the SQL Configuration tool), and select advanced properties.
3) In the Physical Path Credentials, add the account info for the account you are using for accessing all the SSRS stuff.
You should now be running.
Meanwhile...
In order for SSRS to run happily, it needs to be in a classic application pool in IIS. The proper way to set this is through the SSRS Configuration tool, NOT through IIS Manager. One lonely page of books online states that the configuration tool uses the information apart from IIS in some manner such that if you only change the application pool in IIS, you may be hosed. {Paraphrased from BOL. 🙂 }
Happy reporting!
April 26, 2008 at 12:27 pm
I'm sincerely grateful for the Firefox fix. I figured it was a report manager or IIS issue. Sometimes, it's the simplest things that cause the most frustration.
Viewing 13 posts - 1 through 12 (of 12 total)
You must be logged in to reply to this topic. Login to reply