SQL 2005 Integration workaround with Project Server 2003 > Knowledge Base

Unanswered Active Topics

Forums Search

Forums > Knowledge Base Systems > MSSQL

Subject: SQL 2005 Integration workaround with Project Server 2003

Prev Next

You are not authorized to post a reply.

Author

Messages

jhogan

Posts:0

04/10/2007 3:23 PM

I tried to intall Microsoft Project Server 2003 and was unable to due to Error 25624. Here's the fix.

SYMPTOMS:

Error messages when you run the Setup program for Project Server 2003.

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" and "Installation ended prematurely"

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

"The installation ended prematurely because of an error."

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.

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

MORE INFORMATION

For more information about how to install Project Server 2003, see the Microsoft Office Project Server 2003 Installation Guide.

At the time of this writing, Microsoft SQL Server Analysis Services 2005 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 Analysis Services 2000 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 compatilibility 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: EXEC sp_dbcmptlevel DatabaseName, 80 Go

For more information, see: http://support.microsoft.com/default.aspx?scid=kb;en-us;917401&sd=rss&spid=2526

You are not authorized to post a reply.

Forums > Knowledge Base Systems > MSSQL > SQL 2005 Integration workaround with Project Server 2003

ActiveForums 3.7