You receive a Project Data Service (PDS) error 9446 when you save to a Project Server 2003 database (885851)


The information in this article applies to:

  • Microsoft Office Project Server 2003
Important This article contains information about modifying the registry. Before you modify the registry, make sure to back it up and make sure that you understand how to restore the registry if a problem occurs. For information about how to back up, restore, and edit the registry, click the following article number to view the article in the Microsoft Knowledge Base:

256986 Description of the Microsoft Windows Registry

SYMPTOMS

When you save a project to Microsoft Office Project Server 2003, you may receive a Project Data Service (PDS) error 9446.

RESOLUTION

How to obtain the hotfix

This issue is fixed in the Microsoft Office Project Server 2003 post-Service Pack 1 Hotfix Package that is dated October 21, 2004. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

887799 Description of the Microsoft Office Project Server 2003 post-Service Pack 1 hotfix package: October 21, 2004


After you install this hotfix, follow the steps that are listed in the "More Information" section to enable the hotfix.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

MORE INFORMATION

To enable this hotfix on your Project Server 2003 server, follow these steps.

Important note Enable this hotfix only on a SQL Server with case-insensitive collation.
  1. Locate the folder that contains the Project Server 2003 Connection Information tool, and then double-click ConnInfo.exe.

    The ConnInfo.exe tool is located in the Drive:\Program Files\Microsoft Office Project Server 20031\Bin\1033 folder of the computer that is running Project Server 2003.

    To download the ConnInfo.exe tool, visit the following Microsoft Web site:

    http://www.microsoft.com/downloads/details.aspx?familyid=1d30b672-baa0-4030-b036-323b216d7264

  2. In the SQL Server text box, and at the end of the existing value in the text box, type ;SqlCaseInsensitive=true;.
  3. Click Save.
  4. Click OK when you receive the following error message:
    Your connection information has been successfully saved.
  5. Click Exit.
To disable this hotfix on your Project Server 2003 server, follow these steps:
  1. Locate the folder that contains the Project Server 2003 Connection Information tool, and then double-click ConnInfo.exe.
  2. Do not make any changes in the Project Server 2003 Connection Information tool.

    Note The ;SqlCaseInsensitive=true; parameter is removed from the SQL Server text box when you rerun the Project Server 2003 Connection Information tool.
  3. Click Save.
  4. Click OK when you receive the following error message:
    Your connection information has been successfully saved.
  5. Click Exit.
Modification Type:MajorLast Reviewed:4/7/2006
Keywords:kbQFE KBHotfixServer kberrmsg kbProjectServer2003PreSP2fix kbbug kbfix KB885851 kbAudITPRO
©2004 Microsoft Corporation. All rights reserved.