Wednesday, July 02, 2008

SQL 2005 32 bit on Vista 64 bit

I've decided to upgrade my work system to Vista 64bit (mainly due to larger memory). As I go on installing stuff, i keep running into various issues which I'll try to post here.
SQL 2005 Developer Edition (32 bit).
First issue is with the compatibility check-list - namely IIS and ASP.Net

This KB article outlines which features need to be turned on Vista in order for Reporting Services to work.

This link describes how to fix ASP.Net by running following:
cscript %SystemDrive%\inetpub\AdminScripts\adsutil.vbs set w3svc/AppPools/Enable32bitAppOnWin64 1

No comments: