We have migrated MS SQL Server 2014 to MS SQL Server 2019.
We have separate Windows 2019 OS Server where SQL Server 2014 was already installed with instance name- MSSQLSERVE, we have used same server where we have installed SQL Server 2019 with instance name – MSSQLSERVER19 and restore all the database from SQL Server 2014 now we have stopped existing SQL Server instance agent – MSSQLSERVER and configure new MSSQLSERVER19 agent with same port which used by MSSQLSERVER and start new agent but somehow web server is not connecting and throwing below error
Microsoft OLE DB Driver for SQL Server error ‘80004005’
Named Pipes Provider: Could not open a connection to SQL Server [2].
In webserver we have connection string in registry and registry read by Global.asa files
Connection String = Provider=MSOLEDBSQL;DataTypeCompatibility=80;SERVER=<>;Encrypt=Yes;TrustServerCertificate=Yes;Trusted_Connection=Yes;APP=<>;WSID=<>;DATABASE=<<>DB Name>
Do I need to change any configuration in connection string ?