Move User profile and Search services to new app server

Issue:
Need to move all the services including UPA and Search services to new app server.
Resolution:
1. Start all the services through manage services at server in CA for new app server.
2. For user profile services and sync services:
First start the user profile service at new server through manage services at server in CA, then start the user profile sync service through same option. It will redirect to new page and need to select the correct user profile application --> Credential --> ok
It will take time around 10-15 minutes to start this service including two FIM services in windows console.
3. For search service:

Start SharePoint server search from manage services at server and then enter the new search DB.

Start SharePoint Foundation search through manage services at server. It will redirect to Search service application. Click on Farm search administration --> Modify topology --> Changed teh server name for Index, Crawl and Admin options with in it

At last run the command to confirm the services and the index location:

stsadm -o spsearch -action list

Move Central Admin from one Server to Another

Issue:
Move CA from one server to another
Resolution:
On the existing farm Central Administration server (old app server) remove the Central Administration website:

• Run the SP configuration wizard
• Select: Do not disconnect from the server farm (Warning: Disconnecting from the server farm will result in all your web applications being deleted from IIS. They can be recreated if you reconfigure central administration again and link to the existing configuration DB, but they will be unavailable until that time. That means no web sites available and more down time than necessary!)
• Select: Yes, I want to remove the website from this machine
• Select: Ok.

Note: The configuration wizard will stop IIS and all websites may become unavailable for a few minutes while it steps through the processes. Ensure that you do not delete any databases as you will be hooking the new Central Admin site to the original DB.

If you check IIS you will see that the Central Administration web application has disappeared leaving only your portal web apps and the OfficeServerApplication

1. Run the SP configuration wizard on the new server (new app server) and recreate the Central Administration site.
   
   • Select: Do not disconnect from the configuration database
   • Select: Advanced Settings
   • Select: Use this machine to host the web site
   • Select: Next / Ok
2. Open central administration and check the servers in the farm – you should see Central Administration now hosted on new app server:

 

Unable to access PowerPivot Management Dashboard in SharePoint 2010

Issue:
In SharePoint 2010 with SQL server 2012 for powerpivot services, we unable to click on "PowerPivot Management Dashboard" and in ULS log the error was like as below:
Background file fill operation caught exception: System.Data.SqlClient.SqlException: The EXECUTE permission was denied on the object 'proc_FetchChunkFromDocStreams', database 'DEVBISP2010_Content_Admin', schema 'dbo

Resolution:
Need to provide DbWriter and DBreader permission to Powerpivot service application app pool account at admin content DB.