Worker process for App pool?

Query:
Some it is need to dragdown which which application pool/site is consuming much CPU/memory as compared to others.
Resolution:
In Windows 2008 the steps are as follows:
In Windows Server 2008 we can find worker process w3wp.exe and its associated application by following below steps
Open Windows Server 2008 -->Run command prompt as "Run as admin" --> Navigate to C:\Windows\System32\inetsrv and then run following commnads.

C:\Windows\System32\inetsrv>appcmd list wp To get list of application pool and its worker process

C:\Windows\System32\inetsrv>appcmd list sites To get list of all web sites

C:\Windows\System32\inetsrv>appcmd list appPools To get list of all application pools on IIS server.

"User Information List" in SharePoint 2010

"User Information List" in SharePoint 2010 is one of a list which is hidden at site collection level. One can access this hidden list by sitecollectionURL/_catalogs/users/simple.aspx SharePoint admin can consume this list in inforpath forms to retrieve users information and fetch it at inforpath form. when ever a new user is added to sharepoint site collection level not at site level, at first that user will be added to this "User Information List". So, we can consider this list as a repository of all users present in the site. /_catalog/users may show different users on different site on the same site collection We can acess this list through object model as: SPList hiddenUserList = SPContext.Current.Web.SiteUserInfoList; Note that this list contains the users which are deleted from Active Directory. Hence, whenever we delete a user from SharePoint site, its actually a soft delete and that user details still exist in this hidden list.

Infopath form stuck with installing or deleting in SharePoint 2010

Issue: Infopath form stuck with installing or deleting. Resolution: Restart SharePoint admin and timer services mainly on web servers

Hide "More Information" option from profile page

Hide "More Information" option  from profile page

1) Save following script in java file:

2) Save above java file at my site collection

3) Open person.aspx page ==> add content editor web part at the bottom of this page ==> provide the java file link to this content editor web part

Access denied when deploying a timer Job or activating a feature from SharePoint 2010

Issue: You might get access denied error message in event  log while activating timer job at site collection level

Cause: This is due to a new security feature implemented in SharePoint 2010. This feature explicitly blocks any modifications to the objects inheriting from SPPersistedObject in the Microsoft.SharePoint.

Resolution: Run below powershell script:
function Set-RemoteAdministratorAccessDenied-False()
{
    [System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SharePoint") > $null
    [System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SharePoint.Administration") > $null

    # get content web service
    $contentService = [Microsoft.SharePoint.Administration.SPWebService]::ContentService
    # turn off remote administration security
    $contentService.RemoteAdministratorAccessDenied = $false
   $contentService.Update()        
}

Set-RemoteAdministratorAccessDenied-False


Reference link: http://support.microsoft.com/kb/2564009

Contribute user unable to upload specific files in SharePoint 2010

Users with contributor permissions are prevented from uploading files with the following extensions:

• ASPX
• MASTER
• XAP
• SWF
• JAR
• ASMX
• ASCX
• XSN
• XSF

A user with contributor rights trying to upload a file with any of the above mentioned extensions will generate a modal dialog "Error: Access Denied" appears. User cannot upload the .SWF file".

Users with designer permissions can upload SWF files successfully in SharePoint 2010. More precisely, the "Add and Customize Pages" permission is required.

Users with contributor permissions could upload SWF files in WSS 3.0 or MOSS 2007.

In Sharepoint 2010, SWF is not by default in the "Blocked File Types" list of a web application but instead has been added to a list of web files considered as web sensitive. These files are listed in the WebFileExtensions property of the WebApplication. The WebFileExtensions property can be programmatically edited, for example using powershell. See WebFileExtensions for more details.

(http://msdn.microsoft.com/en-us/library/microsoft.sharepoint.administration.spwebapplication.webfileextensions.aspx)

Update alerts after DB migration in SharePoint 2010

It is recommended to again set alerts if DB is attached from one web application to other.
In this scenario existing alerts will send URL of old web application

Activate Publishing feature at all site collection through powershell

$feature = Get-SPFeature PublishingSite
$siteCollections = Get-SPSite –WebApplication http://sp2010
$siteCollections | foreach-object {
   Write-Host "Activating" $feature.DisplayName "on" $_.Url
   Enable-SPFeature $feature -Url $_.Url
}

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.

Search Differences: Basic and Enterprise

Basic Search Center: Contextual Search within sites and lists.
Enterprise Search Center - Search Across Site collections and Web applications, People search, Metadata property search,keywords, synonyms, and Best Bets.

Metadata properties for search in Microsoft SharePoint Server 2010. When content is crawled, the crawler also crawls the metadata that is associated with that content — for example, information such as author, title, and e-mail address. The search system stores this information as crawled properties and managed properties. Crawled properties are all properties (such as author, title, or subject) that are extracted from documents during crawls. Managed properties are crawled properties that can appear in refined or advanced searches. When users perform a general search, results include items with any crawled properties. In order to provide refined search capabilities to users, however, you need to plan for managed properties. Because they can appear in refined searches, managed properties help users perform queries that are more successful and relevant. SharePoint Server 2010 provides a default set of managed properties, but you can create new managed properties and map crawled properties to the managed properties that will appear in search result. Refined searches can be performed only on managed properties, not crawled properties.
The properties that are automatically created include the following:
Author, Description, Site Name, Type, File Size, Last Modified Date, URL, Title

Reducing duplicate managed properties:
crawled properties might be Owner, Writer, and Created By, all of which are synonymous with Author.  plan to create one set of managed properties and map the crawled properties that have the same meaning to managed properties. In this case, you map Owner, Writer, and Created By to the managed property Author.
Managed properties scenario:
Example a customer service representative identifier (ID) property in a separate data application, or an Author property for an application type that is used exclusively by customer service representatives. A search query that uses that property or a term associated with that property will include search results for all items that contain any of the crawled properties mapped to the customer service representative ID managed property.

Keywords, synonyms, and Best Bets:
Keywords are search terms that users type into a search box when constructing a query. Users can use them in queries that they submit in the search box on a site, on the Search Center, or in an Advanced Search. When a user query includes a keyword that you have configured, the search results can provide a definition for the term together with links to recommended locations or documents at the top of the search results page.You can define keywords, provide synonyms (words that closely relate to the keyword), and create Best Bets (links to featured documents or locations for the specified keyword), to provide a relevant set of search results for popular search terms. Synonyms are useful when several search terms are used for the same concept and content so that search results are merged and not scattered across several search terms. When you create a keyword, you can also provide a definition of the keyword that appears in search results. By defining terms that are often used in searches as keywords, a site collection administrator can provide a standard glossary of names, processes, and concepts that are part of the common knowledge shared by members of an organization.
If you already have search set up in your production or test environment, you can use Site Collection Web Analytics Reports to help you plan keywords, synonyms, and Best Bets. The reports that are most useful for this effort include the following:
Top Queries, to view the most common search terms.
No Results Queries, to view the most common search terms that yielded no search results.
Best Bet Usage, to view the most frequently-used Best Bets.
Best Bet Suggestions, to view the suggestions for new Best Bets that the search system provides.

Search Service application - SharePoint 2010

Create a Service account with Domain user and DBO permission.
Register this account in managed accounts through CA.
Create new search service application --> CA --> Manage service application --> New --> Search service application --> Enter the name of service application --> Select the service account for this application --> Select new or existing application pool --> OK

Click on Search administration , verify the default content access account and enter the Contact email address, Content sources.

By default the service account selected while creating search application is the default content access account. You can change the default content access account through below step:
Search administration --> System status -->  Click on the account which is just right side of that default content access account.
In the same way change/enter the contact email address.

Create content source --> Click on content source in search administration --> New Content --> Select the content source type --> Add the URL  --> Define the Crawl schedule incremental/full -->ok

To get the people search:
Just add the default content service account permission as "Retrieve people data for search crawl" at User profile service application. Here are the steps:
User profile service application --> Administrator --> add  default content service account permission as "Retrieve people data for search crawlers"
Provide FULL Read permission to this account at all the required web applications.

If you don't have basic search page then create it now, here are the steps:
Browse the top level site --> Site actions --> New Site --> Select "Enterprise Search Center"  --> Enter the name and URL --> Ok

Create Enterprise search page --> Central Administration / Application Management / Site Collections, click on Create site collections.   Ensure you are creating the Site Collection below the relevant Web Application. Enter your Title, Description etc and select the Enterprise Tab under Template selection.  Select the Enterprise Search Center, specify your site collection administrators and click OK.

Secure Store Service -SharePoint 2010

SSS: Secure Store Service in SharePoint 2010 replaces the single Sign On feature available in SharePoint 2007. It is a shared service that provides storage and mapping of credentials. It helps to correct the external systems through secure store data, it is specific to individual or group. SSS can be used to store and map the user credentials required by external system.

Following services can use SSS in SharePoint 2010:
Excel Services  
Visio Services  
PerformancePoint Services  
PowerPivot for SharePoint 2010   
Microsoft Business Connectivity Services

It is recommended to run the SSS in a separate application pool that is not used for any other service, Run the Secure Store Service on a separate application server that is not used for any other service.
 Before generating a new encryption key, back up the Secure Store database

Secure store service and claims authentication

Steps to create SSS:
Create a Service account and provide DBO permission at DB server.
CA --> Manage Service application -->   New -->Enter Service application name --> Enter DB server and DB name --> Enter or select the application pool name --> Select the service account for this SSS through managed account.

Once the SSS is created enter the Target ID --> Set credential and Permission

Ports

ftp = port 21
nntp = 443
smtp = 25
KERBEROS v4 = 88
KERBEROS v5 = 750
dns = 53
dhcp = 67
pop3 = 110

SSO(Single Sign On)

**For the php and older version of .net we can use the web service to call and enable the SSO

Difference between spsite and spweb

spsite is site collection
spweb  are all sites under site collection

Excel graph look and feel issue- PowerPivot

Issue: 
Graph available in excel not looks fine while opening through web browser. Some of the Vertical line missed. The same graph works fine if it is opened with excel instead of web browser.
Resolution:
After a long research I found that the feature needs to be activate one feature at site collection and site feature:
I enabled once again the feature at "site feature" and "Site collection feature":
SharePoint Server Enterprise Site features
Features such as Visio Services, Access Services, and Excel Services Application, included in the SharePoint Server Enterprise License.
Please note: The excel graph view in web browser will be a problem for existing files but working for new files with same content.

UPA in SharePoint 2010

User profile service application:
We must have SharePoint standard or enterprise edition, An instance of the managed metadata service must exists, A managed path exists, My site application pool exists, A site collection taht uses the My site host template exists, June 2011 CU update or later. With out this update the UPA Db cannot be restored. Add UPS service account in Managed accounts through Central Admin.
Should have service account for sync, it should have managed replicate permission at AD.

Create UPA:
Manage service application --> Create new --> Click User profile service application --> Enter the name of new application --> Enter the name of new App pool --> Select Security account for this app pool --> Enter Profile DB name and SQL server name, Authentication would e windows Authentication --> Enter Sync DB, SQL server name and windows authentication --> Social DB, SQL server and windows authentication --> My Site Host URL --> Type - My Site Managed Path --> Enable Self site creation for the Web application that hosts My Sites--> Site naming format would be best to select Domain and user name(will not conflict)

Enter the Sync settings in UPA, set the sync timings.
Set the credential at both the Forefront Identity Manager services in services console as Sync account.

Start the full sync at every change in sync connection.
Set the netBios name =1 if netbios have different name FQDN

Solution never deployed at one of a SharePoint server

Issue:
One of a SharePoint server in a farm creating problem and it stops to deploy solutions, but when we clicked on the solutions name it shows that the solution deployed all the servers except the corrupt server.
Resolution:
1) Enabled the verbose log --> Found that the error is related to timer service which stopped intermittently.
2) When we clicked on "Check Job status" in central admin we found the similar error message "Object reference not set to an instance of an object." and it is also pointing for timer service error in ULS log.
3) We checked the status of server and it was "Need Upgrade" in servers in farm(through central admin). We removed the corrupt from stage external farm.
4) Ran the stsadm command "PSConfig.exe -cmd upgrade -inplace b2b -force -cmd applicationcontent -install -cmd installfeatures" at corrupt server and found few error that the web.config file of central admin is not available in virtual folder.
5) Copied the required folder/files from other stage server to corrupt server and again ran stsadm command "PSConfig.exe -cmd upgrade -inplace b2b -force -cmd applicationcontent -install -cmd installfeatures. This time it completed and it upgraded the timer service.
6) Now the error at servers in farm has been wiped out.
7) We attached the server corrupt server back to stage farm.

