MS Project Server with SQL 2005 error

[Dharmesh]

Hi All,

I was hoping that you maybe able to assist me. I am having a problem
installing MS Project Server with SQL 2005.

The environment that I am working on is Windows Server 2003 SP1, I have
installed SQL Server 2005 Enterprise Edition and Widows SharePoint Services.
During the installation of MS Project Server 2003 after all the information
has been added and the install has began, the following error message appears:

Error 25624. Failed to execute SQL string. (-2147217900 /* Query
#10011 */
CREATE PROCEDURE dbo.MSP_WEB_SP_QRY_GetTasksIDs
@p0 INT
AS

Select
WA.WASSN_IN,
WA.WRES_IN_MGR,
WA>WPROJ_ID, oo WP.PROJ_NAME, oo WP.WPROJ_TYPE,…

This install stops halfway through and does not continue. I was wondering
if you have come across this before so if you could point me in the right
direction to resolve this issue?

Best Regards

 

[Gary L. Chefetz [MVP]]

Dharmesh:

See the following article on Bill Raymond's blog site:

http://blogs.lv0.net/mpatest