I have set up a SharePoint 2010 farm. Some databases have been configured by using PowerShell scripts. Therefore they have friendly names like SP2010_Config. I do not have made scripts for every configuration step yet so some database names are like this \WebAnalyticsServiceApplication_ReportingDB_2d5a77a9-8360-41cf-9294-14587f977d1d.
I would like to have nice looking names in my SQL server so I change the names of i.e. the WebAnalytics Service like this:
- Go to Central Admin > Manage Service Applications
- Select the Web Analytics Service Application:
- Choose “Properties” in the ribbon:
- Choose “Next” at the Edit Web Analytics Service Application screen
- At the Edit Web Analytics Service Application Topology screen you can edit the database name:
- Click on Reporting Database and choose “Edit Properties”:
- In the next step you can change the database name:
- When back in the Topology screen click “Next” and the changes are being processed:
Be aware: by doing this SharePoint will create new databases with the choosen name.
Tags: database, Howto, Service application, SP2010
October 18th, 2010 at 6:34 PM
nice article, keep the posts coming
September 29th, 2011 at 5:44 PM
Thanks for the post. It has saved me a couple of times now with that WebAnalyticsServiceApplication_ReportingDB database, which gets a name too long for SQL backups to work.
I notice that this option is only available for some of the service application databases and I’m wondering if you or anyone has any tips on renaming the rest of them.
thanks,
Jeff
September 30th, 2011 at 7:45 AM
Hi Jeff,
Glad my post helped some more headache :-). I try to create my SharePoint farms with Powershell scripts so I can name the databases what I want in my scripts. But for quickly deploying a farm it is a real pain in the ass. A quick search on google with this keywords “powershell rename databases” showed these links:
http://technet.microsoft.com/e.....51877.aspx
http://technet.microsoft.com/e.....51878.aspx