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


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.


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


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


Article ID: 299494 - Last Review: October 3, 2003 - Revision: 3.2
  • Microsoft SQL Server 2000 Standard Edition
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