Web Part
|
Foundation
|
Server 2010 Standard
|
Server 2010 Enterprise
|
Description
|
Business Data Actions
|
|
|
*
|
Displays a list of actions from Business Data Connectivity.
|
Business Data Connectivity Filter
|
|
|
*
|
Filters the contents of Web Parts using a list of values from the Business Data Connectivity.
|
Business Data Item
|
|
|
*
|
Displays one item from a data source in Business Data Connectivity.
|
Business Data Item Builder
|
|
|
*
|
Creates a Business Data item from parameters in the query string and provides it to other Web Parts.
|
Business Data List
|
|
|
*
|
Displays a list of items from a data source in Business Data Connectivity.
|
Business Data Related List
|
|
|
*
|
Displays a list of items related to one or more parent items from a data source in Business Data Connectivity.
|
Chart Web part
|
|
|
*
|
Helps you to visualize your data on SharePoint sites and portals. (MossChartWebPart)
|
Excel Web Access
|
|
|
*
|
Use the Excel Web Access Web Part to interact with an Excel workbook as a Web page. (Excel.WebUI)
|
Indicator Details
|
|
|
*
|
Displays the details of a single Status Indicator. Status Indicators display an important measure for an organization and may be obtained from other data sources including SharePoint lists, Excel workbooks, and SQL Server 2005 Analysis Services KPIs.
|
Status List
|
|
|
*
|
Shows a list of Status Indicators. Status Indicators display important measures for your organization, and show how your organization is performing with respect to your goals. (KPI List Web Part)
|
Visio Web Access
|
|
|
*
|
Enables viewing and refreshing of published Visio diagrams.
|
Categories
|
|
*
|
*
|
Displays categories from the Site Directory. (CategoryWebPart)
|
Relevant Documents
|
*
|
*
|
*
|
Displays documents that are relevant to the current user.
|
RSS Viewer
|
|
*
|
*
|
Displays an RSS feed.
|
Table Of Contents
|
|
|
*
|
Displays the navigation hierarchy of your site.
|
Site Aggregator
|
|
*
|
*
|
Displays sites of your choice. (siteFramer)
|
Sites in Category
|
|
*
|
*
|
Displays sites from the Site Directory within a specific category. (CategoryResults)
|
Table of Contents
|
|
*
|
*
|
Displays the navigation hierarchy of your site.
|
Web Analytics web part
|
|
*
|
*
|
Displays the most viewed content, most frequent search queries from a site, or most frequent search queries from a search center. (WhatsPopular)
|
WSRP Viewer
|
|
|
*
|
Displays portlets from web sites using WSRP 1.1. (WSRPConsumer)
|
XML Viewer
|
*
|
*
|
*
|
Transforms XML data using XSL and shows the results.
|
Choice Filter
|
|
|
*
|
Filters the contents of Web Parts using a list of values entered by the page author. (AuthoredListFilter)
|
Current User Filter
|
|
|
*
|
Filters the contents of Web Parts by using properties of the current user.
|
Date Filter
|
|
|
*
|
Filter the contents of Web Parts by allowing users to enter or pick a date.
|
Filter Actions
|
|
|
*
|
Use the Filter Actions Web Part when you have two or more filter Web Parts on one Web Part Page, and you want to synchronize the display of the filter results.
|
Page Field Filter
|
|
|
*
|
Filters the contents of Web Parts using information about the current page. (PageContextFilter)
|
Query String (URL) Filter
|
|
|
*
|
Filters the contents of Web Parts using values passed via the query string.
|
SharePoint List Filter
|
|
|
*
|
Filters the contents of Web Parts by using a list of values.
|
SQL Server Analysis Services Filter
|
|
|
*
|
Filters the contents of Web Parts using a list of values from SQL Server Analysis Services cubes. (OlapFilter)
|
Text Filter
|
|
|
*
|
Filters the contents of Web Parts by allowing users to enter a text value.
|
HTML Form Web Part
|
*
|
*
|
*
|
Connects simple form controls to other web parts. (MSSimpleForm)
|
InfoPath Form Web Part
|
|
|
*
|
Use this Web Part to display an InfoPath browser-enabled form.
|
Content Editor
|
*
|
*
|
*
|
Allows authors to enter rich text content.
|
Image Viewer
|
*
|
*
|
*
|
Displays a specified image. (MSImage)
|
Page Viewer
|
*
|
*
|
*
|
Displays another Web page on this Web Page. The other Web page is presented in an iFrame. (MSPageViewer)
|
Picture Library Slideshow Web Part
|
*
|
*
|
*
|
Use to display a slideshow of images and photos from a picture library. (MSPictureLibrarySlideshow)
|
Silverlight Web Part
|
*
|
*
|
*
|
A web part to display a Silverlight application.
|
My Calendar
|
|
*
|
*
|
Displays your calendar using Outlook Web Access for Microsoft Exchange Server 2003 or later.
|
My Contacts
|
|
*
|
*
|
Displays your contacts using Outlook Web Access for Microsoft Exchange Server 2003 or later.
|
My Inbox
|
|
*
|
x
|
Displays your inbox using Outlook Web Access for Microsoft Exchange Server 2003 or later.
|
My Mail Folder
|
|
*
|
*
|
Displays your mail folder using Outlook Web Access for Microsoft Exchange Server 2000 or later.
|
My Tasks
|
|
*
|
*
|
Displays your tasks using Outlook Web Access for Microsoft Exchange Server 2003 or later.
|
Advanced Search Box
|
|
*
|
*
|
Displays parameterized search options based on properties and combinations of words.
|
Dual Chinese Search
|
|
*
|
*
|
Used to search Dual Chinese document and items at the same time.
|
Federated Results
|
|
*
|
*
|
Displays search results from a configured location.
|
People Refinement Panel
|
|
*
|
*
|
This webpart helps the users to refine people search results
|
People Search Box
|
|
*
|
*
|
Presents a search box that allows users to search for people.
|
People Search Core Results
|
|
*
|
*
|
Displays the people search results and the properties associated with them.
|
Refinement Panel
|
|
*
|
*
|
This webpart helps the users to refine search results.
|
Related Queries
|
|
*
|
*
|
This webpart displays related queries to a user query. (QuerySuggestions)
|
Search Action Links
|
|
*
|
*
|
Displays the search action links on the search results page.
|
Search Best Bets
|
|
*
|
*
|
Displays high-confidence results on a search results page.
|
Search Box
|
|
*
|
*
|
Displays a search box that allows users to search for information.
|
Search Core Results
|
|
*
|
*
|
Displays the search results and the properties associated with them
|
Search Paging
|
|
*
|
*
|
Display links for navigating pages containing search results.
|
Search Statistics
|
|
*
|
*
|
Displays the search statistics such as the number of results shown on the current page, total number of results and time taken to perform the search.
|
Search Summary
|
|
*
|
*
|
Displays suggestions for current search query.
|
Search Visual Best Bet
|
|
|
*
|
Displays Visual Best Bet.
|
Top Federated Results
|
|
*
|
*
|
Displays the Top Federated result from the configured location. (TopAnswer)
|
Contact Details
|
|
*
|
*
|
Displays details about a contact for this page or site.
|
Note Board
|
|
*
|
*
|
Enable users to leave short, publicly-viewable notes about this page. (SocialComment)
|
Organization Browser
|
|
*
|
*
|
This Web Part displays each person in the reporting chain in an interactive view optimized for browsing organization charts. (ProfileBrowser)
|
Site Users
|
*
|
*
|
*
|
Use the Site Users Web Part to see a list of the site users and their online status.
|
User Tasks
|
*
|
*
|
*
|
Displays tasks that are assigned to the current user.
|
Tag Cloud
|
|
*
|
*
|
Displays the most popular subjects being tagged inside your organization.
|
Media Web Part
|
|
*
|
*
|
Use to embed media clips (video and audio) in a web page.
|
Content Query
|
|
*
|
*
|
Displays a dynamic view of content from your site.
|
Summary Links
|
|
*
|
*
|
Allows authors to create links that can be grouped and styled.
|
List View Web Part
|
*
|
*
|
*
|
Use to display a view of a list or document library.
|
Blog Year Archive
|
*
|
*
|
*
|
Displays the blog archive of the previous three years.
|
Document Set Contents
|
|
*
|
*
|
Displays the contents of a Document Set.
|
Document Set Properties
|
|
*
|
*
|
Displays the properties of the Document Set.
|
Enter a Document ID
|
|
*
|
*
|
Finds a document by its Document ID
|
My Links
|
|
*
|
*
|
Displays a list of a users ‘My Links’
|
What’s New
|
*
|
*
|
*
|
This Web Part shows new information from specified lists and libraries.
|
Whereabouts
|
*
|
*
|
*
|
Use to display Whereabouts information
|
PerformancePoint
|
|
|
|
|
PerformancePoint Filter
|
|
|
*
|
This web part displays PerformancePoint filters. Filters may be linked to other web parts to provide an interactive dashboard experience. Filter types include lists and trees based on a variety of data sources.
|
PerformancePoint Report
|
|
|
*
|
This web part displays PerformancePoint reports. Reports may be linked to other web parts to create an interactive dashboard experience. Report types include: Analytic charts & grids, Strategy Maps, Excel Services, Reporting Services, Predictive Trend charts, and web pages.
|
PerformancePoint Scorecard
|
|
|
*
|
This web part displays a PerformancePoint scorecard. Scorecards may be linked to other web parts, such as filters and reports, to create an interactive dashboard experience.
|
PerformancePoint Stack Selector
|
|
|
*
|
This web part displays a PerformancePoint Stack Selector. All PerformancePoint web parts, such as filters and reports, contained in the same zone will be automatically stacked and selectable using this web part.
|
SQL Server Reporting Services Report Viewer
|
|
|
*
|
Use the Report Viewer to view SQL Server Reporting Services reports. (ReportViewer) Only available with Reporting Services integration.
|
Moving MOSS 2007 SQL Databases part 3
Posted by sharepoinTony on July 27, 2010
If you haven’t seen the earlier posts on this topic: Part 1 and Part 2
D-Day has arrived, it is time to actually move my SharePoint 2007 sql databases to a different SQL Server. My previous posts touched on the research I did leading up to this event. This post will cover the actual tasks and outcome. I am writing this as I go through the process, so let’s all cross our fingers that it goes smooth.
My Plans
A summary of my plan is as follows:
Round 1
I attempted these steps and all went smoothly until I got to step 13 – Restore SSP’s from backup. The restore made it to 50 percent complete then ran into this error:
After several attempts and a grueling session of troubleshooting I found that the SQL Server Agent was not running on my ‘new’ SQL server (SQL Server 2008 R2 64-bit, running on Windows Server 2008 64-bit). The fun part was that I couldn’t get it to start. The Agent would just stop after every attempt to start it. I tried several solutions found on-line, none of which worked.
At this point my weekend was over and we needed the production server back online, so I did the restore BACK to the original SQL Server. SharePoint was up and running fine very quickly.
Finally, I un-installed SQL Server 2008 R2 from the new server and started over. After carefully reinstalling SQL Server 2008 R2 I no longer had any problem with the SQL Server Agent. Hurray, now will the SSP restore work? I have to wait until the next weekend to find out.
Round 2
Friday – A week has gone by and I am now preparing to walk through all of those steps again. More confident than last time perhaps, but concerned at what I might run into this time around. I will do all of the initial steps – the backups – tonight, Friday night. Saturday morning I will start the scary part, removing the SSP’s and moving everything to the new SQL Server.
Saturday – Everything went well up to the restore, again. This time the error was an Access Denied error pointing to the SharePoint backup directory. Short-story resolution: change the SQL Server account to use a Domain account, make sure that domain account had permissions to the backup folder and to the sql database files folder. I also wanted to make sure I didn’t have any more trouble getting to the backup folder so I opened it up (temporarily) to several other accounts – my ssp and app-pool users.
The SSP Restore completed successfully, with zero errors and zero warnings. Hurray!
Hold-on, the process outlined by Microsoft ends here. What about my content databases?
Searching about I found that I need to use stsadm to detach the content databases, one by one, from the SharePoint server and add the databases on the new server. So I begin this task and have no problems until I get to the Config database. It detaches fine, but then the services become disabled and the attach (setconfigdb) results in “Value cannot be null. Parameter name: str” ! What the?! Time for Microsoft Support calls.
Support helped resolve the ‘migration’ issues, however now the SSP is not working-including search, and there are several other things missing. I am told I will have to add any solutions back in, and find whatever features or web parts that might not work and fix them. Also have to open a new ticket for ‘advanced troubleshooting’ on the SSP. It has been a long Saturday.
Round 3
Sunday – Monday (ouch)
After hours on the phone and several rounds of running psconfig we were able to get a new Config db setup and restore over it to capture most of my configuration data. The SSP is a different story. We had to create a new SSP, which left me with a few more days of reconfiguring the SSP, Search, Audiences, etc. before I was “back” to normal.
Wrap-up
Posted in Commentary, Install and Configure, SharePoint 2007 | Tagged: SQL | 2 Comments »