Today, when I was helping a client maintain a website, I was prompted with ADODB.Recordset error 800a0e78 when running asp. When the object is closed, the operation is not allowed. It turns out that there is a problem with the connection between asp and sqlserver.
Database SQLServer, the test program displays an error message: ADODB.Recordset error 800a0e78 The operation is not allowed when the object is closed.
When testing the database link independently, an error message is displayed: Login failed for user sa. Cause: Not associated with a trusted SQL Server connection.
This problem is generally caused by SQL Server not integrating Windows authentication, so the solution is:
1. Open SQL Server Enterprise Manager.
2. Right-click on the server name, select Properties, and then open the Security tab.
3. In the tab, select Authentication for SQL Server and Windows
4. Restart SQLSERVER and the problem is solved.