permissionsreporting-servicessql-server-2008
I'm having trouble with SQL Server 2008 (Express with Advanced Services) Reporting Services permissions. I'm running this on Vista Ultimate at home – standalone machine with no servers, no domain or active directory.
When I go to the ReportServices site, I get this:
The permissions granted to user
'localmachine\Scott' are insufficient for
performing this operation.
(rsAccessDenied)
I don't remember having a problem at the office with SQL Standard on Windows 2008.
SQL Server 2005 onwards:
IF EXISTS(SELECT 1 FROM sys.columns
WHERE Name = N'columnName'
AND Object_ID = Object_ID(N'schemaName.tableName'))
BEGIN
-- Column Exists
END
Martin Smith's version is shorter:
IF COL_LENGTH('schemaName.tableName', 'columnName') IS NOT NULL
BEGIN
-- Column Exists
END
Please check the ServerName which you provided. It should match with the below shown Name in the UserName textbox, and that name should followed with \SQLEXPRESS:
Best Answer
Try running IE as admin and then going to the page. Then under settings add your user and give it permissions. You should be able to run IE not as admin after that. This worked for me using SSRS 2005 under vista.
If not that, then check which user account the service is running as.
See the MSDN page about How to Configure Reporting Services on Vista and Server 2008