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 a 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.
If you encounter any problems or have other thoughts, please reply to this post so we can share experiences.

——Kuntal…

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: