Avatar of awsnoc
awsnoc asked on

SQL 2000 - sqlagent.exe bad image

Hi there,

I am currently getting an pop-up window every time I restart the SQL server Agent for SQL server 2000. The pop-up image says

"the application or dll c:\program files\microsoft sql server\mssql\binn\sqlatxss.dll is not a valid windows image. Please check against your installation disk". I tired looking online for answers and I was not able to find any solution for this problem. The weird part is, that once I hit OK on the pop-up window, the error goes away and the agent starts without a problem. The agent runs jobs just fine and to me works properly. The SQL server currently runs on Windows 2000 server with all the latest patches and SQL Server SP4.

The system also has Symantec Anti-virus protection, I dont know but could this be a spyware. I tired copying that dll from another working SQL server with the same version and I started to get different errors so I didnt mess with it and replaced it with the old dll.

Appericiate if someone can help
Microsoft SQL ServerSQL

Avatar of undefined
Last Comment
awsnoc

8/22/2022 - Mon
Paulo Pimenta

The problem may be related to the registration of that specific DLL, during installation or upgrade, probably caused by the antivirus, for some reason.

I'd suggest you disabling the virus during installations, upgrades or updates, for known software, of course.
;)

It is not a critical problem, since the service will run fine - as expected. What you could do is try to "re-register" the DLL in question:

1) Start > Run
2) regsvr32 "c:\program files\microsoft sql server\mssql\binn\sqlatxss.dll"

For more details on registering DLLs, just in case that problem happens again: http://www.ss64.com/nt/regsvr32.html

Hope this helps you on your problem.

Cheers,
PP/LMS
ASKER
awsnoc

I tired that before and it wont register. It says


"C:\Program Files\Microsoft SQL Server\MSSQL\Binn\sqlatxss.dll" is not an executable file and no registration helper is registered for this file type
Paulo Pimenta

That is indeed not normal.
I'd do the following - if you haven't yet:
1. Scan that specific DLL for virus.
2. Take one step back, in order to, hopefully, take two forward: You mentioned that copying the DLL from another server would produce athor errors. Evaluating those errors may lead you on the right direction. Like I said: "One step back, two steps forward".

Cheers,
PP/LMS
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
ASKER
awsnoc

Sorry but I didnt understand by what you meant as one step back and 2 steps forward. Could you ellobrate. Thanks
Paulo Pimenta

>>> I tired copying that dll from another working SQL server with the same version and I started to get different errors

Place the DLL from other server (one step back, i.e. to "ruin" things a bit) and evaluate the errors. Perhaps they can help us go in the right direction (two steps forward).
;)

What were the errors? Perhaps these errors can help us understand what SQL Server Agent or Windows 2000 Server are trying to tell you.
ASKER
awsnoc

Oh gotcha, I will do that and give you feedback soon. Thanks
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
ASKER
awsnoc

well I thot the server that was giving the error which installed with SP4. But before copying the files I decided to check to be sure and I gound that it was installed with SP3. I installed SP4 and the error has gone away. I will keep monitoring this for the next couple of days and see if there is any problems. Thanks
ASKER CERTIFIED SOLUTION
awsnoc

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question