Project server 2003 and SQL Server 2005 not a supported option !!

[Ian Wolstenholme]

Hi,

I have been trying to get Project Server 2003 installed using SQL Server
2005 since our company is planning to upgrade to SQL Server 2005 early next
year. However I have hit some issues with this.

I have seen Bill Raymonds workaround (http://blogs.lv0.net/mpatest/) but
this is not a supported fix and anyway, even if I apply the fix I then can't
get the Service Pack 1 installed !

In addition Microsoft tell me that Project Server 2003 and SQL Server 2005
is not a supported configuration !!

Is anyone else out there considering upgrading their SQL boxes to SQL 2005
and if so I'd be interested to know who else has this problem and whether
anyone has been able to fix it.

Of course I am hoping that Microsoft will come up with a supported solution
for this before we go live in Feb with SQL 2005 - otherwise we are going to
have a BIG problem. I am sure I can't be the only person in the world that
is having to resolve this !

Appreciate any input from the gurus out there...

Thanks

Ian

 

[Mike Glen]

Hi Ian,

Try posting on the server newsgroup as this one is closing down. Please
see FAQ Item: 24. Project Newsgroups. FAQs, companion products and other
useful Project information can be seen at this web address:
http://project.mvps.org/faqs.htm .

Mike Glen
Project MVP

 

[Gary L. Chefetz [MVP]]

Ian:

All you have to do is apply the same fix to the SQL script that ships with
the Service Pack.

 

[William Raymond]

Hi Ian,

As Gary points out, you just need to follow the same process I listed for
SP1 to work. However, please note that my BLOG also points out that this
configuration is not support. Microsoft has not yet released a formal
statement regarding SQL Server 2005 support. Although I could be very
wrong, do not plan on having a production-available version by end of year.

If you want to test it, you can follow the blog posting. However, you will
notice that the OLAP cube cannot build with SQL Server AS 2005. I am
working on some issues with that and might post something soon on how to
make that work for a test environment, but not sure if my work-arounds cna
be addressed. More on that later...

-Bill