• Personal Accounts and Peripeteia
  • Opinions and Observations
  • Philosophical Thoughts
  • Products and Services
  • Learning Curve
  • Found on the Web
  • Strange Ideas
  • Travels
  • Food
  • Drinks
  • Books
  • Music
  • Movies and TV
  • Gullible Info
  • Quotes
  • On the News
  • On the Post

Installing SQL Server 2005 on Windows Vista

Since this note may be of some interest to people I know and it's conclusions were a surprise to all my co-workers (including software developers) and most friends (excluding Acid, a guru), I decided to let you know how "fabulous" Microsoft is and their mothers.

As some of you are aware, I have recently purchased a Dell laptop as an entertainment, learning and professional aid. It came with pre-loaded Microsoft Vista Home Premium.

The software that I need for work requires SQL Server 2005 installed. I have obtained the installation pack and I have attempted to install it on Wednesday.

The installation was stopped, as I only had SP1, while in order to run SQL Server 2005 on Vista one needs SP2.

I have then obtained SP2 installation add on and throughout Thursday I tried to get all components installed. I have failed miserably and I couldn't figure out why. My IIS was enabled, the .NET components as well. The installation was going on as normal and then, all of sudden, I was getting an error message. Not very nice at all.

I went online trying to figure out why on Earth I can't anything to work?! Today I came across two very interesting articles in the web. One was found on IIS website:
Problems installing SQL Server 2005 on Vista and IIS7

There are several required IIS components for SQL Server to install properly on Vista (...). The following components are all required in order for SQL Server 2005 to install properly:
Component Folder
Static Content Common HTTP Features
Default Document Common HTTP Features
HTTP Redirection Common HTTP Features
Directory Browsing Common HTTP Features
ASP.Net Application Development
ISAPI Extension Application Development
ISAPI Filters Application Development
Windows Authentication Security
IIS Metabase Management Tools
IIS 6 WMI Management Tools

Interestingly enough, only this note made me aware that Windows Authentication module was not available in my IIS feature! Why?!

And there came the answer:
How to install SQL Server 2005 Reporting Services on a Windows Vista-based computer

Prerequisites
You have a computer that is running one of the following editions of Windows Vista:
• Windows Vista Business
• Windows Vista Enterprise
• Windows Vista Ultimate

Apparently, Windows Vista Home and Home Premium have been robbed of Windows Authentication module and there is no way around it but to upgrade to one of above editions of Vista. LOVELY!

Since, of course, I couldn't believe there is no workaround, I called my guru, Acid, and asked if he had come across this issue. He had. He offered me a solution - a hacked Vista Ultimate.

Tempting, I know, but I chose the legal way and I bought an upgrade - I got a student discount so it wasn't all that bad, but hear my words:

IF YOU HAVE TO VISTA, DO IT ULTIMATELY OR SUFFER!

Till later,
Your secret geek
JJ

Comments

Post new comment

The content of this field is kept private and will not be shown publicly.

Click here to help me buy Latte!

Also in this section:

Mutate your Keyring

I have been always fascinated by all the stuff that you can carry with you on the keyring. While my own keyring is nothing more but a threaded shackle that my dad gave me (he's a sailing instructor) with a bunch of keys on it. I like the simplicity of this solution, and the fact that the shackle adds weight and changes the sound that the keys make making it easier to find them and harder to forget.

Still, there are a few keyring additions that I would like to have - but probably one at the time:

External HDD dilemma - a follow-up

I wrote recently about my external HDD dillema: capacity vs portability. This week I noticed that a new Western Digital HDD has appeared on Pixmania.com, one of my favourite online stores. It's a MyPassport Essential edition with 1TB capacity.

WD MyBook Essential 1TB first impressions and the reasons why CDs and DVDs suck.

It finally arrived, day earlier than expected, my new external HDD.

First of all I was surprised how light it actually felt. Sure one kilo doesn't seem like much, but it was just simply lighter than I imagined. It was also a bit smaller than I imagined and above all SLEEEEEEK!!!! :> I was very happy to unpack it and set it on my desk.

Decluttering Efforts - Capacity VS Portability in external HDD dilemma.

Since I decided to de-clutter my apartment and my life I have soon found myself staring at piles and piles of CD's and DVD's that I had stashed in a nice box beside the TV and in columns on my desk. I have over 100 CDs and about 25 DVD's worth of backups and archives, never mind all the other stuff like movies and music. I also had a look at all the magazines that I want to have handy for reference (majority are Computer Arts and Computer Arts Projects)and piles of documents.

This is a rather scary view for someone who is aiming to be able to pack-and-go when relocating to another country. While there are a few bulky items that might make it difficult, it's the little bits and pieces that would be my demise right now; the disks and magazines are the very things that should be easy to get rid of.

Evernote changed my life - save changes?

I was pointed to Evernote by various blogs here and there. I have managed to somehow ignore it for a while, but not any more. I have signed up and downloaded the Evernote for Windows and Evernote Firefox plugin.

My life is forever changed.

The Church on Sunday

I went to the Church this Sunday.

No, really, I did. It was not a church, it was The Church of the only type you could find me in, a pub/club/restaurant in the city centre.

Another reason to regret not having a car

I don't have a car.

I don't even have a driving licence.

I have, however, extensive experience in changing tires and cursing at the SatNav. After the car trip to Nice and back I thought I will never desire owning a SatNav because of the one E. had in the car, nicknamed Amber (for being Cutthroat Bitch).

Elephant's foot umbrella stand

Few months ago I was researching various games and found a parlour game called "Elephant's foot umbrella stand". It is a funny game, similar to one we used to play as kids, where each player adds a word or a phrase to an ever expanding sentence that then has to be repeated by the next player before he adds in a new word or phrase. Click on the link above to read more about the rules on Wikipedia.

The Truth About Smart

I enjoy good advertising.

Ultralase

The treatment I got at Ultralase was much better than the way they have treated me at Optical Express.

Greatly Unimpressed with Optical Express

I was only late 10 minutes, I swear.

Chuffed to bits

My new webcam and my new Genius tablet arrived today.

The webcam is ok, pretty cool tiny Logitech thingy.

The tablet is... OH MY GOD AT LAST I HAVE MY OWN GRAPHICS TABLET I AM SO CHUFFED!!!!

Vibram FiveFingers

My iGoogle page is an endless source of information and daily joy.

Laura Mercier's Chocolate Truffle

Upgrading Windows Vista Home Premium to Windows Vista Business.

Dear Friends and Family.

If you're reading this, I'm already in jail for dropping a bomb on Microsoft offices in Dublin.

Installing SQL Server 2005 on Windows Vista

Since this note may be of some interest to people I know and it's conclusions were a surprise to all my co-workers (including software developers) and most friends (excluding Acid, a guru), I decided

Activity Stream

  • January 12, 2012 - 9:23pm

  • Twitter JJCelery tweeted "My memory is like Cadbury Creme Eggs. Here today, GOOgle tomorrow." 9:23pm#
  • January 8, 2012 - 12:11pm

  • Twitter JJCelery tweeted "I was going to say everything was back to normal, but let's be honest: I have long forgotten what "normal" is." 12:11pm#
  • Twitter JJCelery tweeted "@Anonidae thank god I live on the third floor, even if I have to climb all of the stairs - rain doesn't worry me anymore :) p.s. I'm back ;)" 12:09pm#
  • January 5, 2012 - 11:37pm

  • Twitter JJCelery tweeted "@TetertGonosz soon I guess.... demand is building ;)" 11:37pm#
  • Twitter JJCelery tweeted "@Anonidae flooding?" 11:36pm#