UAC Windows 7 (Home Prem) 64 bit and SQL 2008 r2 (10.50.1600.1) 64 bit
Hi all, Firstly apologies for having to ask this question, but for all I've follwed the instructions on forums/MSDN/Technet etc i cannot get past the following error:- Home | Help SQL Server Reporting Services Error User 'tewss-002\twindsor' does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed. Home I have followed the forums through several times, but no matter what I set, when running IE 8 as 'run as administrator' I get the username and passowrd prompt filling in my details... this is what i get. Please can someone help me, I need to get some reports developed now!! Thanks in advance. TimBehaviour Manager V4
January 14th, 2011 12:49pm

Hi Tim Winder, UAC is causing the error, from http://support.microsoft.com/kb/934164. >>Configure the report server for local administration. To access the report server and Report Manager locally, follow these steps: Start Windows Internet Explorer. On the Tools menu, click Internet Options. Click Security. Click Trusted Sites. Click Sites. Under Add this Web site to the zone, type http://<var>ServerName</var>. If you are not using HTTPS for the default site, click to clear the Require server certification (https:) for all sites in this zone check box. Click Add. Repeat step 7f and step 7g to add the http://localhost URL, and then click Close. Note This step enables you to start Internet Explorer and open either the localhost or the network computer name of the server for both the Report Server application and the Report Manager application. >>Create role assignments that explicitly grant you access together with full permissions. To do this, follow these steps: Start Internet Explorer together with the Run as administrator option. To do this, click Start, click All Programs, right-click Internet Explorer, and then click Run as administrator. Open Report Manager. By default, the Report Manager URL is http://<var>ServerName</var>/reports. If you use SQL Server Express with Advanced Services SP2, the Report Manager URL is http://<var>ServerName</var>/reports$sqlexpress. If you use a named instance of Reporting Services, the Report Manager URL is http://<var>ServerName</var>/reports$<var>InstanceName</var> In the Home dialog box, click Properties. Click New Role Assignment. Type a Windows user account name by using the following format: <var>Domain</var>\<var>User</var> Click to select the Content Manager check box. Click OK. In the Home dialog box, click Site Settings. Click Configure site-wide security. Click New Role Assignment. Type a Windows user account by using the following format: <var>Domain</var>\<var>User</var> Click System Administrator. Click OK. Close Report Manager. Use Internet Explorer without the Run as administrator option to reopen Report Manager. Also, see the following thread http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/e8da121a-c0ac-4d0b-8774-abd5128d88fe Thanks, Challen FuChallen Fu [MSFT] MSDN Community Support | Feedback to us Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Free Windows Admin Tool Kit Click here and download it now
January 17th, 2011 12:21am

Not the answer!! I have tried the above many times, ressetting and starting again.... This is what I have so far:- 1. remove UAC all together and re-boot your computer 2. Access the reportmanager (having already added the trusted site for your server) 3. Configure a user as System Administrator and System User 4. Click on home and you should be access to create folders etc. 5. Return access control on and reboot 6. Now here's the problem - I can only access the site settings! if I go to Home i still get the error:- User 'tewss-002\twindsor' does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed. So still stuck for now.... (unless of course I keep UAC off).... Any help would still be appreciated..... Tim Behaviour Manager V4
February 1st, 2011 6:50pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics