Creating Performance Point service app.

lots of people in the discussion list are asking how to create the performance point service apps.

Here are the steps to create performance point service.

GUI

1.) Open your Central Admin page
2.) Click on Manage Service Applications
3.) Look for a Service Applications with a "Type" of "Secure Store Service Application", (if you don't have one, create a new one)
4.) Click on that, the App, (not the Proxy)
5.) If it tells you that you need to generate a key before you can use it, your key isn't setup yet
6.) In the Ribbon you'll see a Create or Generate Key button
7.) Click on that
8.) Enter a Key Passphrase
9.) Now go back up to the Manage Service Applications page
10.) Find your PerformancePoint Service App, (if you don't have one, create one)
11.) Click on the link to that App now
12.) When you get there, click on the first link "PerformancePoint Service Application Settings"
13.) Your Secure Store App's name should automatically be set in the text box
14.) Now you just need to give it the Unattended Service Account name that you want it to use




These are the actual commands, (generalized here), that I use to create the SS, Generate the Key, and create the PPS Application. You run these from within your SharePoint Management Shell.

******************************
** Create the Secure Store App and Key **
******************************
1.) New-SPServiceApplicationPool -Name -Account
2.) New-SPSecureStoreServiceApplication -ApplicationPool -AuditingEnabled -Name
3.) New-SPSecureStoreServiceApplicationProxy -DefaultProxyGroup:$True -Name -ServiceApplication (Get-SPServiceApplication | select DisplayName,ID | where-object { $_.DisplayName -eq }).ID.GUID
4.) Update-SPSecureStoreMasterKey -ServiceApplicationProxy ((Get-SPServiceApplicationProxy | select DisplayName,ID | where-object { $_.DisplayName -eq }).ID.GUID) -Passphrase
5.) Update-SPSecureStoreApplicationServerKey -ServiceApplicationProxy ((Get-SPServiceApplicationProxy | select DisplayName,ID | where-object { $_.DisplayName -eq }).ID.GUID) -Passphrase

***********************
** Create the PPS Application **
***********************
6.) New-SPServiceApplicationPool -Name -Account
7.) New-SPPerformancePointServiceApplication -Name -ApplicationPool
8.) New-SPPerformancePointServiceApplicationProxy -Name -ServiceApplication -Default
9.) Set-SPPerformancePointSecureDataValues -ServiceApplication (Get-SPServiceApplication | select DisplayName,ID | where-object { $_.DisplayName -eq }).ID.GUID -DataSourceUnattendedServiceAccount (New-Object System.Management.Automation.PSCredential , (ConvertTo-SecureString -AsPlainText -Force))

Opening HTML Files in Sharepoint 2010

I recently faced an issue where the customer was attempting to open HTML documents from a document library. He only had an option to download the document. He wanted the ability to open the HTML document directly within the browser.

By default, Sharepoint 2010 is blocking the ability to open HTML documents directly from a document library.

However this can be changed by adjusting the browser file handling option. The option is located here:


1. Central Admin\Application Management\Manage Web Applications.
2. Select General Settings for the specified web application
3. For Browser file handling, select permissive. The default is strict​

Azure Design patterns.

Design patterns for azure.

http://azuredesignpatterns.cloudapp.net/AppPatterns.aspx#hostedwebserviceworker

Sharepoint 2010 BETA is availiable now.

good news sharepoint guyssss here is the link to download sharepoint 2010.

http://msdn.microsoft.com/en-us/sharepoint/default.aspx

Download the SDK and start working :)

DB Availability with Failover Database server.

Some times Sharepoint site will be down because of database server.

think if it is a production and u left for the day suddenly database server is down the next day you hav to come and fix the issue. :(

fortunately in sharepoint 2010 we can fix this issue with out doing anything. There is a new thing called Failover Database server.

We have to set this property. Sharepoint automatically picks the other database server automatically if the first or primary server is not available.

The other database which we are talking is a mirror of SQL database.

To set this property we have to do as below:

Central Admin-> Application management-> Manage content Databases-> DB->enter the sqlmirror DB value in "FailOver Database Server".

really a cool feature for Admin guys. :)

Content Recovery from Unattached Databases

Sharepoint 2010 is providing new feature to recover data from a sharepoint backup DB. without attaching the db to site.

Here you go for example I have a document deleted and it is not there in recycle bin as well so to recover that we have to get backup db attach to site and do some extra steps.

Now in sharepoint2010 they are providing an UI where we can attach a backupDB and can dig in to the sitecollections->sites->lists->items.

Here is the steps to do:

Central Admin->Backup and restore->specify the name in unattached content database data recovery-> DBname-> site->list->select export site or list ->specify location in harddrive.



So we can export that content or document to harddrive and can import in to the site.

this is a cool feature. :)

Restarting timer jobs using powershell in sharepoint 2010

This is the single line of powershell script which restarts the timerservice jobs in sharepoint 2010


Get -SPTimerjob | where {$_.name -match "hourly"} | start -sptimerjob.


this line says to get all the sptimerjobs where name mathces hourly and run that job.


still stsadm command works but powershell is rocking :) admin people must learn this powershell.