Hi,

I have a server running on Windows Server 2003 and SQL Server 2000 SP3a.

It runs 16 DTS packages scheduled to run once per minute via SQL Server
Agent. Periodically TDSRun will fail with the following message in a dialog
box.

The exception Illegal Instruction
An attempt was made to access an illegal instruction
(0xc000001d) occurred in the application at location 0x007d24b4

The execution of the job is blocked at that point. This has happened on a
number of DTS packages. All the packages on the server have a connection to
the local SQL Server and an SQL Task. All the packages operate on a linked
server in the SQL Task. There are several databases involved on the linked
server but each DTS package only accesses a single database. The linked
server runs NT 4 SP6a and SQL Server 7 SP3.

Any ideas about what may be causing this problem or any steps I can take to
try to diagnose the cause?

Regards

James Wilman

Hi James,

Thanks for your posting!

From your descriptions, I understood your scheduled DTS package will be
failed with the error message 'An attempt was made to access an illegal
instruction' randomly. If I have misunderstood your concern, please feel
free to point it out.

First of all, please understand that we may be unable to resolve your issue
without reviewing the memory dump file. If this is the case, then we will
need to refer you to Microsoft Customer Service and Support (CSS)s to
pursue this issue, as such in depth review is outside the scope of these
newsgroups.

For a complete list of Microsoft Customer Service and Support phone
numbers, please go to the following address on the World Wide Web:
<http://support.microsoft.com/directory/overview.asp>

If you are outside the US please see http://support.microsoft.com for
regional support phone numbers.

For now, I believe there might be two possible causes for this issue.

1. Please make sure you have upgraded to IE 6.0 in that SQL 7.0 machine,
please read the Knowledge Base article below, which described this scenario
detailedly

FIX: IE 5.0 Hinders SQL Server 7.0 Wizards and Tabbed Dialogs on Windows 95
or 98 Computers
http://support.microsoft.com/kb/225084

2. This illegal instruction suggests service control manager GUI (MMC)
error instead of SQL Server itself. How often will it occur? Will some
specific condition 'trigger' this error message out? Please reinstall SQL
Server Client Tools to see whether it will help.

Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!



Sincerely yours,

Michael Cheng
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===

This posting is provided "AS IS" with no warranties, and confers no rights.

Michael,

The illegal instruction occurs in dtsrun.exe which is fired from an SQL
Server Agent job. The dialog box containing the error has the title
dtsrun.exe.

MMC & enterprise manager are not usually running on the server at the time
that the error occurs.

I have set up Dr watson but no crash dump is generated which suggests that
dtsrun.exe is handling the exception that is generated and displaying the
message itself.

IE 6 is installled on the SQL Server 7 system. I can reinstall the SQL
Server client tools. If I do that do I need to reinstall Service Pack 3a?

Regards

James Wilman


"Michael Cheng [MSFT]" wrote:

Hi James,

Thanks for your prompt updates!

Yes, if you have reinstall SQL Server, you will have to reinstall that
service pack again. Note that keep you important data fully and securedly
backuped.

If condition permits, you may try perform this task via dtsrun.exe from
another machine instead of current one to see whether it will reproduce
this behavior.


Sincerely yours,

Michael Cheng
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===

This posting is provided "AS IS" with no warranties, and confers no rights.