Monday, December 27, 2010

Configuring PerformancePoint Services with Microsoft SharePoint 2010

Hello Friends
To configure PPS (PerformancePoint Services) for Microsoft SharePoint 2010, we need to follow below steps
1. Configure the Secure Store Service.
2. Create the service application.
3. Start the PerformancePoint Service.
4. Configure other service applications which will be useful in the deployment, like Excel Services, SQL Server Reporting Services Integration.

Let us look at every step one by one

How to configure the Secure Store Service, follow these steps:
  • Browse the SharePoint 2010 Central Administration.
  • Select the Application Management tab and then select Manage Service Applications.
  • Look for Secure Store Service and select, and then click Manage on the ribbon
  • It will open Secure Store Service configuration page, select Generate New Key from ribbon.
  • Enter a strong secure passphrase in the dialog box. Because it is protecting potentially sensitive data. Accept the check to Re-encrypt the Database Using the New Key, and then click OK. The database will be encrypted.
  • It will create the Secure Store Service key successfully and the database is encrypted.

Creating the Service Application follow these steps:
  • Start the PerformancePoint Service.
  • Create the PerformancePoint service application.
  • Set the Unattended Service Account.
  • Associate the service application proxy with a proxy group.

To start the PerformancePoint Service, follow these steps:
  • Open the SharePoint 2010 Central Administration site, and then click the System Settings tab in the navigation pane on the left.
  • From this page, click the Manage Servers.
  • From the list of servers in the farm, select the name of the server where you want to start the service application.
  • Look for PerformancePoint Service in the list of available services, and then click Start from the Action column. Once it is started ,then the status changes from Stopped to Started
To create the PerformancePoint service application, follow these steps:
  • Browse to the SharePoint 2010 Central Administration site, and then click Application Management tab in the left navigation pane.
  • Select the Manage Service Applications from Service Applications.
  • From the ribbon, click New. Click PerformancePoint Service Application to launch the PPS Service Application creation dialog box
  • Enter a name for the service application. If this is going to be the default service application, select Add This Service Application’s Proxy to the Farm’s Default Proxy  List.
  • In the Application Pool section of this screen, you can select to either Use Existing Application Pool or Create New Application Pool. If you decide to select Create New Application Pool, enter the application pool name. After you have made your selection, click Create to create the service application. This may take a few minutes. When the process has completed, you see a message confirming a successful creation.
Set the Unattended Service Account follow these steps:
  • From the Service Application Management screen, select Application Management, Manage Service Applications.
  • Scroll to find and select PerformancePoint Service Application from the list, and then select Manage from the ribbon.
  • From the PerformancePoint Service Application Management page, select PerformancePoint Services Settings.
  • Secure Store Service is selected as the default in this screen. If you plan to use the Unattended Service Account to access data sources, enter credentials in this screen, and then click OK
Hope this helps
Disha Shah

Sunday, December 19, 2010

Fajax - the fake alternative to ajax

Hi Readers
There is one problem we are facing now-a-days in our website when it renders all images are coming one by one horizontally. All the pages of websites are flickering.
The solution of the problem is add these metatags inside the master page.
<META http-equiv="Page-Enter" content="blendTrans(Duration=0.2)">
<META http-equiv="Page-Exit" content="blendTrans(Duration=0.2)">
This known as “Fajax”: The fake alternative to ajax.
When a page posts back (for example when you click a button on a form), it normally causes a screen flicker as the page is redrawn.
A lot of the time, this gives an identical effect to an ajax style http request. The page appears to have stood absolutely still as just one part of it is updated.
This simple trick gives you about 50% of the benefit of ajax, with a 1% of the effort.
Disha Shah

Friday, December 10, 2010

FAQs related SharePoint Service Pack 2 and the Cumulative Updates

Hi Friends
Please refer below link for concerning SharePoint Service Pack 2 and the Cumulative Updates for April 2009 for the 2007 Microsoft Office System and Microsoft Office servers
Disha Shah

Configuration Of SharePoint Products And Technologies Failed,After Apply SharePoint Service Pack2

Before some days working on upgrading SharePoint Serves and applying SharePoint Service Pack2.
There are two SharePoint ServicePacks 2 are available which should be applied one after another in sequence.
  1. Download WSS 3.0 SP2 either 32 bit or 64 bit depends on your machine configuration from this link
  1. Download MOSS  SP2 either 32 bit or 64 bit depends on your machine configuration from this link
  1. First apply WSS 3.0 SP2 on server and after it ends , it asks for Configuration Wizard click on Cancel
  2. Apply MOSS SP2 , once it is done it will ask for Run SharePoint  Products and Configuration Wizard.
