FatalError: Cannot import site. Export / Import-SpWeb in SharePoint 2010

Error:
FatalError: Cannot import site. The exported site is based on the template STS#0 but the destination site is based on the template SPS#0. You can import sites only into sites that are based on same template as the exported site.


Import-SPWeb : Cannot import site. The exported site is based on the template STS#0 but the destination site is based on the template STS#1. You can import sites only into sites that are based on same template as the exported site.

Issue:-
In SharePoint 2010 when we use Powershell Commands to Export / Import site collections we get Site Template mismatch errors as now SP 2010 needs to have the same template for the site while importing which was used on the site exported.

In such scenarios when you have migrated from SPS 2003 -> MOSS 2007 -> SP 2010 there will be many old Site templates which are now Obsolete in SP 2010 and not available, due to which it will be very difficult to Import the site.

Resolution / Workaround:-
1. Central Admin -> Application Management -> Create Site Collection
2. During Template selection go to 'Custom' Tab -> Select Template Later.....
3. Run the Import-SpWeb command now and it should import the site collection without any issues.

As we are not selecting any template while creating a Site Collection, it automatically pics up the template which is using while importing the Site Collection.

Claims to Windows Token Service is not starting. SharePoint 2010

Issue:-
While trying to Start the "Claims to Windows Token Service" we get the error in ULS Logs.

02/03/2011 19:20:50.61 w3wp.exe (0x2714) 0x20D4 SharePoint Foundation Topology 7034 Critical An attempt to start/stop instance of service Claims to Windows Token Service on server did not succeed. Re-run the action via UI or command line on the specified server. Additional information is below. Cannot start service c2wts on computer '.'. bc9bf161-6959-4d80-8410-8b676810da70

Resolution:-
HKEY_USERS\.DEFAULT\SOFTWARE\Microsoft\Windows\CurrentVersion\WinTrust\Trust Providers\Software Publishing
Value = State
Radix= decimal
Change the value to '146944' to disable CRL checking.

FAST Search Server 2010 for SharePoint - Services not starting

Issue: After installation a fresh FAST Search Server 2010 for SharePoint (Single Node), 4 main Services were not getting started.

1. Browser Engine
2. SAM Admin
3. SAM Worker
4. QRProxy Service


Error:
Event ID: 7000
Error: 1297: A Privilege that the services requires to function properly does not exist in the service account configuration. You may use the Services Microsoft Management Console (MMC) snap-in (services.msc) and the Local Security Settings MMC snap-in (secpol.msc) to view the serivce configuration and the account configuration.

Troubleshoot:
1. Tried to the Article http://support.microsoft.com/kb/982261
2. That policy was already in place.
3. Checked the group membership of FASTSearchAdministrators group. Fast service account was already added.
4. Added the machine account domain\machine to the group, still did not work.
5. Checked if the user was able to make changes, add/delete items from registry key.

Resolution:
1. Added the Fast Service account domain\fastsrv to the local Group Policy "Increase a process working set"
http://technet.microsoft.com/en-us/library/dd349804(WS.10).aspx#BKMK_26

The Difference Between MOSS 2007 and WSS 3.0

It always astounds me what Microsoft are willing to bundle with their software, Analysis Services or SSIS (SQL Server Integration Services) with SQL Server for example! They haven't stopped, they bundle Windows Sharepoint Services with Windows Server 2003, with is basically a fully functional SharePoint Server, however they still have SharePoint Server 2007 as a product. So what are the differences? At first glance it doesn't appear to be much, however for tight integration into the enterprise, it seems that MOSS 2007 (Microsoft Office SharePoint Server) is a must! I will highlight the most interesting bits that MOSS 2007 has over and above WSS 3.0 (Windows Sharepoint Services) :
User Profiles support - Allows each user to store profile information
Site Manager - Manage Navigation, Security and look and feel with drag an drop functionality
Enterprise Search Tools - numerous tools to search Sharepoint Sites and Portals across entire enterprises
Business Data Catalog - The Business Data Catalog (BDC) tightly integrates external data, providing access to external data residing within other business applications, and enabling the display of, and interaction with external data
Business data search - Search data residing in your business applications using the BDC (See Above)
Business Data Web Parts - Used for viewing lists, entities, and related information retrieved through the Business Data Catalog
Business document workflow support - Automate document review, approval, signature collection, and issue tracking using workflow applications
Retention and auditing policies - Allows customized information management policies to control retention period, expiration, and auditing
Browser-based forms - Integration with InfoPath, allows integration on to SharePoint of created forms and surveys.
Integrated, flexible spreadsheet publishing - Allows information workers to easily choose what they want to share with others and determine how others can interact with published spreadsheets.
Share, manage, and control spreadsheets - Provides access to spreadsheet data and analysis through server-calculated, interactive spreadsheets from a Web browser. Can help to protect any sensitive or proprietary information embedded in documents, such as financial models, and audits their usage.
Web-based business intelligence using Excel Services - Allows spreadsheets to be broadly and easily shared. Fully interactive, data-bound spreadsheets including charts, tables, and PivotTable views can be created as part of a portal, dashboard, or business scorecard.
Data Connection Libraries - Document Libraries storing ODCs (Office Data Connections), Making one single location for all data connections.
Business Data actions - Easily create actions that open Web pages, display the user interfaces of other business applications, launch InfoPath forms, and perform other common tasks.
Integrated business intelligence dashboards - Rich, interactive BI dashboards that assemble and display business information from disparate sources by using built-in Web parts, Excel spreadsheets, Reporting Services, or a collection of business data connectivity Web Parts.
Report Center - Provides consistent management of reports, spreadsheets, and data connections.
Key performance indicators - A KPI web Part can connect to Analysis Services, Excel Spreadsheets, SharePoint Lists, or manual entered data.
Notification service - Improved allowing workflow users to receive emails by default, and improved triggering and filtering
Single Sign-On (SSO) - Allows the User to log onto a variety of applications with a single user name and password, therefore integrating back office applications, and helps pre-population with integration to the Profile part of MOSS 2007.
Social Networking Part - Connect to Public My Site pages to help establish connections between colleagues with common interests
Personal Site Support - Allows Users to create Personal Web Sites
Content syndication - Use RSS feeds to syndicate content managed in a portal site.

