Microsoft Project Server 2003 with SQL Server 2005
Sep 11 2008 - By George Webster
Today after much headache trying to install Microsoft Project Server 2003 with SQL Server 2005 i sit victorious... though not without the lumps to prove my struggle.
Sadly it seems that Microsoft does not write their SQL Server code with backwards compatibility in mind.
While Project Server 2003 is performing the long and tedious task of building your Project Database it suddenly grinds to a screeching halt with the following:
"Error 25624. Failed to execute SQL String" and "Installation ended prematurely"
It appears will building out the Tables they are adding indexing omitting the "with" expression. This was allowed in 2000 but since 2005 of course they have changed their syntax!
So you, or i as i was had two options one:
Edit the .sql file used to build out the database, add the "with" expressions add noted here.
Or two:
Create my project Database by hand using the SQL Management Studio and change the compatibility to SQL 2000 and run the manual DB builder as noted here
I tried both and seem to prefer the latter of the two, but i think both would work just fine.
I ran into other headaches dealing with the SQL Server Logins for the Project Server, but I think those were merely conflicts with previous installation attempts (i had quite a few!!)
And now all is well with the cosmos....