Solving: Error : rsAccessDenied (The permissions granted to user ‘MyDomain\Administrator’ are insufficient for performing this operation.)

4 Comments

When deploying reports by using the rs.exe you can get the error: "Error : rsAccessDenied (The permissions granted to user ‘MyDomain\Administrator’ are insufficient for performing this operation.)".   Solution Go to the ReportManager [http://YoureServerName/Reports/Pages/Folder.aspx] Site

Install a development Microsoft SharePoint 2010 RTM Server with PowerPivot and Microsoft SQL Server R2 Reporting Services integration

5 Comments

These are the steps I followed to install a development Microsoft SharePoint 2010 server with PowerPivot and Reporting Services integration.   I installed Microsoft SharePoint Server 2010 by following the steps on: http://powerpivot-info.com/post/66-step-by-step-guide-on-installing-powerpivot-for-sharepoint   Then

How to deploy a datasource in SQL Server Reporting Services with PowerShell

3 Comments

If you want to use PowerShell to deploy a datasource in SQL Server Reporting Services use the following script:   PowerShell script "Set execution policy to [Unrestricted]" Set-ExecutionPolicy Unrestricted "Load assembly" [System.Reflection.Assembly]::LoadFrom("C:\Temp\Ada.Cdf.dll") $datasource = New-Object

How to create a folder in SQL Server Reporting Services with PowerShell

0 Comments

If you want to use PowerShell to create a folder in SQL Server Reporting Services use the following script: PowerShell script "Set execution policy to [Unrestricted]" Set-ExecutionPolicy Unrestricted "Load assembly" [System.Reflection.Assembly]::LoadFrom("C:\Temp\Ada.Cdf.dll") $folder = New-Object Ada.Cdf.Deployment.SSRS.Folder

ReportViewer control does not show default images on IIS7

3 Comments

If you use the ReportViewer control in you’re C# web application and the ReportViewer does not show the default images (refresh button etc) then you can check you’re web.config if it contains the correct axd