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





Leave a Reply