Hi BobT,
this is the MPA article from Bill Raymond, one of the MVP's. I hope this
helps:
Running Project Server 2003 with SQL Server 2005 - Bill Raymond, Microsoft
Office Project MVP, Pcubed
Warning: This post assumes you know SQL commands and are looking to test
Project Server 2003 running in SQL Server 2005. This is not yet supported by
Microsoft, so I do not recommend you perform these actions in a production
environment.
So, you might have learned that the long-awaited SQL Server 2005 product has
been released. If you own a copy (or are patiently awaiting the DVD's
arrival), you no doubt are interested in using SQL Server 2005 as a testbed
for Project Server 2003. Although it is not supported and MS Project does not
set up properly with it, you can indeed get it running. Now, I've been
testing for only two days now, but it seems pretty stable. I have not yet
tried creating an OLAP cube or installing the demo database.
Here are the steps I followed. You will find some good tips on the SQL
statements that need to be edited on the Microsoft Newsgroups, but these are
the definitive steps to getting Project Server set up and configured. As
always, make sure the database server, SharePoint, etc. are already installed
and configured (so far SharePoint seems to work fine with SQL Server 2005,
but again, I haven't done much testing on that).
Rather than running Project Server setup, copy the following folder to your
hard drive from the Project Server CD: Support\Database.
Using Notepad, open the file called WEBSPS.SQL. Change the following line
numbers (CTRL-G) will get you to the appropriate line number. Add the text in
bold.
Line 8781: select WASSN_ID from MSP_WEB_ASSIGNMENTS WAT2 WITH (index...
Line 19456: select WASSN_ID from MSP_WEB_ASSIGNMENTS WA WITH (index ...
Line 26315: select WASSN_ID from MSP_WEB_ASSIGNMENTS WAT2 WITH (index...
Save the file and go to a command prompt. Go to the DATABASE folder you
copied earlier that contains the file you just edited. We are going to create
a new Project Server database instead of having Project Server setup create
it. Type the following command (this will take awhile). Replace "LOCALHOST"
with the SQL Server name. Replace "sapassword" with the password for the SQL
Server administrator.
E:\Programs\Project Server 2003\SUPPORT\DATABASE FOR SQL 2005>SETUPDB.CMD
LOCALHOST ProjectServer sa sapassword
Connect to the SQL Enterprise Manager (or the SQL Server Management Studio,
as it is now called). If they do not exist, create two SQL Server Security
Login accounts. If the users were created, edit the accounts and make the
same changes as listed below:
MSProjectServerUser - Type a password you will remember; Set the default
database to "ProjectServer"; User Mapping = ProjectServer,
MSProjectServerRole.
MSProjectUser - Type a password you will remember; Set the default database
to "ProjectServer"; User Mapping = ProjectServer, MSProjectRole.
Run Project Server setup and follow the appropriate steps, selecting the
option to connect to an existing database.
Once setup is complete, you should be able to access Project Server.
