Post reply

xplog70.dll

  • August 25, 2003 at 11:46 am

    #76041

    Hi , can some can help me how to enable xp_cmdshell or let me know how to resolve the error

    "Could not able to find xplog70.dll error 126" while accessing xp_cmdshell or instance properties from Enterprize Manager.

    venkatesh


    venkatesh

  • August 25, 2003 at 11:49 am

    #471279

    Are you running as "sa" or having sysadm rights?

    .

  • August 25, 2003 at 1:02 pm

    #471298

    The login has sysadmin rights .

    venkatesh


    venkatesh

  • August 25, 2003 at 1:09 pm

    #471299

    Try executing the following:

    use master

    go

    sp_helpextendedproc 'xp_cmdshell'

    go

    If the above result says that xp_... doesn't exists, you can try to add it using sp_addextendedproc. Someone

    might have removed the DLL file from the Server that implements this xp, if so, you have to copy it back from

    the install CD (or service pack).

    .

  • August 25, 2003 at 1:23 pm

    #471301

    I have executed that , the result is below

    name dll

    -------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

    xp_cmdshell xplog70.dll

    venkatesh


    venkatesh

  • August 25, 2003 at 1:26 pm

    #471303

    what is the default location of xplog70.dll .

    venkatesh


    venkatesh

  • August 25, 2003 at 1:29 pm

    #471304

    the dafault location is in "Microsoft SQL Server\MSSQL\Binn".

    Can you unregister and register it again? Copy the file to some location before unregistering.

    .

  • August 25, 2003 at 1:34 pm

    #471305

    what is the best process of unregistering, without restarting sql server as this is production database.

    venkatesh


    venkatesh

  • August 25, 2003 at 1:40 pm

    #471306

    I have not tried this before... But never heard of any issues with this.

    You can check booksonline for sp_dropextendedproc.

    I don't believe you need to restart SQL Server.

    .

  • August 25, 2003 at 2:32 pm

    #471321

    Thanks for your quick help, it did worked successfully, there was dll missing in the default directory. I recollected that I had removed this part of security to disable xp_cmdshell. It is working now ..

    Thanks a lot once more time.

    venkatesh


    venkatesh

  • August 25, 2003 at 2:35 pm

    #471322

    You are Welcome.

    .

Viewing 11 posts - 1 through 10 (of 10 total)

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