Tuesday 3 February 2015

Upgrading RDLC reportviewer from vs2008 to vs1010

I tore my hair out for several days over this one!

After converting web site and reports from VS2008 to VS2010, some (not all) of my reports stopped working.

All I would see was "one or more datasources is missing credentials"

I used a bare bones reportviewer control on my aps.net page, and programmatically connected it to the report and to the dataset.

This worked just fine in vs2008.

It turns out I needed a more fleshed out default report viewer .... one with the local report and a datasource specified..... even though I would replace them later in my code behind.

Tuesday 2 October 2012

SQL Server 2008 SSAS Deployment problem

A connection cannot be made to redirector. Ensure that 'SQL Browser' service is running. (Microsoft.AnalysisServices.AdomdClient)

well.... in my case, SQL Browser was running, and so were two named instances of SSAS.
I could connect to the named database engines with no problems.

In order to get SSAS to work, I found this article:
http://msdn.microsoft.com/en-us/library/cc917670.aspx

my instance of SQL Browser was running as 'LOCAL SERVICE' and it needed to run as 'LOCAL SYSTEM'