HOW TO: Umbraco 4.0 with Microsoft SQL Server 2000

Question

We have a server that is running Microsoft SQL Server 2000 and would like to setup Umbraco 4.0. I tried the web install, but it choked on the MS SQL 2005 Express install. So I next tried the manual installation of MS SQL 2005 Express, which choked also with an error indicating that there was incompatibility issue because we already have MS SQL Server 2000 installed.

I have searched and read multiple articles trying to find a way to do this. There is a good article that addresses this issue directly for Umbraco 3.x, but apparently the implemenation for 4.0 is different and the SQL files mentioned in that article are not even installed with 4.0.

Any advice on how to get Umbraco working on a server running MS SQL Server 2000 is greatly appreciated.

Answer 1

There is no Umbraco 4.4, the latest version is 4.01 so I'll assume you are talking about that. Since version 4 you can use the Vista DB engine, so take a look here:

http://v3.umbraco.org/documentation/books/install-umbraco-4-on-localhost---simplified

or

http://forum.umbraco.org/yaf_postst6986_How-to-install-v4-with-VistaDB.aspx

Answer 2

I do have umbraco running with sql2000 without any effort, however package-folks are creating sql-scripts targeting sql2005+, so I will install express 2005 or 2008 to handle the umbraco db. http://stackoverflow.com/questions/288393/sql-2000-and-sql-2008-express-side-by-side