TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
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?
Reply
Answers (
7
)
How to change host header and ssl settings SP2016.
ChangeDatabaseInstance("<DBServerName>") not working