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

Giganews Newsgroups
Subject: Error 22272: Cannot load the DLL xpstar.dll...
Posted by:  Pupkin (
Date: Mon, 7 Aug 2006


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

At a loss. Thanks.