none
怎么会拒绝访问xplog70.dll RRS feed

  • 问题

  • 无法加载DLL xplog70.dll或它引用的一个DLL
    拒绝访问 17750

    SqlServer 实例使用localsystem来运行的

    我打开ssms的时候也是:以管理员身份运行

    怎么会拒绝访问xplog70.dll

    系统:win2012r2

    sql:sql2014sp1


    Love SQL

    2017年4月12日 3:27

答案

全部回复

  • Hi 桦仔,

     

    这个dll文件是用来SQL Server登陆使用的一个模块,拒绝访问可能有以下几个原因(第一个原因可能多一些):

     

    1. xplog70.dll被其他进程占用了,你可以用这个语句查询一下:

    打开cmd,执行tasklist /m xplog70.dll

     

    1. xplog70.dll文件损坏了,你在SSMS里面执行以下查询:
    select
    *
    from sys.dm_os_loaded_modules where
    name like
    '%xplog70.dll%'


    如果可以查询出结果,那么很大可能是文件损坏,你到别的机子上去拷贝一个过来替代原文件。文件在C:\Program Files\Microsoft SQL Server\****\MSSQL\Binn\xplog70.dll

     

    1. 检查一下dll文件的dependency,用一下这个工具:http://www.dependencywalker.com/

     

    1. 检查一下存储dll文件的文件夹或者文件上的权限是不是有什么问题。

     

    Best Regards,

    Teige

     


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    2017年4月12日 8:11
    版主
  • 不能查询出结果


    Love SQL

    2017年4月12日 8:19
  • 试一下这个

    select
    [name]
    from sys.dm_os_loaded_modules
    where [name] like '%C:\Program Files\Microsoft SQL Server%' 
    	or [name] like '%C:\Program Files(x86)\Microsoft SQL Server%'
    再看一下那个dll文件的版本号


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.


    2017年4月12日 8:37
    版主
  • name
    C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\Binn\sqlservr.exe
    C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\Binn\opends60.dll
    C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\Binn\SQLOS.dll
    C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\Binn\sqlmin.dll
    C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\Binn\sqllang.dll
    C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\Binn\sqlTsEs.dll
    C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\Binn\sqldk.dll
    C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\Binn\qds.dll
    C:\Program Files\Microsoft SQL Server\120\Shared\instapi120.dll
    C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\Binn\Resources\2052\sqlevn70.rll
    C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\Binn\Resources\1033\sqlevn70.rll
    C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\Binn\hkruntime.dll
    C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\Binn\hkcompile.dll
    C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\Binn\hkengine.dll
    C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\Binn\dbghelp.dll
    C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\Binn\BatchParser.dll
    C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\Binn\SqlAccess.dll
    C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\Binn\xpsqlbot.dll
    C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\Binn\xpstar.dll
    C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\Binn\SQLSCM.dll
    C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\Binn\Resources\2052\xpstar.rll


    Love SQL

    2017年4月12日 10:05
  • 操作系统中这个文件是否在?
    2017年4月13日 0:46
  • 从目前情况看,应该不是权限的问题,你可以看一下那个文件在不在对应的文件夹里。

    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    2017年4月13日 9:43
    版主
  • 在的


    Love SQL

    2017年4月13日 11:57
  • 通过安装程序修复一下看能不能解决问题
    2017年4月14日 1:12