Creating a SharePoint 2010 Web Part That Can Read and Write Data to an External Data Source

Learn how to use Microsoft Visual Studio 2010 to create a Visual Web Part that uses a Microsoft Business Connectivity Services (BCS) external content type in Microsoft SharePoint Server 2010 to read and write data to the AdventureWorks sample database.

http://msdn.microsoft.com/en-us/library/ff769953.aspx

Configuring SharePoint 2010 Kerberos with BI Scenarios

Newly published whitepaper.This document gives you information that will help you understand the concepts of identity in Microsoft SharePoint 2010 Products, how Kerberos authentication plays a very important role in authentication and delegation scenarios, and the situations where Kerberos authentication should be used or may be required in solution designs.The document also shows how to configure Kerberos authentication end-to-end within your environment, including scenarios that use various service applications in Microsoft SharePoint Server. Additional tools and resources are described to help you test and validate Kerberos configuration. The “Step-by-Step Configuration” sections of this document cover the following scenarios for SharePoint Server 2010.

• Scenario 1: Core Configuration
• Scenario 2: Kerberos Authentication for SQL OLTP
• Scenario 3: Identity Delegation for SQL Analysis Services
• Scenario 4: Identity Delegation for SQL Reporting Services
• Scenario 5: Identity Delegation for Excel Services
• Scenario 6: Identity Delegation for Power Pivot for SharePoint
• Scenario 7: Identity Delegation for Visio Services
• Scenario 8: Identity Delegation for Performance Point Services
• Scenario 9: Identity Delegation for Business Connectivity Services

The download URL is:http://download.microsoft.com/download/B/B/F/BBF0C6F3-6E36-4979-8C43-DE165AD7AE34/SP2010 Kerberos Guide.docx

SSAS Reporting Action Sharepoint integrated mode

Action Target: Cell

Target Object: All cells

Server name: <servername>/sites/bi

Report Path: _layouts/ReportServer/RSViewerPage.aspx?rv:RelativeReportUrl=/sites/bi/documents/<reportname>.rdl

Parameter Name: <name>

Parameter Value: UrlEscapeFragment([Dim].[MemberName].CurrentMember.UniqueName)

Report Deployment Properties

For Sharepoint 2010, Reporting Services 2008 R2, here is a BIDS sample deployment properties to a BI Center.

TargetDataSourceFolder = http://<servername>/Data%20Connections%20for%20PerformancePoint

TargetReportFolder = http://<servername>/Documents

TargetReportPartFolder = http://<servername>/Documents

TargetServerURL = http://<servername&gt;

Local accounts should only be used in stand alone mode.

if you have run into this error message when configuring SharePoint 2010, there is a workaround.

New-SPConfigurationDatabase allows you to specify no domain credentials for the farm. To execute this command launch the SharePoint 2010 management shell.

Be sure you enter the correct Farm Credentials (machinename/user). Then run the configuration wizard again and you’ll see that the server has already joined the farm.

WCF Fix for SharePoint 2010

Windows Server 2008/Vista:
http://go.microsoft.com/fwlink/?linkID=160770
Windows Server 2008 R2/Windows 7:
http://go.microsoft.com/fwlink/?LinkID=166231

SharePoint 2007 on Windows Server 2008 R2

the trick is you need a slipstream version of SP2.

Here is how to do it

RB 2.0 Access in Sharepoint integrated mode

On a SharePoint integrated mode report server, Report Builder 1.0 or Report Builder 2.0 access is granted to SharePoint users who have either Contribute or Full Control permission levels.

How to add a Document Icon to a Sharepoint Library

Here are the steps to add an icon for .pdf files.  Change as appropriate for other file types.

1. Save the image you wish to see as the PDF document icon to "\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\Template\Images\pdf.gif" – Images should be 15×15 pixels in size. (However the 17 x 17 icon from http://www.adobe.com/misc/linking.html works fine)
2. Edit  "\Program Files\Common Files\Microsoft Shared\Web server extensions\12\Template\Xml\DOCICON.XML"
3. Add the following line <Mapping Key="pdf" Value="pdf.gif"/>
4. run iisreset

Add Advanced Search to a Top Level Team Site in MOSS 2007

Been messing around with search now that PPS is a MOSS e-cal feature. Still got a ways to go to guru status, but this little nugget is most useful. http://blog.funknstyle.com/?p=578

Basically, you create a Search Center, get the URL for the advanced search page, and paste it into the Custom Scopes of the Top Level site search settings.