怎么会拒绝访问xplog70.dll

Question

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

SqlServer 实例使用localsystem来运行的

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

怎么会拒绝访问xplog70.dll

系统：win2012r2

sql：sql2014sp1

---

Love SQL

Answer 1

Hi 桦仔,

 

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

 

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

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

 

2. 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

 

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

 

4. 检查一下存储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 [e-mail].

Answer 2

不能查询出结果

---

Love SQL

Answer 3

试一下这个

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 [e-mail].

Answer 4

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

Answer 5

操作系统中这个文件是否在？

Answer 6

从目前情况看，应该不是权限的问题，你可以看一下那个文件在不在对应的文件夹里。

---

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 [e-mail].

Answer 7

在的

---

Love SQL

Answer 8

通过安装程序修复一下看能不能解决问题