Solution hungs through CA while deploying

Issue: I do have 3 web server and two app server. I ran solution deployment at one of a app server but the status gets hung while viewing through central admin. When I clicked on that solution I found that the solution get deployed at all the server except one of a app server. In ULS log of that defective server I got the following error message: Exiting the process because the timer could not be initialized after multiple attempts. The timer service could not initialize its configuration, please check the configuration database. Will retry later. I already clear the cache at all servers and the GUID of the cache folder is also okay. The service account have right permission at server level.

Resolution:
 1) Cleared the cache files.
2) Compared the OWSTimer.exe.configfiles at defective server and correct server
3) Restarted the timer services
4) Rebooted the server defective server
5) Compared the cache file GUID name
6) Compared the cache file GUID with the cache ID available in REGEDIT.
7) Checked the services through central admin.
8) Checked the health console through central admin 9) Removed and added the server from farm and it resolved.

File Checkout Issue

1) SharePoint 2007 have issues that files are locked out continuously and not able to edit/discard check out. A) clear the IE cache & local machine temp files. If the issue persist then ask the user to check in the file. Keep the version of list/library to maximum 10 numbers. If the issue still persist then save as file for local then change the file name & upload. Do the file edit. or Open a new file--> select open --> enter the url of the file & then do the changes

Bit version of servers in a farm

