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