This is just a few of the extras you get in MOSS 2007, and I have highlighted those that are more angled to Business Intelligence! As for the cost, you can find that here: (In USD$ I am afraid) http://office.microsoft.com/en-us/sharepointserver...

KB article 2345304 SharePoint Security update

Issue: SharePoint is down after applying KB 2345304
Env: Mostly seen in WSS 3.0 FARM
Error: Cannot connect to Config db or PSConfig fails with Access Denied errors or while file uploads in the Document library we get Access Denied errors.

Resolution:
1. Go to SQL management studio expand the Databases
2. Go to the properties of SharePoint Configdb -> Options -> Auto Close parameter set to "False".

When this security update is applied, the SQL databases are closed and for that we need to change the "Auto Close" option to "False" from "True"

Do the same for all the SharePoint Databases in use and then run the PSConfig wizard.

Your client does not support opening this list with Windows Explorer

Issue:- SharePoint Windows Explorer View not working on IE 8
Env:- Windows Server 2008, Windows 7
Error:- "Your client does not support opening this list with Windows Explorer"

Resolution / Workaround:
1. On Windows Server 2008 Install "Desktop Experience" Feature. This will install the "Web Client service. Keep it to Automatic and make sure its Started.
2. Use IE 8 32 bit version and browse the SP site and check the explorer view. By Default it will open IE 8 64 bit version which continues to give the error regardless the "Web Client" service being started.

Note:
=======
Note sure about the difference between this behaviour in IE 8 32 and 64 bit versions. But on both Windows server 2008 and Windows 7, both the versions are installed by default.

Report Builder Report Download 401 Unauthorized Error

Environment:-
Server1 -- SQL services, SQL reporting services all 2008 R2 64bit, SharePoint installation 2010 and Reporting services add-in

Server2 -- SharePoint installation with Central Administration hosted 2010, Reporting services add-in .

Issue:- While downloading Report Builder report Externally (from Internet) it does not download and gives a "Cannot Retrieve error"

Error:- PLATFORM VERSION INFOWindows : 5.0.2195.262144 (Win32NT)
Common Language Runtime : 2.0.50727.42
System.Deployment.dll : 2.0.50727.42 (RTM.050727-4200)
mscorwks.dll : 2.0.50727.42 (RTM.050727-4200)
dfdll.dll : 2.0.50727.42 (RTM.050727-4200)
dfshim.dll : 2.0.50727.42 (RTM.050727-4200)

SOURCESDeployment url :
http://URL/ReportServer/ReportBuilder/ReportBuilder.applicationERROR SUMMARYBelow is a summary of the errors, details of these errors are listed later in the log.
* Activation of http://URL/ReportServer/ReportBuilder/ReportBuilder.application resulted in exception. Following failure messages were detected:
+ Downloading http://URL/ReportServer/ReportBuilder/ReportBuilder.application did not succeed.
+ The remote server returned an error: (401) Unauthorized.
COMPONENT STORE TRANSACTION FAILURE SUMMARYNo transaction error was detected.WARNINGSThere were no warnings during this operation.OPERATION PROGRESS STATUS* [08/05/2008 09:33:39] :
Activation of http://URL/ReportServer/ReportBuilder/ReportBuilder.application has started.

Tried and tested
So many blogs and articles online on this issue that I have lost count how many read and how many times I might have deleted and recreated web applications. As most of the articles and blogs suggest to enable Annonymous Access on the ReportBuilder Virtual directory in IIS, but SQL 2008 reporting services does not create this Virtual directory in IIS so how do we give annonymous access??? Broken my head on this issue with my colleagues and lot of hours reading long msdn and technet articles but all in vain...

Resolution:-
1. Browse to Central Administration of SP 2010
2. Application Management
3. Manage Web applications -> Select the Web Application which will be used for SSRS
4. Select Authentication Providers -> Select "Enable Annonymous Access" checkbox
5. Click Ok.

This will setup the most required annonymous access for the virtual directories in IIS and Report builder will start downloading from Internet also. Hope this helps to many out there. Also to mention our SP site was also configured with Kerberos and SSL using a Hostheader.