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.
04/04 05:06:01.929 INFO ConfigThread.java 589 Configuration progress : 10 out of 25 tasks completed.
04/04 05:06:01.929 INFO ConfigThread.java 549 Executing task# 11, task name : Applying patches
04/04 05:06:01.929 INFO Task.java 214 Running: Applying patches
04/04 05:06:01.929 INFO PatchDatabaseTask.java 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 PatchDatabaseTask.java 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 PatchDatabaseTask.java 473 Correct the database or vnode if it is not working.
04/04 05:06:02.601 ERROR PatchDatabaseTask.java 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.