Reporting Services og lokal Domain Controller issue

Problem:

Jeg havde forleden den førnøjelse, at installere en Domain Controller lokalt på det udviklingsmiljø vi arbejder på. Vi har måtte troppe op med egen server, da kunden ikke kunne afse serverkraft til et udviklingsmiljø. Så maskinen står altså i et domæne vi ikke rigtig kan kontrolere.

Reporting Services, og i særdeleshed rsreportserver.config, håndterer det ikke så elegant som man kunne have ønsket sig. Servicen kører, i vores tilfælde, under kontoen Network Services, som erstattes i det øjeblik Domain Controlleren bliver installeret. Kontoen får altså tildelt en ny SID.

Problemet opstår fordi Reporting Services registrerer SID’en på Network Services, som jo erstattes. Hvorfor den nye konto ikke længere har adgang.

Løsning:

Giv kontoen Network Services rediger/modify rettigheder til mapperne: C:Program FilesMicrosoft SQL ServerMSRS10.MSSQLSERVERReporting ServicesLogFiles og C:Program FilesMicrosoft SQL ServerMSRS10.MSSQLSERVERReporting ServicesRSTempFiles

Stoned Sheep – Covers

Jeg faldt lige over vores gamle demo-indspilninger og tænke at jeg lige ville lægge dem op her 🙂

Først er der den første CD – Fårpoker. Stoned Sheep havde indspillet et demobånd før denne CD, med titlen Rockuld.

Fårpoker

Denne landeplage blev efterfulgt af endnu en… landeplage, Fårlygter der udkom i 1997:

Fårlygter

Server og database collation clasher i sikkerhedsindstillingerne for en bruger

Tænkte jeg lige ville dokumentere hvilke skridt der skal til, for at reproducere en lidt underlig fejl i SQL Server Management Studio 2008 (SSMS).

Setup:
Serveren er sat op med collation: SQL_Latin1_General_CP1_CI_AS
Databasen er oprettet med collation: Danish_Norwegian_CI_AS
Login er oprettet med default sprog: Engelsk
Database bruger er oprettet med collation: Danish_Norwegian_CI_AS

Følgende skridt vil reproducere fejlen:

1. Se properties for server-login:

2. Klik User Mapping

3. Klik Securables

4. Observer fejl:

Cannot resolve the collation conflict between “Danish_Norwegian_CI_AS” and “SQL_Latin1_General_CP1_CI_AS” in the UNION operation. (Microsoft SQL Server, Error: 468)

MS burde måske nok have været dette scenarie igennem, med en server sat op med én collation og databasen med en anden.

 

 

 

 

Competing for a free seat on Internals and Performance class by SQLSkills

I’ve been following Paul Randals blog for quite some time now, and it never ceases to amaze me the ideas and information he puts out there. Reading the latest blog post, where SQLSkills.com is offering a free seat on one of their master classes (http://www.sqlskills.com/Master1-Dallas-20110221.asp), was a new kind of amazement. The opportunity to actually be taught by a super skilled MVP like Paul Randal, is a jaw dropping thought. In Denmark we have a saying that, in Forrest Gump terms, would mean something like: “Life is a huge box of chocolate, with almost no chocolates in it”. Every time someone remotely interesting visits Denmark, the classes are booked almost before they have even been announced. So, good tutoring is really hard to come by around here, SQLSkills kind of tutoring even harder. This fact makes this opportunity even greater than it already is. In other words, this class would classify as a chocolate.
So, why am I to be selected as the winner of this particular competition? To start with the obvious and least important, the change of climate would be more than welcome. A jump from ~35F to ~50F ought to get put a smile on most faces.
To state the more professional aspects, I’d have to mention the impact on my daily routines this class would have, as the first thing. I’ve been waiting a long time for the right class to come my way, but going abroad has not been an option, because of the added costs for flight and accommodation stay. The total cost would be much lower, with the class being free.
Another aspect would be the opportunity for me to improve on the subjects that are taught in class. This would mean a giant skills boost for me. And as I share these areas of responsibility with my co-workers, I haven’t been able to develop or train, so the impact on my day to day work would be huge.
So if I, a professional developer from Denmark, were to be offered a free seat on a class like this, I’d be booking the flight the same minute my arms came down ( and that could take a while )

Did I mention that I once played the guitar in a band called Stoned Sheep 🙂

“I will prepare and some day my chance will come.” – Abraham Lincoln