The Unattended Service Account cannot be set for the service application. The Secure Store Service key might not have been generated or properly refreshed after the service was provisioned.

This is the error when you get it while configuring the Performance point service application in SharePoint 2010. Once we are done creating Performance Point application, we need to do the configuration part where we need to define the unattanted service account for the application. It is linked to secure store service. Follow the below steps to resolve this issue:-

1) Go to central admin- Manage service applications and check for secure store service. if its not there, create a new one.
2) Once its created, select the services and click on the top ribbon for generating new Key. Once its done, go back to Manage service application page.
3) Under Performance service, click configuration and add the unattended account again and click ok. It should not throw error as the encrypted key was not created. You are ggod to go now and go ahead and create a new site using Business intelligence template.

Powershell script to backup all the site collections in the sharePoint Farm.

Below is the link to powershell script that does the backup of all the site collections in the SP farm.

http://practicalkungfu.net/2011/11/14/sharepoint-2010-backup-all-site-collections-in-all-web-applciations/

I have tested this script and works great. you just need to change your path where you will be running the backups and make sure you provide adequate access to the user.

It also does the deletion after certain no of days. It has 30 days by default but you can change it accordingly to your needs.

Sql server reporting services integration within Sharepoint integration mode

There are couple of things we need to understand while configuring the reporting services integration with SharePoint 2010. Below are two amazing and very helpful links for doing the integration.

a) http://technet.microsoft.com/en-us/library/bb677365%28v=sql.105%29.aspx#bkmk_Computer2_ToinstallaSharePointwebserverfontendontheSSRSserver

b) http://technet.microsoft.com/en-us/magazine/ff686706.aspx

These 2 articles explained what is required to do the integration and what components must be present and what architecture is needed?

I did my production configuration using above links and is working great.

system.web.httpexception maximum request length exceeded sharepoint 2010

Users get an error while uploading a document bigger than 50mb.
SP has a default upload setting of 50mb document. If we need to incrase the size to allow up to 200mb of documents, below are the places where we do it:-

1) In central admin, go to Manage web applications- Click on web app and click general settings- scroll down to and put 200 at place of 50 and save it.
2) Next we need to update web app web.config file under c:\intepub directoru. open the web.config file and search for timout. Now edit the following entries:-
Increase the maxrequestlength to 215200 and execution time to 9999 and save it.

It should be good to go now. Please try to upload again and it should work.