FIX: Incorrect Text "There are no EFS keys" in Sqlstp.log for Error 6006 During Upgrade

Article translations Article translations
Article ID: 299494 - View products that this article applies to.
This article was previously published under Q299494
BUG #: 354105 (SHILOH_BUGS)
Expand all | Collapse all

SYMPTOMS

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:
08:54:58 \\ServerName\Program
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
"D:\MSSQL7\install\upgrade.sql" -E
08:55:26 Process Exit Code: (6006) There are no EFS keys defined for the user.

RESOLUTION

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:
290211 INF: How to Obtain the Latest SQL Server 2000 Service Pack

WORKAROUND

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.

STATUS

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.

MORE INFORMATION

In Microsoft Windows NT, error 6006 maps to the message:
There are no EFS keys defined for the user.
where as in SQL Server, error 6006 maps to the following message:
Server shut down by request.

Properties

Article ID: 299494 - Last Review: October 3, 2003 - Revision: 3.2
APPLIES TO
  • Microsoft SQL Server 2000 Standard Edition
Keywords: 
kbbug kbfix kbupgrade KB299494

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com