All application server should have same bit version. it is possible to have different bit version in search server, index server, application server. But there should be same bit version of two or more WFE or two or more back end similarly for search server.

SharePoint 2007 Limitations

There are some of listed Moss limitations as:
1) If the URL is more than 250 character then it doesn't allow to create new folder at doc library.
2) It also stops to open the doc library in explorer view
3) It does not allow to edit any file with in it.

Note: We should keep short names for file/folder/doc library/subsite

Modified date not updated at folder level

Issue:
The modified date cannot be modified if we already modified files with in it.

Resolution:
It is a by designin sharePoint 2007 in which the modified date is not updated, if one of its file is updated. This issue has been fixed in SharePoint 2010

Breadcum issue

Issue:
 Not able to view the breadcum/path of file in folder/library.

Resolution:
 The breadcum of a folder/library can be activated once we have master page as:
"default.master"

Sent email failed, but the email id is valid

Most of the time we have seen that the sent email failed. The reason for this issue is mailbox is full.
TO resolve this issue we need to archive huge number of emails in INBOX

SharePoint recycle bin

Issue:
Some time we observed that the list/library was unable to restore from site recyclebin
Resolution: 
Increase the list throttling and restore the list from site recyclebin.

User profile sync issue with AD

Some times SharePoint doesn't allow to sync the user profile properties from AD to SharePoint. After starting the incremental and full sync, SharePoint 2010 user profile doesn't sync the properties with AD. i.e the updated data in AD is not being updated in SharePoint 2010. We can provide Replicate Directory Changes permission to user profile sync service account. The Replicate Directory Changes permission allows an account to query for the changes in the directory. This permission does not allow an account to make any changes in the directory. The Grant Replicate Directory Changes permission does not enable an account to create, modify or delete AD DS object. The same is mentioned at http://technet.microsoft.com/en-us/library/hh296982.aspx

