Project Server Install Issue

[Dan Triant]

OK, So I have SQL Server 2005 Beta on a 2003 SE server, IIS and everything
setup and Sharepoint running smooth. I have followed instructions to the best
that I can figure, and for some reason at the step WEBSPS.SQL the SETUPDB.CMD
errors. The setup starts and does run code for quite some time, and then
fails with error "Msg 156, Level 15, State 1, Server <servername>, Procedure
MSP_WEB_SP_QRY_GetTasksIDs, Line 24 Incorrect Syntax near the keyword
'index'. 1> 2> 3> Error encountered while running WEBSPS.SQL! Press any
key to contunue......"
I get this on both last months and this months install for Project 2003
server Eval DVD's and cant figure what is causing this to fail when all of
the others seem to run fine. I even tried to run the upgrade even though
this is a First install and get the same error.
Any help is greatfully appreciated, I am current just going to download the
60 day trial from MS, just thought I would see if anyone had some idea to
what would cause this. My only thought would be that the SQL server is a
BETA, however I could not find anything on this being an issue....

 

[Stuart Graham]

Dan,

Apps like Project Server which are so reliant on SQL Server will
probably need a service pack before they are 100% compliant with
SQL2k5. This Service pack isnt likely to surface until some months
after SQL2k5 goes RTM. I'd suggest installing SQL2000 which is fully
supported for Project Server.

 

[Dan Triant]

As much as I had wished this was not the case, it's along the lines of what I
expected to hear. I figured MS would have thought of this ahead of time, with
such reliances between the two, I figured SQL 2005 would have some additional
info on this. Oh well, I do appreciate the assistance, guess my Test env will
now have 2 SQL servers. I can't take down the 2005 as our programers have
been working in it since it's release, mostly to test new product function
idea's for when it's final release is available for purchase.

Thanks again.

 

[Gary L. Chefetz [MVP]]

Dan:

I don't think you should come to any conclusions using eval and/or beta
bits.

--


Gary L. Chefetz, MVP
"We wrote the books on Project Server"
http://www.msprojectexperts.com

For Project Server FAQs visit
http://www.projectserverexperts.com

For Project FAQs visit
http://www.mvps.org/project

 

[Dan Triant]

True, just difficult to sell the idea of having Project 2003 and SQL 2005
when you can't demo how they function together, and showing features to the
reason for having them.

Thanks.

 

[Vincent L.]

Hi Dan,
I'm trying the same and had the same error.
I solved it by modifying the SQL in the file WEBSPS.SQL.
It seems that SQL 2005 can't deal with a hint in the select clause without
adding the keyword 'WITH'
You have to insert this keyword into a couple of procedures in the
WEBSPS.SQL file:
e.g. the procedure: dbo.MSP_WEB_SP_QRY_GetTasksIDs

e.g.
Modify the line:
select WASSN_ID from MSP_WEB_ASSIGNMENTS WAT2
(index=I_ASSIGN_WRESID_TEAM_LEAD) ...

into:
select WASSN_ID from MSP_WEB_ASSIGNMENTS WAT2 WITH
(index=I_ASSIGN_WRESID_TEAM_LEAD) ...


You have to do this also in a couple of other procedures in the same file:
- dbo.MSP_WEB_SP_BUS_GetTasksAssignmentsForResIdwDelegation
- dbo.MSP_WEB_SP_QRY_GetSelectedTasksIDs

After these modifications the database install part of Project Server runs
smoothly.

 

[Gary L. Chefetz [MVP]]

Vincent:


Thanks for posting this.

 

[Dan Triant]

Good deal, Yeah I noticed that if I started to mod that file I would get
futher, I was just not sure what the outcome would be. It works 100% with SQL
2000.

I still have 2005 on the other side, so I will test this and get back..

Thanks tons.