Rahul Khanna

Rahul Khanna

  • NA
  • 236
  • 0

Change sharepoint_config db connection string issue.

Aug 6 2018 9:52 AM
I am changing the sharepoint 2016 database connection to new SQL server. I have followed the msdn link https://docs.microsoft.com/en-us/SharePoint/administration/move-all-databases I am changing the SharePoint_Config database connection to "SQLNEWDB" #old db listener name: SQLOLDDB #New db listener name: SQLNEWDB $db=get-spdatabase -identity "5e94e00b-25a3-845f-9b3b-0c85075da007" $db.ChangeDatabaseInstance("SQLNEWDB") $db.update() After executing the above script, if I go to the sharepoint central admin server in the farm page...I can see SharePoint_Config db mapped to "SQLNEWDB" but after couple of hours I refresh the central admin manage server page..I can see automatically again the old "SQLOLDDB" reverted back for SharePoint_Config database...Am i missing anything?

Answers (7)