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

Hi,

I'm running SQL Server 2000 on a Windows 2003 server. It's serving
several small web site databases.

About a month 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 xpstar.dll, or one of the DLLs it
references. Reason: 127(The specified procedure could not be found.).

I've also tried doing these tasks with some third-party apps (EMS,
Teratrax), and I get the same errors.

I've Googled this but the two fixes I've read about (reinstalling MDAC
and reinstalling SP4) didn't work for me.

I'm not sure what caused it -- probably a Windows update -- because I
didn't notice it until several weeks later.

Any idea what I can do to fix this without completely reinstalling SQL
Server? Its other functionality is unaffected; maybe it's a Windows
problem?

At a loss. Thanks.Pupkin (spamagnet@.dorrk.com) writes:

Quote:

Originally Posted by

About a month 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 xpstar.dll, or one of the DLLs it
references. Reason: 127(The specified procedure could not be found.).
>
I've also tried doing these tasks with some third-party apps (EMS,
Teratrax), and I get the same errors.

I would look for MSVCR71.DLL in SYSTEM32. I would suspect that this is
what is missing.)

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||In article <Xns981A1C3B728EYazorman@.127.0.0.1>, esquel@.sommarskog.se
says...

Quote:

Originally Posted by

Pupkin (spamagnet@.dorrk.com) writes:

Quote:

Originally Posted by

About a month 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 xpstar.dll, or one of the DLLs it
references. Reason: 127(The specified procedure could not be found.).

I've also tried doing these tasks with some third-party apps (EMS,
Teratrax), and I get the same errors.

>
I would look for MSVCR71.DLL in SYSTEM32. I would suspect that this is
what is missing.)
>

Nope. That one's in 9 different places in the system, including
system32.|||Pupkin (spamagnet@.dorrk.com) writes:

Quote:

Originally Posted by

In article <Xns981A1C3B728EYazorman@.127.0.0.1>, esquel@.sommarskog.se
says...

Quote:

Originally Posted by

>Pupkin (spamagnet@.dorrk.com) writes:

Quote:

Originally Posted by

About a month 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 xpstar.dll, or one of the DLLs it
references. Reason: 127(The specified procedure could not be found.).
>
I've also tried doing these tasks with some third-party apps (EMS,
Teratrax), and I get the same errors.

>>
>I would look for MSVCR71.DLL in SYSTEM32. I would suspect that this is
>what is missing.)
>>

>
Nope. That one's in 9 different places in the system, including
system32.

And XPSTAR.DLL itself is in the BINN directory for the instance?

I chanced on MSVCR71 after having looked at the dependencies for
XPSTAR.DLL and that was the only that looked suspicious.

Then again, the message says that the procedure could not be found.
I believe that if an entire DLL was missing, the error would be another.
But whether this missing procedure is xpstar.dll itself, or in a
referenced DLL that has been replaced I have no idea.

Reinstall the SQL Server tools? Don't forget to reapply service packs.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

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

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