Prev: understanding triggers
Next: On to Bulk Insert issues
From: Pupkin on 7 Aug 2006 16:09
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.
From: Erland Sommarskog on 8 Aug 2006 18:10
Pupkin (spamagnet(a)dorrk.com) writes:
> 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(a)sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
From: Pupkin on 10 Aug 2006 12:52
In article <Xns981A1C3B728EYazorman(a)127.0.0.1>, esquel(a)sommarskog.se
says...
> Pupkin (spamagnet(a)dorrk.com) writes:
> > 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.
From: Erland Sommarskog on 10 Aug 2006 17:20
Pupkin (spamagnet(a)dorrk.com) writes:
> In article <Xns981A1C3B728EYazorman(a)127.0.0.1>, esquel(a)sommarskog.se
> says...
>> Pupkin (spamagnet(a)dorrk.com) writes:
>> > 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(a)sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
 | 
Pages: 1
Prev: understanding triggers
Next: On to Bulk Insert issues