Restored a deleted site at SharePoint 2010

This is very nice that we can restore or get the deleted site collection in production with out ant DB restore. The steps would be:
1) Get all the site's GUID through powershell command
2) use Restore-SPDeletedSite to restore a deleted site collection If we have SP1 installed at SharePoint 2010 farm, then we can restore site from site recycle bin.

Service pack Installation at SharePoint 2010

Here ar ethe steps which would help SharePoint admins to install SharePoint 2010 patches: 1) Save the 14 hive backups at all servers 2) Get ready the full backup of all the SharePoint databases. 3) Disconnect DBs through commands 4) Install the patch at Central admin server --> one by one at all the servers --> Do not start the Configuration wizard at any server unless and untill it is installed at all the SharePoint servers. 5) Start the configuration wizard at central admin and then rest of servers. 6) Attach content db through command(try to do not use central admin for this purpose). It would take more time according to the db size. At this stage the db will be upgrade to same level 7) Check the upgraded service pack through Central admin for all servers. --> Servers in farm

After Successful retraction of solution from SharePoint farm, still showing that status as deployed

Most of the times you can see that after successful retraction of a solution through central admin the status is still showing as deployed. This happens because the solution might be deployed at central admin as well. So follow the below steps: Steps to work around this issue: Retract the solution from all content URLs Retract the solution from the Central Administration web application explicitly .

User profile service application(SharePoint 2010)

Following things should be keep in mind for SharePoint admins, while working or creating new User profile service application: 1) The user profile service application should have "Directory Replication Changes" permission at AD and Network Service should have Read access to the %programfiles%\Microsoft Office Servers\14.0 folder at app server. "Directory Replication Changes" will replicate the user profiles from AD to SharePoint not vice versa. 2) The forefront running in service console should run with the same service account. 3) There should be three DB for user profile service application they are ProfileDB, SocialDB, SyncDB 4) The user profile service account should have DBO permission at all the above DBs. 5) The user profile service and sync service should be started through Central admin-app server. 6) The user profile service account should be mentioned in synhronization service in central amdin. 7) For newly created app, please start the full sync and for the older one we can go for the incremental sync. ** Full sync will start it from scrach about all user profiles from AD to SharePoint, hence beaware while doing and should be used at the last option.

Due to some configuration issue you might get the duplicate search results. To resolve this issue please remove the duplicate URLs in Content Source at search admin

Due to some configuration issue you might get the duplicate search results. To resolve this issue please remove the duplicate URLs in Content Source at search admin

Unable to export a lib in SharePoint 2010

1) If you have Symantec Protection 6.0 for SharePoint Servers at SharePoint server 2010 and you are getting error message as "Unexpected ..." in command window and "Antivirus scan time out" in ULS log

Answer: After a long research I found that we need to stop the symantec service at service console and disable the "Symantec Protection 6.0 for SharePoint Servers" settings at Central Admin.

Double items in list or library

It is a strange that some of the times SharePoint have double items in particular list or libarary

Ans: This can be resolved by recreating the new view at that list/library

500 Internal Server Error

Issue:
In SharePoint 2010 one of the web app not browse able and getting error message as "500 Internal Server Error". This issue is only specific to single web app.

Resolution:
Stop timer services --> Clear the cache files --> Start the timer services at all the servers.

We also tried to changed the web app through IIS manager, to check if that app pool is corrupt or not.

