Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 929584 - Last Review: September 18, 2011 - Revision: 4.0
Error message when you try to set up Project Portfolio Server 2007: "Error: -2147217900: failed to execute SQL string"
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…
This issue occurs
because Project Portfolio Server
2007 is not supported on an installation of SQL Server 2005 that
uses case-sensitive
collation.
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.
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:
To check the server collation settings on a computer that is
running SQL Server 2005, follow these steps:
- Start
Microsoft SQL Server Management Studio.
- In the Connect to Server dialog box,
select Database Engine in the Server type
list.
- Enter the server name and the authentication method, and then
click Connect.
- In the Object Explorer pane, right-click the server name,
and then click Properties.
- Under Select a Page,
make sure that General is selected.
- 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.
APPLIES TO
- Microsoft Office Project Portfolio Server 2007
| kberrmsg kbtshoot kbexpertiseinter kbprb KB929584 |
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate