agony of installing management studio for sql server 2008.

I had to connect remotely to an SQL server 2008 installation. Hence the story begins….

download the call backstreet boys

Chapter 1 – Revelations

I decided that i needed sql server management studio for doint that. Well i had the management studio for SQL server 2005 on my local machine, hence i tried using that to connect… valla it never works… Microsoft afterall hasn’t heard of the term backward compatibility.

Chapter 2 – Exodus to the Internet

Well so then like every other jack on earth, I go to google search to see where i can download the management studio from. My search takes me to the microsoft website (being considered for a nobel prize for that one).

The microsoft website tells me that the management studio comes only bundled with the express edition of SQL 2K8. So i go to download that……….. 97% ……. 98%….. 99%……

chapter 3 – Lamentation

After i start the installer ( on a windows 2003 server machine) they tell me i need to have the .net framework installed. Then i run back to google and repeat the entire Chapter 2 this time i call it with a new argument chapter2(”.net framework”). And i install that.

Chapter 4- Looong way to go

Well id installed the .net framework so i decided im all good to go, Now is restart my sql 2K8 installer and it tells me that the windows installer needs to be upgraded. So i call chapter2(”windows installer 3.5″) and install it…..

Chapter 5- Do u think this is the end??

Now i had the .net framework and the windows installer update installed, so i think Im really really good to go, and i launch the installer again…. This time after it takes me through 5 screens wherein microsoft is doing a log of complicated earth moving calculations at the backend, i get a compatibility failed error. reason: I need to install Windows power shell (WTF). So its again chapter2(”power shell”).

Chapter 6- I ain’t dead yet….

No I have .Net framework, windows installer update and “power shell” (whatever that is) installed. The i relaunch the application (15minutes ago). Its still……. installing a GODDAMN CLIENT TO CONNECT TO AN SQL DATABASE. Id rather have used the 4lines of JAVA code id written 2 years back.

If you enjoyed this post, make sure you subscribe to my RSS feed!