Solve the problem that the xplog70.dll file cannot be loaded when modifying SQL server 2008 server properties.

Xplog70.dll cannot be loaded on SQL server 2008

In the object resource manager, right-click the server name and select Properties.

An error message is displayed, as shown below:

My final solution is: Copy the xplog70.dll file to the "installation directory Microsoft SQL ServerMSSQL10_50.MSSQLSERVERMSSQLBinn" directory on someone else's computer with SQL server 2008 installed.

I found several different xplog70.dll files on Baidu and google and found they could not solve the problem. Therefore, you should copy them to other hosts honestly ~ Secure and worry-free

Other methods

However, when viewing database properties, it is reported that the xplog70.dll cannot be loaded. This is the case when using sa for login, and use

You can view the properties when logging on to windows identity authentication.

The result shows that the xplog70.dll file is missing in the directory C: \ Program Files \ Microsoft SQL Server \ MSSQL10.MSSQLSERVER \ MSSQL \ Binn.

C: \ Program Files \ Microsoft SQL Server \ MSSQL10.SQLEXPRESS \ MSSQL \ Binn copied a copy to the above path. Check the attributes again.

 

On the SQL Server, right-click "SQL Server" and the system reports "cannot load dll, xplog70.dll ",

That is, you have deleted or renamed xplog70.dll to cancel the xp_mongoshell execution.
Solution
Reload xplog70.dll
Method

If only xplog70.dll is missing, the easiest way is to find the same xplog70.dll and put it under C: \ Program Files \ Microsoft SQL Server \ MSSQL \ Binn.