Connecting to Report Manager on a Windows 2008 or Vista machine
Yesterday we had a problem with connecting to ReportManager on our Report Server. The machine is running Windows 2008 x64 Enterprise and SQL Server 2008 x64 Enterprise. Connecting to ReportManager from our machines (running Windows 2003 Standard) was fine, we could manage the reports and DS's etc.
We then tried creating reports locally on the server and then went to setup a Data Source and upload the report via Report Manager. Only it told us that we did not have sufficient permissions on the machine(The account on the machine had Admin privileges).
Error Message: The permissions granted to user 'DOMAIN\username' are insufficient for performing this operation. (rsAccessDenied) Get Online Help
We spent quite a large amount of time trying all sorts without success. Finally finding out that it was the UAC permissions that caused the problem.
What is UAC you ask? Or was it just me!!!!
User Account Control as Wikipedia nicely describes here.
How do we disable this?
You can follow the Wikipedia example as described in the example or go to msconfig -> Tool Tab -> Scroll to the bottom. There will be a Tool Name 'Disable UAC' and 'Enable UAC'. Click on the 'Disable UAC' and press the Launch button. You are then required to reboot the machine for the settings to take effect.
Hope it can help someone else.
Steve