At a client we had to produce a server, in order for us to have a development environment, since they couldn’t spare the server power. Odd situation, but that’s not the point. The point is that, somewhere during the installation process of this server, after installing SQL Server, we noticed that the server wasn’t a domain controller. Now the SQL Server and in particullar Reporting Services (SSRS) was installed with credentials granted to the build-in Network Services account. This account gets a new SID once we installed the domain controller, and after that SSRS started acting on us.
The new Network Services account needs to be granted modify permissions to the following folders:
- C:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\LogFiles
- C:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\RS\TempFiles
One can only guess, but it seems as if there was a memory leak in some method in the mdsonar.cpp file used by Analysis Services.
As I was trying to create a cache for a cube, to speed up querying, I ran into the error message listed below:
When I binged the filename mdsonar.cpp, I ony got two (2) hits. Normally this would freak me out a little, but the two links were actually the ones I was looking for, sort of. At least they lead to a plausible solution, unfortunately not an explanation. The solution is to apply the latest Service Pack/Cumulative Update, as listed in KB2660492, for the SQL Server 2008 (not R2) installation I was working on. Regrettably I am not in a position to verify this KB will actually solve this problem, as I am on a tight schedule and out of time. This is really one of those situations where the client would benefit from a little extra effort.
In short I was trying to create a cache of a fairly large set, comprised of several attributes from a couple of dimensions. One dimension has about 850K members and the other has about 45K member. It would seem this was too big a mouthfull, before Service Pack 3 on SQL Server 2008 Analysis Services.
As the agenda for SQL Bits X was released, I had my take on what sessions I wanted to attend.
Now, two full days ahead, I’ve managed to almost pin down all the sessions I am going to immerse into.
Thursday: “Deep dive into Analysis Services” session by Akshai Mirchandani (LinkedIn)
Friday: Keynote, CDC by Allan Mitchell (blog|twitter), “SSIS in SQL Server 2012, Part 1: Developer Enhancements” by Matt Masson (blog|twitter), SSAS Load testing by Bob Duffy (blog) and finally SSAS Security by Chris Webb (blog|twitter)
Saturday: SSIS Dev Part 2., Keynote, then of to either Alex Whittles (blog|twitter) Loading dimensions in DW OR Extended Events by Bob Beauchemin , Performance investigations by Akshai Mirchandani (LinkedIn), Declarative Database Development by Gert Drapers and finally Deep dive into DW in SQL Server 2012 by Dejan Sarka (blog)
It has been really hard to decide what sessions to attend, and I might even change my mind on a few of them… So much knowledge to gain (must get the recordings if any are released).
I have been going over the agenda several times in these past two months and I must say that the SQLBits guys have done one *biiip* of a fine job putting this schedule together.