When I run that , it gives me error on step number 8. I checked the SharePoint Server Version, it looks good , it has upgraded for SharePoint SP2. It has given the below error.

Then I tried to find out from where the source of the error from the Log files, it did not give me good explanation. I checked the upgrade.log file and I read line by line log and I found out one of line which says the upgrading one of the SharePoint site has terminated with X number of errors and warnings.
I checked that SharePoint Site and it gives me errors and then I realized that that site was always throwing error when I tried to open that SharePoint Site.
Then I deattach the Content Database of SharePoint Site from Central Administration and once again I have run the SharePoint Products and Technologies Configuration Wizard and it runs perfectly.
This is one of the scenario for failing the SharePoint Products and Configuration Wizard. There are so many possibilities why error has occurred, and every problem has different solution, please read log files well.
Hope this helps
Disha Shah

Thursday, December 9, 2010

SharePoint Site which uses Form Based Authentication redirects to a diffrenet Login Page during signout

Hello readers
When user clicks in either “Sign out” or “Sign in as different user”, they should redirect to the different login page not the default page in case of Form Based Authentication (FBA).
We can do that by extending class with the “IHttpModule”. We have to write this two methods to redirect to a new page.
public void Init(HttpApplication app)
            app.BeginRequest += new EventHandler(app_BeginRequest);

        void app_BeginRequest(object sender , EventArgs e)
            HttpContext context = HttpContext.Current;

            if (context.Request.Url.PathAndQuery.ToLower().Contains("/_layouts/accessdenied.aspx?loginasanotheruser=true") || context.Request.Path.ToLower().Contains("/_layouts/signout.aspx"))


How to deploy?
  1. Put DLL inside theGAC and put the same dll inside bin folder of the webdirectory.
  2. Open the web.config file and add this section
Under <httpModules>
<add name="LearningVillageSigout" type="LearningVillageSigout.HttpModule" />


Wednesday, December 8, 2010

Moving SharePoint Content database from one drive to another on same server

Hello friends

Before some days my c: drive becomes full so I decided to move the all SharePoint content database files from c: drive to D: drive , how to do that?

Let us see step by step procedure
  1. Run DBCC CHECKDB command first to check there are no consistency errors on the content database or not.
  2. For safer side take the backup of content database before you start the moving process. You can take the backup of any SQL Database by following this method.
  3. Go to ->Microsoft SQL Server Management studio -> Databases->Content Database->Task->Backup
  4. Right click SharePoint database name, select Tasks -> Detach. Check Drop connection if there are active connections.
  5. Using Windows Explorer, copy the existing Primary Data File, Secondary Data File, and Transaction Log from location on C(old) drive and Paste these files into new folder on D(new) drive
  6. Run following command in query windows.
  7. use master
    EXEC sp_attach_db @dbname = N'WSS_Content_DatabaseName',
    @filename1 = N'D:\MSSQL\Data\WSS_Content_DatabaseName.mdf',
    @filename2 = N'D:\MSSQL\Data\WSS_Content_DatabaseName.ldf'
  8. Run DBCC CHECKDB command again to check there are no consistency errors on the content database after moving. Query message should show 0 allocation errors and 0 consistency errors.
  9. Make sure that SharePoint application is running properly after content database move.
  10. Done.
Disha Shah

Tuesday, December 7, 2010

SharePoint Designer 2010: Fix the Width of a Master Page

Hello Friends,

We can add an embedded style sheet that will fix the width of pages inheriting from this master page. Let us look at step by step procedure.

1. Open a your sharepoint site in SharePoint Designer 2010.
2. Select the Master Pages section of Site Objects.
3. Create a new master page,name it mycustom.master.
4. Right-click on the file and select “Set as Default Master Page.”
5. Right click on the file and select “Edit File in Advanced Mode.”
Add the following embedded style sheet into the master page just before the closing </head> tag:
<style type=”text/css”>
/*fixed width */
#s4-workspace > div,#s4-bodyContainer > div,body #s4-titlerow > div{
margin:0 auto;
body #s4-mainarea{
/*make main area have background of white and add a border */
border:1px solid #ddd;
/*contain content in all browsers but IE7 */
/*add padding back to title table*/
padding:0 0 0 5px;
/*background color of site*/
#s4-workspace {
background:#efefef /*none*/;
/*body container */
/*fix overhanging tables*/
6. Save and check in your changes.

Check the width has been changed!!!

Hope this helps!!!

Disha Shah