rs access denied

HI ,

Recently I have faced the issue with reporting server. I have successfully installed new SQL Server 2008 with allowing default configurations. But when I am rendering reprot server I have got error rs access denied.

Reason:

After googling and digging into more details I have got fixed the issue. The reason behind is I am running Vista Business OS and I am a Administartor ( when we have the right to install any soft ware we are administrators), So I have successfully installed SQL Server 2008 with out any hurdels. Here I have noticed that when I am installing any soft ware first it will ask right permisson to comtinue the installation meaning even though I am administartor by default I am user. So whenever you have installed SQL Server on your local machine with all administartor rights, you also must render the report server URL with admin scope.

Solution:

Right click on browser and click on Run as administartor. Now enter the report server URL and render it, I hope it will work now.

The same thing will happen with Analysis services. You need remember Analysis services only works with windows authentication. When you installed Analysis services with admini rights and you also need to create solution in admin rights.

To create solution in admin rights

Right Click on BIDS icon and select run as administartor
Then create solution and now deploy, it wont give any error.