rename the  default database  name for (sharepoint _config) after installation instead of reinstall again

A A
A A used Ask the Experts™
on
Hello Experts
I have installed  sharepoint 2013 and like to rename the default databasename  given by microsoft  (sharepoint _config) after installation instead of reinstall again
what are the detailed steps to rename it and let sharepoint 2013 connect to the renamed database name normally
waiting for your kind advice
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Distinguished Expert 2017

Commented:
If you intent, you should go through the reinstall process since you would need to make several adjustments including on the iis site configuration.

Why complicate matters?

See if part of the sharepoint administration you can repoint the db connection.
Walter CurtisSharePoint AED
Distinguished Expert 2018

Commented:
Don't rename it once you have it up and running. Not a good idea and can't think of why unless you want to use the same SQL server for different SharePoint installations. (Two different farms on the same SQL server is not supported.)

Good luck...
A A

Author

Commented:
Thank you for your kind replies
The sharepoint is fresh installation with new database as We have standard to follow for renaming database so instead of reinstalling for all servers required to follow naming standard of database
I would like to know what are required to be changed in share point 2013 and SQl server 2014 to point and IIS to new database name either manually or by running script
I hope that experts support Question requirement wisely ?
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Distinguished Expert 2017

Commented:
I've not gone through this process and if you are testing, make sure to backup your system and make sure it is a good backup (i.e. if you restroe from backup the system will work).

The following is an MS document on the matter.
https://docs.microsoft.com/en-us/sharepoint/administration/move-or-rename-service-application-databases
Walter CurtisSharePoint AED
Distinguished Expert 2018

Commented:
I gave you a very wise answer and not a 'wise guy' answer. If you do not heed the advice and warnings that is your decision.

The article provide by arnold is very good, however it is talking about the service application data bases. Those are not the same as the SharePoint configuration database. The config database could be considered the heart of SharePoint and the service applications are the internal organs or limbs of SharePoint.

I cannot offer any advice on this. It is like asking 'I want to shot my self in the head, how can I do that and not get hurt'. And If I say 'don't shot yourself in the head' and you say you are going to do it anyway, nothing I can offer is going to help.

Good luck...
Walter CurtisSharePoint AED
Distinguished Expert 2018

Commented:
Here is something that may allow you to do what you want to do. Seems to be a very good article, and looks like it will work, although I have not tried it out.

http://blog.aspjava.com/2009/07/how-to-change-database-names-for.html

Although this for SharePoint 2007, it looks like it will still work with newer SharePoint. The stadam commands it mentions are still available, but you may want to use the powershell equivalent.

Hope that helps...

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial