Microsoft KB Archive/303104

= PRB: Unable to Save DTS Package to SQL Server When You Use Windows NT 4.0 French Localized Version =

Article ID: 303104

Article Last Modified on 11/14/2003

-

APPLIES TO


 * Microsoft SQL Server 2000 Standard Edition, when used with:
 * Microsoft Windows NT 4.0
 * Microsoft SQL Server 7.0 Service Pack 3, when used with:
 * Microsoft Windows NT 4.0

-



This article was previously published under Q303104



SYMPTOMS
When you use Microsoft Windows NT 4.0 Server French version or the Windows NT 4.0 Workstation French version as the operating system, the following error message may occur:

Source de l'erreur: Lot Microsoft Data Transformation Services (DTS) Description de l'erreur: Acces refuse.

The English translation of the error message is:

Source of Error: Data Transformation Services (DTS) Description of error: Access is denied

The error message occurs when:
 * You save a Data Transformation Services (DTS) package to a SQL Server (Local Package).

-or-


 * When you save a package as a structured storage file in SQL Server 2000 or in SQL Server 7.0 Service Pack 3 when you save the package as a file.



CAUSE
The following registry key is missing:

HKEY_LOCAL_MACHINE\Software\Microsoft\Cryptography\defaults\CheckInfo



WORKAROUND
To work around the problem, refer to the following Microsoft Knowledge Base article:

259484 INFO: CryptEncrypt and CryptDecrypt Functions Are Supported with the French Locale on Windows 2000

Note this text in the article:

&quot;To enable CryptEncrypt and CryptDecrypt on computers that are running Windows NT 4.0, Service Pack (SP) 6a, the following registry key needs to be created:

HKEY_LOCAL_MACHINE\Software\Microsoft\Cryptography\defaults\CheckInfo

A value named Mask should be created with a REG_DWORD value of 0xFF.&quot;



MORE INFORMATION
The error is in French and is returned by the operating system.

The error message occurs with both the French and the English version of SQL Server.

When you save a DTS package, the CryptEncyrpt API call is made to encrypt the Owner and User package passwords. The API call occurs even if no Owner or User package password is specified.

Additional query words: DTS encryption

Keywords: kbprb KB303104

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.