Unable to run powershell command at SharePoint 2010 server

Issue:
Some time you might be getting the following error message while running the powershell command at SharePoint 2010 server.
The term "" is not recognized as the name of cmdlet, function, script file, or operable program....
Resolution:
Run the following command:
add-pssnapin Mricosoft.SharePoint.Powershell  and then Press enter

Command to migrate Huge Library

Issue:
While migrating a huge library it might be failing for number of times. The export will fail due to huge number of files, hence unable to import it at destination site
Resolution:
Use the command in exact format as:
stsadm.exe -o export -cabsize 1024 -includeusersecurity -versions 4 -url 'https://mysite.url/oldcollection/myweb' -filename myweb.cmp

cabsize can be from 10 to 1024

Unable to run few scripts at one of a app server

Issue: 
While doing the deployment, I was unable to run few scripts at one of a app server and found error as could not locate to http://... site. The event error was "An exception occurred when trying to issue security token: Could not connect to http://localhost:32843/SecurityTokenServiceApplication/securitytoken.svc. TCP error code 10061: No connection could be made because the target machine actively refused it ::1:32843." with error ID 8306 and in ULS the similar error was available.
Resolution:
1) We found that the SharePoint Web Services pool was deleted or unavailable at that app server.
2) We created the SharePoint Web Services pool through following command:
$Type = [System.Type]::GetType("Microsoft.SharePoint.Administration.SPIisWebServiceSettings, Microsoft.SharePoint, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c")
$Instance = $Type::Default
$Method = $Type.GetMethod("ProvisionLocal", "Instance, NonPublic", $null, @(), $null)
$Method.Invoke($Instance, $null)
$Method = $Type.GetMethod("Provision", "Instance, Public", $null, @(), $null)
$Method.Invoke($Instance, $null)
3)To get the Service Applications registered, execute the following script:
Get-SPServiceApplication | ForEach-Object {$_.Provision()} 
4) Start the SharePoint Web services application pool

MOSS MA not found in UPS

Issue:
Getting error as "MOSS MA not found." while creating sync connection in SharePoint 2010 user profile service.
Resolution:
start the following services through service console at that service/app server
Forefront Identity Manager Service
ForeFront Identity Manager Synchronization Service

Secure Store Service in SharePoint 2010

Secure Store Service:
The Secure Store Service is an authorization service that runs on an application server. The Secure Store Service provides a database that is used to store credentials. These credentials usually consist of a user identity and password, but can also contain other fields that you define. For example, SharePoint Server 2010 can use the secure store database to store and retrieve credentials for access to external data sources.
Secure store used for following scenarios:
Excel services,Visio services, Performance point services, PowerPivot for SharePoint 2010, BCS.
Backup the SSS DB once it is newly created and after every generating of new encryption key.

SSA creation:
Create a new service account --> Register the account in Configured Managed account in Central admin --> Recommend is not to set for Automatic password change --> Start the SSS service through "Manage services on server" central admin -->  Application Management section, click Manage service applications --> New -->  click SSS --> Enter the name of of SSA --> Enter the SQL server name and the DB name  --> Enter the name of new application pool --> Select configurable

Generate new on Encrption key:
Open the SSA --> click on Generate New Key under Ker management --> On the Generate New Key page, type a pass phrase string in the Pass Phrase box, and type the same string in the Confirm Pass Phrase box.

A target application is a collection of information that maps a user or users to a set of encrypted credentials stored in the Secure Store database.Storing credentials in Secure Store is accomplished by using a Secure Store target application. A target application maps the credentials of a user, group, or claim to a set of encrypted credentials stored in the Secure Store database. After a target application is created, you can associate it with an external content type or application model, or use it with a Business Intelligence Service Application such as Excel Services or Visio Services to provide access to an external data source. When a SharePoint Server 2010 service application calls the target application, Secure Store confirms that the user making the request is an authorized user of the target application and then retrieves the encrypted credentials. The credentials are then used on the user’s behalf by the SharePoint Server 2010 service application.

