*Blows dust off APWoT* Silverlight. Reactive Extensions. Web Services. W00T.

Man. October 2008. That has to be a new record for me. You're welcome. So now to completely cheese-monkey out on a post, I'm going to go ahead and link to a different post! Woo hoo!

Anyway, I wrote a post over on my company's blog about using the new Reactive Extensions within Silverlight. Go ahead and head over there and check it out. You know you wanna.

~M.

SSRS 2008 Report Manager could not establish trust relationship for the SSL/TLS...

Ah, another SQL 2008 post. And not only that, but 2 in one week. That's like some sort of record for me. I must really have something to say for a change.

Anyway, yesterday I posted about WMI errors that I was recieving when trying to install SQL 2008. Today I hit another issue when I tried to get to the Reports folder in my SSRS 2008 instance.

I was trying to view http://[servername]/Reports, but I recieved the following error:

"The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel."

A link to the solution can be found here, but if you don't feel like leaving, simply follow these steps:

1) Open up the Reporting Server Configuration tool found under the SQL Server 2008 directory (Start->All Programs->Microsoft SQL Server 2008->Configuration Tools->Report Server Configuration).

2) Connect to your server / instance.

3) Click the "Report Manager URL" section. Under URLs: you will see 2 links, one to port 80, and the other to a SSL port.

4) Click "Advanced"

5) In the "Multiple SS: Identities for Report Manager" section, highlight the one item in there, and click "Remove"

6) Click "OK" and "Apply" all the way out, and you should be good to go!

Hope this helps!
~M.

Windows Management Instrumentation failed on SQL 2008 Installation

So here's the situation: I'm trying to install SQL Server 2008 on Windows Server 2005, with a pre-existing instance of SQL 2005. When I initialized the install, SQL 2008 threw an error over Windows Management Instrumentation (WMI), and the error message lead one to think that the WMI service was not installed / running.

A quick check of my services confirmed that WMI was in fact running, and restarting the service as well as restarting the entire server did not resolve my issues.

I had found a couple BAT scripts that claimed to fix the issue like:

%SYSTEMDRIVE%
CD %windir%\system32\wbem
Mofcomp.exe cimwin32.mof
Regsvr32 /s wbemupgd.dll
Regsvr32 /s wbemsvc.dll
wmiprvse /regserver

The line Mofcomp.exe cimwin32.mof actually threw an error (Error Number: 0x80041014, Facility: WMI), but the error number only turned up this post on the Microsoft Forums, which did not help my problem. In fact the wbemtest.exe itself threw a WMI error at me when I tried to connect to "root\cimv2"

In digging through the server, and playing with the MOF files / mofcomp, it looks to me like my repository was corrupted somehow, and completely deleting the direcory did not help (in fact I would suggest against it! ).

Finally I found the holy grail of scripts, which did in fact fix my problem. Simply copy the script below, paste it into a file on your server / machine, save it as a .bat file, and run it. You might want to step away from the computer for a while, because it might take a while.

And finally, the script:

net stop winmgmt /y

c:

cd %systemroot%\system32\wbem

if exist %systemroot%\system32\wbem\repository.old rmdir /s /q

repository.old

rename %systemroot%\system32\wbem\repository repository.old

regsvr32 /s %systemroot%\system32\scecli.dll

regsvr32 /s %systemroot%\system32\userenv.dll

mofcomp cimwin32.mof

mofcomp cimwin32.mfl

mofcomp rsop.mof

mofcomp rsop.mfl

for /f %%s in ('dir /b *.dll') do regsvr32 /s %%s

for /f %%s in ('dir /b *.mof') do mofcomp %%s

for /f %%s in ('dir /b *.mfl') do mofcomp %%s

-----------------------------------------------------------

%systemroot%\system32\wbem\winmgmt /clearadap

%systemroot%\system32\wbem\winmgmt /kill

%systemroot%\system32\wbem\winmgmt /unregserver

%systemroot%\system32\wbem\winmgmt /regserver

%systemroot%\system32\wbem\winmgmt /resyncperf

net stop winmgmt /y

if exist %systemroot\system32\wbem\repository.old rmdir /s /q

repository.old

rename %systemroot\system32\wbem\repository repository.old

regsvr32 -s %systemroot%\system32\scecli.dll

regsvr32 -s %systemroot%\system32\userenv.dll

mofcomp %systemroot%\system32\wbem\cimwin32.mof

mofcomp %systemroot%\system32\wbem\cimwin32.mfl

mofcomp %systemroot%\system32\wbem\rsop.mof

mofcomp %systemroot%\system32\wbem\rsop.mfl

for /f %%s in ('dir /b *.dll') do regsvr32 /s %%s

for /f %%s in ('dir /b *.mof') do mofcomp %%s

for /f %%s in ('dir /b *.mfl') do mofcomp %%s

net start winmgmt

%systemroot%\system32\wbem\wmiprvse /regserver




END OF SCRIPT DON'T COPY ANYMORE!!!!!!!!!!!!!!

I can't take credit for this script, I found it here but it was kind of painful digging it out of all of the other crap on the page......

Anyway, peace!
~M.

My ISP is a damn dirty Commie...

I mean I realize that I come nowhere close to 250gigs of traffic in a given month (especially now that Baby is here), but still:

http://www.pcmag.com/article2/0,2817,2329170,00.asp

Come on. Seriously. Bastards.

~M.

I have seen the Light!!

I have a horrible habit of reading web comics. It's been a guilty pleasure of mine since I made it to college and didn't have to rely on a crappy dial-up connection to trickle the internet to me.

Just this morning I was reading Three Panel Soul and beings the comic hadn't been updated since I last visited, I started reading the Artist's rant, and came across a link to a Swedish artist that the Three Panel Soul dude liked.

So following this path, I started digging through his website, I hit one section that had a CAPTHCA of sorts......a brilliant CAPTHCA if you ask me.

Now mind you, there's boobies involved in the page once you get through his little puzzle, but I thought it was absolutely BRILLIANT!!! I mean, I had more fun figuring out the puzzle, but it got me to thinking........

The problem with the Internet is....it's too nice, a little too easy. There really should be a test to be able to earn the right to add content to The Tubes. To post a video to YouTube, or a comment to a blog, you should have to pass some sort of quiz, just to prove that you've got the cognitive capacity of at least a head of lettuce.

Hhhhmm...I'm going to have to ponder this one a little more (and maybe after a little more coffee).

~M.

A quick post

I'm sure I'll start writing more once we get done house shopping / moving, but in the mean time....


Cyanide & Happiness @ Explosm.net

~M.

EPIC FAIL!!!

So.......wow........that link's completely pooched (post right below this)......crashes my browser every time I try and open it. So here's the direct link and hopefully that'll work......

Boooo....
~M.