SQL Server ADODB. Recordset error "800a0e78", when object is closed, operation _ application technique is not allowed

Database SQL Server, the test program displays an error message: "ADODB." The Recordset error "800a0e78" object is closed, operation is not allowed

Independent test Database link, display error message: User "sa" Login failed. Reason: not associated with a trusted SQL Server connection.

This problem is typically caused by SQL Server not Integrated Windows authentication, so the solution is:

1, open SQL Server Enterprise Manager.

2, select the Server Name Right button, select Properties, and then open the Security tab.

3. In the tab, select Authentication as SQL Server and Windows

4, restart SQL Server, problem solving.