We have been running project server on SQL server 2000 for a while now and ever since Yukon/SQL Server 2005 arrives and I hope many of you already has the DVD or waiting to get one so here are the steps to install Project server 2003 on SQL Server 2005. This is not recommended by Microsoft so you can do it for testing purpose only.
- 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.
Questions and feedback is welcome.