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

The information in this article applies to:

Microsoft SQL Server 2000 (all editions), when used with:
- the operating system: Microsoft Windows NT 4.0
Microsoft SQL Server 7.0 Service Pack 3, when used with:
- the operating system: 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:

"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."

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.

Modification Type:	Major	Last Reviewed:	11/14/2003
Keywords:	kbprb KB303104