Error 22272: Cannot load the DLL xpstar.dll,...

Hi,

I'm running SQL Server 2000 on a Windows 2003 server.

About some days ago, my automatic backups stopped working, and whenever I try to edit or set up a new maintenance plan or export or import data through Enterprise Manager, I get the following error:

Error 22272: Cannot load the dll xptar.dll, or one of the dll's it references. Reason: 126 (the specified module could not be found.)

Any Idea why ?

Look for MSVCR71.DLL in SYSTEM32 directory whether it is present or not.

If no luck then you have to reinstall client tools.

|||Hi,

MSVCR71.DLL in SYSTEM32 directory is present ,. but still i am getting the same error what should i do ?

Please help
|||

That's only one of the files you'd want to look for. You would want to check what files xpstar.dll has dependencies on and search based on all the files. You can use a dependency tool to check the dependencies - try this one:

http://www.dependencywalker.com/

and point it to xpstar.dll

You may also want to try reapplying the last service pack you have installed - that will sometimes find and install the missing files, depending on what is missing.

-Sue