Wednesday, 26 January 2011

Reporting Service Permissions on Windows 7

I installed RS on a brand new installation on windows 7 x64 with SqlServer 2008 R2, The user I was logged on had full administrative privileges, UAC was turned on as normal.

As soon I tried to access the Reporting Services Site I got the following error: The permissions granted to user 'DOMAINNAME\USERNAME' are insufficient for performing this operation


After struggling against services permissions and many other more stuff I did the following

-          Go into user management and enable the built-in administrator account

-          Log on as built-in administrator

-          Open the Report Manager and setup proper roles for my user

-          Logon with my user account, now all works…

-          You can now go back to user management and disable the built-in administrator account


Thursday, 20 January 2011

Windows Backup Issue

Windows Backup failed while trying to read from the shadow copy on one of the volumes being backed up. Please check in the event logs for any relevant errors.

Error code: 0x81000037

My system was a Windows 7 x64 Ultimate, and I was backing up to an internal HD, so nothing could be more standard

After some searching I’ve found that the problem was generated indirectly from windows media player: after configuring music library it added the root music location to system libraries. I manually removed the item from the sys libraries and … wow ! now works !

The problem (maybe) was that the link in the sys libraries was pointing to a folder that is a mount point for another internal HD with all my music stuffs.