We have SQL Server 2014 was already installed with instance name MSSQLSERVER, we have used same server where we have installed SQL Server 2019 with instance name MSSQLSERVER19 and restored all the database from SQL Server 2014.

Now we have stopped existing SQL Server instance agent MSSQLSERVER and configured the new MSSQLSERVER19 agent with the same port which was used by MSSQLSERVER, and started the new agent.

When I try to load page, getting below error(Web page is in classic ASP).

ADODB.Recordset error ‘800a0e78’

Operation is not allowed when the object is closed.

Everything is working fine in SQL Server 2014.

I would really appreciate help here if someone has come across this situation or idea about this. Thanks.