Change sharepoint_config db connection string issue.

Rahul Khanna

8y4.8k

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?

7 Replies

Know the answer? Post it — somebody with the same question will find it here.

Rahul Khanna8y ago
@Shubham: I have configured the alias using cliconfg tool both in application and wfe server... There in alias name I have given old several listener name and server name given new dns listener name... and I have shut down the primary db server but still sharepoint works... then I shut down the secondary db server.. still the sharepoint work... I mean even though we configure alias with dns listener name... availability group work.... Is this expected behavior????
0
Shubham Bansal8y ago
Yes, the alias will not work with availability group since its a different server and the resolution of the server will be done by the DNS listener.

If it the server name is updated in the registry, it should be updated.
where you are checking the data source field?

Have you checked the connection of the config DB from new Database server, See if there are active connections to SharePoint farm.
0
Krunal Barot8y ago
Have you try this method to change your database server ?

https://www.c-sharpcorner.com/article/getting-started-with-moving-sharepoint-server-to-another-farm/
0
Rahul Khanna8y ago
@Nanddeep:thanks for your reply... Are you sure we can change data source name using the sp wizard... We want to retain the all previous configuration... I think if we run the wizard it will override old sharepoint_config db... then we will loose our configuration... If you are sure about this approach please share me any reference documents.
0
Rahul Khanna8y ago
@Shubham :Thanks for your reply.. I have checked the registry it is updated correctly... But not sure why sharepoint_config database data source shows as oldserver name.... With regards to Alias.... we have two sql server for availability group... so we have setup dns listener for this connection... So can we use this dns listener name in the alias configuration... I heard alias will not work with Availability group... Is it true.... Can you please confirm on this.
0
Shubham Bansal8y ago
It would have been a lot easier if you were using aliases rather than the server name. Looks like when you run the command it is not updating the registry settings where the config DB connection string is present. Try running the stsadm -o setconfigdb.
0
Nanddeep Nachan8y ago
Please try by running SharePoint product configuration wizard.
0