Error message when you run the SQL Server Import and Export Wizard in SQL Server 2005: "SQL Server Import and Export Wizard has encountered a problem and needs to close" (920809)

The information in this article applies to:

Microsoft SQL Server 2005 Standard Edition
Microsoft SQL Server 2005 Workgroup
Microsoft SQL Server 2005 Developer Edition
Microsoft SQL Server 2005 Enterprise Edition
Microsoft SQL Server 2005 Express Edition with Advanced Services

SYMPTOMS

Consider the following scenario. You install Microsoft SQL Server 2005 on a computer that has an Intel Pentium II processor. In SQL Server 2005, you run the SQL Server Import and Export Wizard. In this scenario, you receive the following error message:

SQL Server Import and Export Wizard has encountered a problem and needs to close. Sorry for the inconvenience.

When you click OK, you receive the following error message:

Unhandled exception at 0x2357c258 in DTSWizard.exe: 0xc000001d: Illegal Instruction.

CAUSE

This behavior occurs because the Pentium II processor is not supported by SQL Server 2005. The minimum CPU requirement for a SQL Server 2005 installation is a 600-megahertz (MHz) Pentium III-compatible processor.

During the SQL Server 2005 installation process, SQL Server 2005 determines whether the system meets the minimum software requirements and the minimum hardware requirements. Typically, you receive a warning on the System Configuration Check page of the SQL Server Installation Wizard if SQL Server 2005 finds any incompatibility. However, you do not receive a warning about the incompatible Pentium II processor, and the installation process continues. Therefore, you receive the error message that is mentioned in the "Symptoms" section when you run the SQL Server Import and Export Wizard.

RESOLUTION

To resolve this behavior, you must install SQL Server 2005 on a computer that has at least a 600-MHz Pentium III-compatible processor.

STATUS

This behavior is by design.

MORE INFORMATION

If you create a user dump file for this behavior, and then you use the .excr command to set the context to the exception event, you receive the following information in the user dump file:

0:020> .excr
eax=038a0694 ebx=0000000c ecx=00000000 edx=0000000c esi=05bc1ea4 edi=038a4014
eip=2357ba38 esp=0622fdcc ebp=0622fdd8 iopl=0 nv up ei pl zr na po nc
cs=001b ss=0023 ds=0023 es=0023 fs=003b gs=0000 efl=00010246
DTSPipeline!memcpy_amd+0x cf:
2357ba38 0faef8 sfence

Note The sfence assembly instruction is new in Pentium III processors. This assembly instruction is not recognized in Pentium II processors.

REFERENCES

For more information about the software requirements and the hardware requirements for SQL Server 2005, see the "Hardware and software requirements for installing SQL Server 2005" topic in SQL Server 2005 Books Online.

The third-party products that this article discusses are manufactured by companies that are independent of Microsoft. Microsoft makes no warranty, implied or otherwise, regarding the performance or reliability of these products.

Modification Type:	Major	Last Reviewed:	7/20/2006
Keywords:	kbsql2005setup kbprb kbsql2005engine kbExpertiseAdvanced KB920809 kbAudDeveloper kbAudITPRO