SQL Server Reporting Service 2008 on vista home premium

Question

SQL Server Reporting Service 2008 on vista home premium

vstitte

SSCarpal Tunnel

Points: 4475
More actions
August 1, 2009 at 10:52 pm

#208860

I have installed SQL Server 2008 Developer edition on VISTA Home Premium.
Even though Reporting Services shows as started on the machine, I cannot access the Report Server.
It is installed with default configuration. On opening this URL http://localhost/ReportServer/, I get a error message
Reporting Services Error
--------------------------------------------------------------------------------
The permissions granted to user '' are insufficient for performing this operation. (rsAccessDenied)
I am the administrator on the machine and all SQL server services are running using my account.
I cant find anything on the MS support site. All I have gathered so far is, that SQL Server reporting services requires Windows authentication and VISTA home premium doesnt support windows authentication.
Are there any work arounds to this problem? Also please let me know if additional information is needed.
Thanks

Viewing 14 posts - 1 through 13 (of 13 total)

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

Gift Peddie SSC Guru Points: 73570 More actions · Answer 1

All I have gathered so far is, that SQL Server reporting services requires Windows authentication and VISTA home premium doesnt support windows authentication.

I think that is not relevant to SQL Server 2008 users however 2008 comes with separate page for Vista and Windows 2008 users for security reason. Check below for how to resolve your access denied error.

http://technet.microsoft.com/en-us/library/bb630430.aspx

Kind regards,
Gift Peddie

vstitte SSCarpal Tunnel Points: 4475 More actions · Answer 2

I did follow the steps in the document. But on the ReportManager Home page, I dont have a link for Properties. So not sure, how I can set the necessary settings for the account.

Thanks

Gift Peddie SSC Guru Points: 73570 More actions · Answer 3

Try right click and go to properties and see what are the settings.

Kind regards,
Gift Peddie

vstitte SSCarpal Tunnel Points: 4475 More actions · Answer 4

Hello GP,

Appreciate your responses. Where do I right click on this page? It is blank page with just the Report header that has 3 links to the right. The links are named as

Home: Takes you back to the same page

My Subscriptions: It is vanilla SQL Server Reporting services install so there is nothing to subscribe.

Help: Takes you to Report Manager online help

There is nothing else on this page. I wish I could attach a screen shot here.

Thanks

Venk

Gift Peddie SSC Guru Points: 73570 More actions · Answer 5

I think you have not defined any permissions at this point so check the thread below to start and if needed check the second thread I have covered most known issues in the second thread. It will take at least one hour to clean it up.

http://www.sqlservercentral.com/Forums/Topic731612-150-1.aspx

Kind regards,
Gift Peddie

vstitte SSCarpal Tunnel Points: 4475 More actions · Answer 6

GP,

I reviewed stuff on the link. I have checked everything and still dont have the issue resolved.

Anything else I can check.

Appreciate the help.

Thanks

Gift Peddie SSC Guru Points: 73570 More actions · Answer 7

First check to make sure you are no using IIS because you don't have IIS7 with Windows Authentication and you have to make sure you define all the relevant permissions. You also need to add Report Manager url to your trusted sites definition in IE under security.

Kind regards,
Gift Peddie

vstitte SSCarpal Tunnel Points: 4475 More actions · Answer 8

Permissions are set. The Report Manager URL is part of the trusted sites.

The user is an administrator on the machine. Have set the services to run using the specific user and the user has been assigned sysadmin role.

Restarted and tried and still the same issue.

Gift Peddie SSC Guru Points: 73570 More actions · Answer 9

I don't think you have disabled all you need to disable and added all the permissions in ReportServerDB, ReportServerTempDB and have verified that SSRS is using the correct account when you are configuring Report Manager. The links below will give you more things to check. I know I covered most but I was not using Vista which comes with UAC.

http://msdn.microsoft.com/en-us/library/ms156034.aspx

http://www.jameskovacs.com/blog/CommentView.aspx?guid=815aa158-39bb-4cd8-a73b-5febe976adef

Kind regards,
Gift Peddie

K. Brian Kelley SSC Guru Points: 114642 More actions · Answer 10

Is UAC on? Is Internet Explorer running in protected mode?

K. Brian Kelley
@kbriankelley

vstitte SSCarpal Tunnel Points: 4475 More actions · Answer 11

Really dumb of me. In the Browser, security options for Intranet sites, i set it automatic login using current username and password fixed the issue.

Thanks GP for your help. All of your posts actually helped me in troubleshooting this issue.

Venk

Gift Peddie SSC Guru Points: 73570 More actions · Answer 12

vstitte (8/22/2009)
Really dumb of me. In the Browser, security options for Intranet sites, i set it automatic login using current username and password fixed the issue.
Thanks GP for your help. All of your posts actually helped me in troubleshooting this issue.
Venk

I am glad I could help.

🙂

Kind regards,
Gift Peddie

iyacaman Grasshopper Points: 17 More actions · Answer 13

What I know about this issue is that machine administrators by default have administrator rights in Report Manager and Report Server. The problem with Vista is that it does not let Report Server (or any other application) know that you are an Administrator. So just for Vista, you have to run Internet Explorer as Administrator the first time, and register your windows account in Report Manager and Report Server as Content Manager and Site Administrator respectively.