AnsweredAssumed Answered

SDM 14.1 high avalaibility not reconfiguring after restoring migrated mdb 12.6 to 14.1

Question asked by La-Qa on Apr 4, 2017
Latest reply on Apr 5, 2017 by Jon_Israel

Hello Team


We are doing testing of sdm 14.1 high availability . The installation is successfull. Now we setup sdm 12.6 conventional  and then migrated it to sdm 14.1 which is successfull. Now i took backup of migrated mdb and restore it to 14.1 sdm database which is also successful. Now when i reconfigure sdm 14.1 BG server its giving error. "Cannot connect to database" Even database server is pingable . and i also recreated servicedesk user in sql. But still the error is coming up.

i even change the dlgtsrv table with bg server hostname. but error still coming up


What is the resolution of it?


LOG of check db is below

04/04 05:06:02.29 SDM14BG sql_ckeckdb 2828 ERROR sqlclass.c 473 Failed to logon to SQL Server (SDM14) Reason: [Microsoft OLE DB Provider for SQL Server] [ SQL Code=4060 SQL State=42000] Cannot open database "mdb" requested by the login. The login failed.



LOG COnfigure


04/04 05:06:01.929 INFO 589 Configuration progress : 10 out of 25 tasks completed.
04/04 05:06:01.929 INFO 549 Executing task# 11, task name : Applying patches
04/04 05:06:01.929 INFO 214 Running: Applying patches
04/04 05:06:01.929 INFO 353 Executing altArgs >sql_check_db -c -s SDM14BG -o mdbadmin -d mdb -U mdbadmin -p <DB password> -n SDM14<
04/04 05:06:02.601 INFO ? ? Process C:\PROGRA~2\CA\SERVIC~1\bin\sql_check_db.exe completed with exit code 99
04/04 05:06:02.601 ERROR 470 Can't contact the database or (the database is empty and you are not loading data) or (this database is configured for another server).
04/04 05:06:02.601 ERROR 473 Correct the database or vnode if it is not working.
04/04 05:06:02.601 ERROR 474 Reconfigure and acknowledge that you want to reconfigure the database to this Primary Server or reload data if the server name in the dlgtsrv table names another server.