Microsoft KB Archive/929584

Knowledge Base

Error message when you try to set up Project Portfolio Server 2007: "Error: -2147217900: failed to execute SQL string"

Article ID: 929584

Article Last Modified on 12/27/2007

---

APPLIES TO

• Microsoft Office Project Portfolio Server 2007

---

SYMPTOMS

Consider the following scenario. You try to set up Microsoft Office Project Portfolio Server 2007 by using Microsoft SQL Server 2005. SQL Server 2005 is configured to use case-sensitive collation. In this scenario, the setup process fails. And, you receive an error message that resembles the following:

Error: -2147217900: failed to execute SQL string, error detail: Must declare the scalar variable "@Value"., SQL key: DB_Structure_PPSData_Script_Integrated SQL string: IF NOT EXISTS (SELECT * FROM sys.objects where object_id = OBJECT_ID(N'[dbo].[split]') AND type in (N'FN', N'IF', N'TF', N'FS', N'FT'))BEGIN…

CAUSE

This issue occurs because Project Portfolio Server 2007 is not supported on an installation of SQL Server 2005 that uses case-sensitive collation.

RESOLUTION

To resolve this issue, use one of the following methods:

• Install Project Portfolio Server 2007 SP1.
• On the computer that is running SQL Server 2005, configure the server collation settings to use case-insensitive collation.
• Remove SQL Server 2005. Then, reinstall SQL Server 2005 so that it uses case-insensitive collation. The server collation settings are configured when SQL Server 2005 is installed.

MORE INFORMATION

For information about how to install SQL Server 2005 so that it uses case-insensitive collation, refer to the SQL Server 2005 product documentation.

For information about how to reconfigure the server collation settings, visit the following Microsoft Web site:

http://msdn2.microsoft.com/en-us/library/ms179254.aspx

To check the server collation settings on a computer that is running SQL Server 2005, follow these steps:

1. Start Microsoft SQL Server Management Studio.
2. In the Connect to Server dialog box, select Database Engine in the Server type list.
3. Enter the server name and the authentication method, and then click Connect.
4. In the Object Explorer pane, right-click the server name, and then click Properties.
5. Under Select a Page, make sure that General is selected.
6. In the Server Collation row, you see a string that resembles the following:

   SQL_Latin1_General_CP1_CI_AS

   If the string contains "_CI", the computer that is running SQL Server has been configured to use case-insensitive collation. If the string contains "_CS", the computer that is running SQL Server has been configured to use case-sensitive collation.

Additional query words: PPS2007

Keywords: kberrmsg kbtshoot kbexpertiseinter kbprb KB929584

---

Send feedback to Microsoft

© Microsoft Corporation. All rights reserved.