Getting error " CRJAZ2654E The server was unable to connect to the database because the database connection settings are invalid or because database is unreachable (SQLSTATE: 0) while executing lockreset command"
Hi,
We have migrated SQL server 2012 database server from one server machine to another machine where we have installed SQL 2014 and restored the database of SQL 2012.
In the application server machine , we have updated the teamserver properties pointing to new database server machine.
We we tried running the application, we got error that lock id value is not matching with database lock id and for that we tried executing lockid reset command but when we tried that we got error
CRJAZ2654E The server was unable to connect to the database because the database connection settings are invalid or because database is unreachable (SQLSTATE: 0)
However, from application admin page database connection, we are able to connect the database.
We cross checked sql drivers and firewall and everything is fine.
Any idea how can i fix this issue ?