Why you can’t install Microsoft SQL Server 2005

If you see “SQL Server Database Services” grayed out, do not proceed with the installation. There’s some good reasons why it is grayed out. I am running Windows Vista Business Edition and am trying to install Microsoft SQL Server 2005 Enterprise Edition.

Can’t install Enterprise Edition in non-server version of Windows

The first problem is due to the fact that you cannot install Enterprise Edition into a non-server Windows operating system as stated here. That means to say that Enterprise Edition can only be installed in Windows 2000, Windows 2003 and Windows 2008. If you are using any other operating system, it is likely you are looking for Microsoft SQL Server 2005 Developer Edition or Standard Edition.

Required components of IIS 7 not fully installed

The second problem that I face is SQL Server 2005 complaining that I do not have IIS installed when I already done that. This is because you require the following components installed (their folders and in brackets):

  • 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)

I highlighted the requirements in red for your convenience:

Required IIS components for Microsoft SQL Server 2005
Required IIS components for Microsoft SQL Server 2005

Further information of required components can be found here.

Now after you install Microsoft SQL Server 2005 Whatever Edition, make sure you run Windows Update or download any Service Pack that they offer. This would ensure compatibility to your operating system. I hope that helps. This problem annoyed me whole day.

How to get json_decode or Services_JSON to return associative arrays

json_decode takes a JSON (JavaScript Object Notation) encoded string and converts it into a PHP variable. (More information on PHP documentation.)

[code lang=”php”][/code]

The above code would result in the following:

[code lang=”php”]object(stdClass)#1 (5) {
[“a”] => int(1)
[“b”] => int(2)
[“c”] => int(3)
[“d”] => int(4)
[“e”] => int(5)
}

array(5) {
[“a”] => int(1)
[“b”] => int(2)
[“c”] => int(3)
[“d”] => int(4)
[“e”] => int(5)
}
[/code]

When TRUE, returned objects will be converted into associative arrays. PHP’s associative arrays are amongst the easiest to use so i generally prefer an array to be returned.

When working on older PHP configurations such as in PHP 5.1, json_decode is not available. I use Michal Migurski’s Service_JSON. You can get the source code here.

The following does a json decode using the Services_JSON class.

[code lang=”php”]decode($json_text);
?>[/code]

If you use Services_JSON() instead, you are returned with StdClass. Using new Services_JSON (SERVICES_JSON_LOOSE_TYPE) returns you an array instead.

…And it will cost you millions

This is a rather funny complaint. Sure I agree that PHP hasn’t exactly been that great an opensource example, but this complaint is just ridiculous. Love the part when he/she says “The time is coming when a law suit beckons because as sure as eggs is eggs, a lot of your users will grow tired of paying out the thousands of dollars you cost them with every new php release, (theres a growing band who are already tired of it) and will sue. And they will win. And it will cost you millions.”

The contempt you show php programmers and website owners amazes me.

You change usages and drop tags like you are the only users of php. You create shedloads of work when you do that. One can forget developing anything if using php as one spends too much time reprogramming existing items to keep up with your constant changes.

Can you kindly ask all the idiots that engineer php if they would be willing to do that work for free or if they will pay for programmers to do it in compensation for their utter stupidity and arrogance and the contempt they show to their users?

Why cant you make every release backwardly compatible?

The time is coming when a law suit beckons because as sure as eggs is eggs, a lot of your users will grow tired of paying out the thousands of dollars you cost them with every new php release, (theres a growing band who are already tired of it) and will sue. And they will win. And it will cost you millions.

Kindest
Adie Close

[via PHP]

That’s terrible attitude. Anyway, the problem of upgrading server software has always exist. People scream when there is a lack of backward compatibility. And new users scream that the language is not lean enough. You can’t serve both sides.

MOBTV not compatible with my computer

I was testing things out on MOBTV recently and my computer is apparently not compatible. It claims that I have an older version of Windows Media Player.

We have detected an older version of Windows Media Player on your computer which might not be compatible with MOBTV services.

Please click on the link to upgrade it to the latest version of Windows Media Player.

Please click next to proceed to the next check after you have completed the upgrade.

I’m pretty sure I have the latest version – Windows Media Player 11. It came pre-installed with Windows Vista. These are the things that turn people away.

And I hate to see that uppercase the word MOBTV.