Post reply

SP4 installation problem

  • September 23, 2005 at 11:59 am

    #165338

    Yesterday, I installed SP4 to my server. First of all it took almost hour to verify the system. After that, installtion was started, but SQL Server and Agent was stopped without any warnings. So I rebooted the server. Then, SQL Server was started, but I tried to look at JOB, the error message showed up.

    "Error 22272: Cannot load the DLL xpstar.dll, or one of the DLLs it references. Reason 127(The specified procedure cannot be found.)"

    When I right click the master and to click properties, another error showed up.

    "Error 0: Cannot load the DLL xpstar.dll, or one of the DLLs it references. Reason 127(The specified procedure cannot be found.)"

    Is there any one can give me some clues?

     

  • September 24, 2005 at 5:58 am

    #592838

    Looks like xpstar.dll has not been put in the registry.

    Try adding it by using regsvr32

    like regsvr32 xpstar.dll in the directory where xpstar.dll is located.

     

  • September 26, 2005 at 6:40 am

    #592954

    Thanks your resopnse.

    I tried to register xpstar.dll with REGSVR32, but error returned again.

       LoadLibrary ("c:\program files\microsoft sql server\mssql\binn\xpstar.dll") failed - The specified procedure could not be found.)

    Is there any answers??????

    Thanks.

     

     

  • October 18, 2005 at 9:44 am

    #597982

    I have a very similar problem.  Right click on jobs and try to view history. "Error 22272: Cannot load the DLL xpstar.dll"

    xpstar.dll does not register.  Nothing on MS Site.

  • October 27, 2005 at 3:43 am

    #600508

    I'm having the same problem as well.  I noticed it after I installed the latest round of security updates.  I think there was a problem in the updates.  Hopefully Microsoft will post a fix soon.  I've tried everything I can think of to get around the problem.  It's really causing a critical problem for me but nothing works.  If anyone's found a way around the problem I'd be eager to hear it.

  • October 27, 2005 at 5:46 am

    #600529

    Our problem is now fixed.  The fix is to re-install SP4.  There is a sp4 install log file on each node of our cluster.  The node in quesion did have errors in the log.  We contacted Microsoft to see if we could just put in the missing file or whatever but they said to re-apply sp4.  That did work.

  • March 21, 2006 at 3:41 am

    #627815

    I have fixed this problem simply by copying the xpstar.dll file from the origianl installation cd to the program files\ms sql server\mssql\binn folder.

    Worked fine and pretty simple.

    If I should not have done this I'd appreciate comments.

  • August 6, 2008 at 3:21 pm

    #854139

    Hi ,

    I had the same issue with SQL server agent (SQL server 2000 - Windows 2000 server), drilled down the problem in folders ,registry and dlls ,found SQL server startup account is not having permission in C:\winnt\system32 folder and then it started

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply