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

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 Settings (on top of the page) Security Add you’re account to the role [System Administrator] …

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

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 I followed the steps on: http://technet.microsoft.com/en-us/library/bb326356(SQL.105).aspx and http://msdn.microsoft.com/en-us/library/aa905871(SQL.105).aspx to enable Microsoft SQL Server 2008 R2 …

How to deploy a report (*.rdl) file to SQL Server Reporting Services using PowerShell

If you want to deploy a report (*.rdl) file to SQL Server Reporting Services in PowerShell, 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") "Create report" $report = New-Object Ada.Cdf.Deployment.SSRS.Report $report.SSRSWebServiceUrl = "http://localhost/ReportServer/ReportService2005.asmx" $report.SSRSFolder = "ADA Sales Reports" $report.FileSystemPath = "C:\Reports\AanvragenStats.rdl" …

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

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 Ada.Cdf.Deployment.SSRS.DataSource $datasource.SSRSWebServiceUrl = "http://localhost/ReportServer/ReportService2005.asmx" $datasource.ImpersonateUser = $false $datasource.WindowsIntegratedSecurity = $true $datasource.UserAccountName = "MyDomain\saAsaWeb" $datasource.UserAccountPassword = …

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

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 $folder.SSRSWebServiceUrl = "http://localhost/ReportServer/ReportService2005.asmx" $folder.Name = "ADA Sales Reports" $folder.Parent = "/" $folder.Create()       …

Explaining SSRS datasource options “Use as Windows credentials when connecting to the datasource” and “Impersonate the authenticated user after a connection has been made to the datasource”

In SSRS ther are two options you can set, when the credentials of the datasource are stored securely in the report server: Use as Windows crendentials when connecting to the datasource This option must be checked, when you want to use “Windows Integrated Security Authentication” and not “SQL Authentication” Impersonate …

ReportViewer control does not show default images on IIS7

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 handler: <add name=": Reserved-ReportViewerWebControl-axd" path="Reserved.ReportViewerWebControl.axd" verb="*" type="Microsoft.Reporting.WebForms.HttpHandler" resourceType="Unspecified" preCondition="integratedMode" /> In mine web.config it look …