Create target application:
Manage service application--> Click SSA --> Manage Target application --> New --> Target Application ID --> enter the a unique string --> Enter the test string in Display name --> Enter an email ID -->use default page/custom page/None --> Select Group or Individual from Target Application Type drop down --> Next --> Specify the credential fields for your Secure Store Target Application --> Add two listed fields -->Specify the membership settings.

User profile sync service stuck on running in CA

Issue:

In Central admin while starting the user profile sync service might stuck on running/stopping. Rebooting that server might not resolve that issue.

Resolution:

Open the Powershell window --> Get-SPServiceInstance --> Once you get the list of GUID, then note the GUID of that service application --> Run Stop-SPServiceInstance --> Start that service through Central admin(services at server).

Unable to restore list libraries from SharePoint 2010 recyclebin

Issue: We recognized a strange issue where SharePoint 2010 recycle bin doesn't allow to restore list and libraries. Different admins were getting different error message in ULS logs.
Resolution: We just increased the list throttling at web app level and it resolved my issue. Hope it would help you as well

"License Expired" error in search result of SharePoint 2007

In SharePoint 2007 we may get the error as "License Expired" in search result. There could be number of different errors, but the common one are as below:

1) We may get this type of error if we didn't run the PS configuration wizard after the installation of language pack.
2) Some time after installing SP2 in SharePoint 2007, but SP3 installation will remove this issue/error.
3) Upgrade from SharePoint 2007 Standard to Enterprise.
4) If we are using the Express version of Search and not using the SQL install that is included in the install.  Use another SQL instance it thinks that we are using multiple servers and that is not allowed for the Express version. Use of SQL 2005 Standard seems to be the culprit and installing in Advanced mode, must use Basic.

Issue while SharePoint servers in WAN network

There are few known issues if SharePoint servers are in WAN network:
1) Site performance issue.
2) Search crawl issue.
3) Crawling data will be overlap.
4) Server we be unable to join into farm through PSConfig Wizard.
5) Unable to remove server from farm.
6) Deployment of solution will be stuck in deploying state.

Site Performance

Site performance can be caused due to following issues:
1) High Memory usage of a process in web servers/app server.
2) Database size.
3) Timer Job issue with any of a SharePoint server.
4) Network issue with any SharePoint server.
5) If any backup or restore is running at that moment. 6) If servers are in WAN network

PowerShell for Service Applications

Noun	Windows PowerShell Commands
SPService	Install-SPService
SPServiceInstance	Get-SPServiceInstance
	Start-SPServiceInstance
	Stop-SPServiceInstance
SPServiceApplication	Get-SPServiceApplication
	Publish-SPServiceApplication
	Remove-SPServiceApplication
	Set-SPServiceApplication
	Unpublish-SPServiceApplication
SPServiceApplicationProxy	Get-SPServiceApplicationProxy
	Remove-SPServiceApplicationProxy
SPIisWebServiceApplicationPool	Get-SPServiceApplicationPool
	New-SPServiceApplicationPool
	Remove-SPServiceApplicationPool
	Set-SPServiceApplicationPool

List of running jobs in SharePoint 2010 through PowerShell

# Get current date

$date = Get-Date

# Show current date

Write-Host "Looking for running jobs with a Last Run Time of greater than or equal to" $date

# Get all Timer jobs and iterate

Get-SPTimerJob | ForEach-Object {

  # Get last run time for job

  $lastRunTime = $_.LastRunTime

  # If run time is greater than/equal to write it out

  if ($lastRunTime -ge $date)

  {

     Write-Host $_.Name", last run at" $_.LastRunTime

  }

}

If you want to include a bit of history, like number of jobs run in the last five minutes, just use this for your $date variable:

$date =  (Get-Date).AddMinutes(-5)