SSRS 2008 R2 on Win 7 Home

Question

SSRS 2008 R2 on Win 7 Home

Kwisatz78

SSChampion

Points: 12478
More actions
September 18, 2011 at 9:05 am

#247872

Hi all
I have performed a native install of SSRS 2008 R2 on Win7 Home edition. Now when I have try to access the Report Manager I get an error of :
User 'xxx\xxx' does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed.
The things I have tried are running IE as admin, adding the user to the IIS_IUSRS and SSRS2008 groups but I still get the error.
I installed the SSRS service as a local system account, could that have an impact?
Thanks

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

SQLRNNR SSC Guru Points: 281334 More actions · Answer 1

Have you tried disabling UAC? Merely as testing purposes to rule out UAC.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

CoolCodeShare SSCrazy Points: 2584 More actions · Answer 2

I have performed a native install of SSRS 2008 R2 on Win7 Home edition. Now when I have try to access the Report Manager I get an error of :
User 'xxx\xxx' does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed.
The things I have tried are running IE as admin, adding the user to the IIS_IUSRS and SSRS2008 groups but I still get the error.
I installed the SSRS service as a local system account, could that have an impact?

Please try Network Service account and double check at your Reporting Service Configuration Manager console. I do not think you need to do anything else.

also I can see some clue here- 'xxx\xxx' . Are you a part of domain. Or some wrong configuration thing? pls confirm.

Regards,

Sudhir

Kwisatz78 SSChampion Points: 12478 More actions · Answer 3

Hi thanks for the replies.

What I did in the end was to enable the Super Admin account in Windows 7 which by passes all UAC, I then re-installed SSRS and now it seems to work.

Not fully understanding why when I try to use a different account to access report manager I still get the error though.

I am not part of a domain, it was just machine name\account.

Thanks

CoolCodeShare SSCrazy Points: 2584 More actions · Answer 4

What I did in the end was to enable the Super Admin account in Windows 7 which by passes all UAC, I then re-installed SSRS and now it seems to work.
Not fully understanding why when I try to use a different account to access report manager I still get the error though.

using Super Admin for this purpose is not a wise idea.

What error you are getting now?

And what was the user earlier, was that you? (in xxx/xxx)

Kwisatz78 SSChampion Points: 12478 More actions · Answer 5

Yes it was my own account. This is just on my local machine so wasn't too bothered about security as was for personal development, however I am still intrigued to know why my account doesn't work.

I have checked all the groups and Administrator and my own account are in the same groups, and are both SA in the DB. There must be some other permissions I need to set somewhere, maybe on the SSRS folders on the file system?

Thanks