Friday, September 26, 2014 #

Installing SQL 2005 SSRS on Windows 2008

First, don't ask me why. :( There was a need from vendor. Let's just leave it at that.

So run through your normal SQL 2005 install, the validation page throws up a warning "IIS not running". Since SSRS is a must on this machine, so let's Google Bing it. Following some results like this one: http://www.iis.net/learn/install/installing-iis-7/installing-iis-7-and-above-on-windows-server-2008-or-windows-server-2008-r2, run SQL 2005 install wizard again and got the same message. What the? Double check and everything works according to the blog.

After a short walk, I realized that "why would SQL 2005 know about IIS 7?" Now the focus is on searching to install IIS 6 on a Windows 2008 box. The trick was that "web server role" was needed for IIS 7, but IIS 6 requires an application server role install.

References here:
http://technet.microsoft.com/en-us/library/cc754024(v=ws.10).aspx https://www.microsoft.com/technet/prodtechnol/WindowsServer2003/Library/IIS/750d3137-462c-491d-b6c7-5f370d7f26cd.mspx?mfr=true

Posted On Friday, September 26, 2014 4:30 PM | Comments (0)

Windows 8 support of video format

OK, this is sad

The other day we thought it would be a good idea to watch some old family video. I brought out my Windows 8 "awesome" laptop. Subsequently I endured frustration beyond belief. The only formats I seemed to able to play was MP4 and MOV, and MP4 was played with my Zune software. I tried to play AVI and MPG, didn't work with Windows Media Player, didn't work with the Windows 8 Video player. Clicking on the "help" button brought me to a long page on Xbox music. After reading for a while, I was very confused as to how to add an Xbox player to my Windows 8.

The following days consist of me trying to find video converter. DVDVideoSoft Free Studio seemed pretty good, but the MOV and MP4 results had the same problem. Guess what my eventual solution is!

Apple QuickTime player

The positive that came out of this is that I found a free DVD converter in DVDVideoSoft Free Studio. Now I can convert the old DVD into playable files on portable devices.

It has been at least 10 years since I last played with Xvid and all those softwares. It was nice to make my brain hurt a little trying to understand this side of computer science.

Posted On Friday, September 26, 2014 2:28 PM | Comments (0)

Thursday, September 25, 2014 #

The importance of parameter ordering in SSRS Lookup LookupSet

When you use Lookup or LookupSet function in SSRS expression, make sure that the "destination dataset" is loaded before your "source dataset" starts the expression lookup

There is where it got me. I had one parameter for each set, and somehow put the one for destination set second. In that setup, none of my lookup returned anything. Once I switched the parameter order, everything works perfectly again

Posted On Thursday, September 25, 2014 3:20 PM | Comments (0)

Wednesday, September 24, 2014 #

Using SharePoint list connection in SSRS 2008

Here is a good article from Microsoft about this: http://msdn.microsoft.com/en-us/library/ee633650(v=sql.105).aspx

The gotcha was really knowing which site your list belong to, and don't follow some other posts that tell you to do "data source= blah blah blah". Just straight up URL at the site level.

Posted On Wednesday, September 24, 2014 3:04 PM | Comments (0)

SSRS subscription SQL Agent Job GUID

Can't believe I didn't have to use this until now. Bad bad automation design...

Thanks, steve_fromOZ. http://www.sqlservercentral.com/Forums/Topic254010-150-1.aspx

Posted On Wednesday, September 24, 2014 12:15 PM | Comments (0)

Copyright © Kevin Shyr

Design by Bartosz Brzezinski

Design by Phil Haack Based On A Design By Bartosz Brzezinski