FIX: Incorrect Text "There are no EFS keys" in Sqlstp.log for Error 6006 During Upgrade
Article ID: 299494 - View products that this article applies to.
This article was previously published under Q299494
BUG #: 354105 (SHILOH_BUGS)
When running an upgrade from SQL Server 7.0 to SQL Server 2000, you may receive a 6006 error in the Sqlstp.log file that indicates the following:
Files\MSSQLS~1\Msss80\STANDA~1\x86\BINN\osql.exe -S EG-ISDSQLQA-A01 -b -n -d master -o "D:\MSSQL7\install\upgrade.out" -i
08:55:26 Process Exit Code: (6006) There are no EFS keys defined for the user.
To resolve this problem, obtain the latest service pack for Microsoft SQL Server 2000. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/290211/EN-US/ )INF: How to Obtain the Latest SQL Server 2000 Service Pack
The text given for this error is incorrect. The correct text in Sqlstp.log should be "Server shut down by request." This error is part of the upgrade process and can safely be ignored. SQL Server may be shut down at times during the upgrade.
Microsoft has confirmed this to be a problem in SQL Server 2000. This problem was first corrected in Microsoft SQL Server 2000 Service Pack 2.
In Microsoft Windows NT, error 6006 maps to the message:
where as in SQL Server, error 6006 maps to the following message:
There are no EFS keys defined for the user.
Server shut down by request.