SQL2005 EE and Project Server2003

[ChickBladder]

We are having difficulties installing Project Server2003 EE. We are getting error 25624 failed to execute SQL string - 2147217900 sp_grantdbaccess MS Project Sever User; note that we are running MSCS as well w/ a VMware underlay. Any help would be MOST appreciated.

 

[ChickBladder]

OK...I found the issue on MSKB:

Article ID
:
917401

Last Review
:
May 9, 2006

Revision
:
1.3


SYMPTOMS
Consider the following scenario. You run the Setup program to install Microsoft Office Project Server 2003. On the Enter database server information page of the Setup program, you specify a computer that is running Microsoft SQL Server 2005 as the database server on which to create a new database to use with Project Server 2003. However, you receive the following error message:

Error 25624. Failed to execute SQL String. (-2147217900 sp_addlogin ‘MSProjectServerUser’, ‘password’, ‘ProjectServer’ )

After you receive the first error message, you receive the following error message:

The installation ended prematurely because of an error.


Back to the top


CAUSE
SQL Server 2005 was released after Project Server 2003. This issue occurs because the SQL scripts that are included with Project Server 2003 are incompatible with SQL Server 2005. The SQL scripts are used to create the database that is used by Project Server 2003. By default, the name of the database is ProjectServer.


Back to the top


WORKAROUND
To work around this issue, follow these steps:

1.
Before you install Project Server 2003, manually create the database on the computer that is running SQL Server 2005.

2.
Set the compatibility level of the database to the SQL Server 2000 (80) setting.

3.
Run the Setup program to install Project Server 2003.

4.
Connect to database by using the Connect to another existing database option on the Enter database server information page of the Setup program.


Create and configure the database that is used by Project Server 2003 on a computer that is running SQL Server 2005. To do this, follow these steps:

1.
Create the database.

a.
Start SQL Server Management Studio.

b.
In the Connect to Server dialog box, click Database Engine in the Server type box, and then click Connect.

c.
Right-click Databases, and then click New Database.

d.
In the New Database dialog box, type the name of the database in the Database name box. For example, type ProjectServer, and then click OK.

e.
In the left pane of SQL Server Management Studio, expand Databases, right-click the database, and then click Properties.

f.
Under Select a page, click Options.

g.
In the Compatibility level box, click SQL Server 2000 (80), and then click OK.

h.
Exit SQL Server Management Studio.



2.
Run the Setupdb.cmd script. The Setupdb.cmd script is located in the \Support\Database folder of the Project Server 2003 CD. To use the Setupdb.cmd script, follow these steps:

a.
Copy the Database folder from the Project Server 2003 CD to a location on the computer that is running SQL Server 2005.

b.
Run the script. The Setupdb.cmd script uses the following syntax:

Setupdb.cmd SQLServerName DatabaseName UserName Password NOPAUSE


The Setupdb.cmd script creates the tables and roles that are required for Project Server 2003. For more information about how to use the Setupdb.cmd script, visit the following Microsoft Web site:

http://office.microsoft.com/en-ca/assistance/HA011654021033.aspx

(

http://office.microsoft.com/en-ca/assistance/HA011654021033.aspx)

Back to the top


MORE INFORMATION
For more information about how to install Project Server 2003, see the Microsoft Office Project Server 2003 Installation Guide. To obtain the Microsoft Office Project Server 2003 Installation Guide, visit the following Microsoft Web site:

http://www.microsoft.com/downloads/...478-4AC3-A230-C4F2D82096C1&displaylang=en

(

http://www.microsoft.com/downloads/...78-4AC3-A230-C4F2D82096C1&displaylang=en)

At the time of this writing, Microsoft SQL Server 2005 Analysis Services is incompatible with the Portfolio Analysis feature of Project Server 2003. However, if the ProjectServer database is hosted on a computer that is running SQL Server 2005, you can use Microsoft SQL Server 2000 Analysis Services in your deployment of Project Server 2003.

If you have an existing deployment of Project Server 2003, follow these steps:

1.
Restore the ProjectServer database to a SQL Server 2005 database.

2.
Set the compatibility level of the database.

3.
Use the Conninfo.exe tool to specify the connection information. The Conninfo.exe tool is located in the Project Server folder.


The following are examples of scripts that you can use to verify and to change the compatibility level of the database. To verify the compatibility level of the database, use the following script:

EXEC sp_dbcmptlevel DatabaseName
Go
To change the compatibility level of the database, use the following script: