Post reply

Cannot load the DLL xpstar.dll, or one of the DLL''s references. Reason: 126(The specified module could not be found.).

  • December 21, 2005 at 7:14 pm

    #115790

    I get this error message when trying to restore a database. It seemed to start occuring after the update to SP1 of the Windows Server 2003 OS. I've tried copying the errant dll to the appropriate folder and even registering it with regsrvr32 but no luck. Does anybody know what the cause and fix to this error would be?

    Here's the error again:

    Cannot load the DLL xpstar.dll, or one of the DLL's references. Reason: 126(The specified module could not be found.).

    Thanks in advance.

    John

  • December 21, 2005 at 10:01 pm

    #611021

    What folder are you copying it too? By default, if no path is specified, the folder it should be in is whatever the binaries folder is for that particular install of SQL Server. For a default instance in a normal install it would be:

    C:\Program Files\Microsoft SQL Server\MSSQL\Binn

    K. Brian Kelley
    @kbriankelley

  • December 27, 2005 at 9:00 am

    #611539

    Run Microsoft's dependency checker (depends.exe, ya, I don't care for the name either...) against your DLL. You will also need to load the DLL's that your DLL references. You probably don't have the C run-time DLLs on the target machine.


    PeteK
    I have CDO. It's like OCD but all the letters are in alphabetical order... as they should be.

  • January 4, 2007 at 8:14 am

    #681208

    After 2 days of sufferings: It's enough to reinstall the SP4 (or SP3 if you're still in SP3)!!! This will copy and register (whatever is to be registered) the needed files (xpstar.dll included) before aplying the SP4 scripts again. So everything works again.

    It has to be said that (at least in my case) these problems where only at the Entreprise manager level (SQL server was actually functioning correctly..everything was possible on the command line or through distance access). it seems that these extended procedures in xpstar.dll are used by Enterprise Manager.

    Well problem solved anyway!

  • January 4, 2007 at 8:24 am

    #681218

    were the tools on a different machine, I know it was a w2003 sp but .. , worth pointing out that sql sp's should be applied to client tools only installs as well as the sql server engine

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

Viewing 5 posts - 1 through 4 (of 4 total)

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