Archive

Archive for February, 2013

TCP/IP Ports of SharePoint 2013

February 21, 2013 17 comments

Hi fellow SharePoint lovers!
(Find the 2016 version here)

Have you ever wondered? What ports do I need to open? Why can’t the web server access the Databases…what does that event mean? For example in SharePoint 2010 we had the ‘Cannot connect to SQL Server – Event 3355‘, perhaps you need to know simply for the docmentation you want to leave behind?
Wonder no more. I have here tried to compile a complete list of all the ports used. Most are configured by SharePoint but some needs to be manualy configured and it all depends on hw you have installed and configured your farm in the first Place.

headerx

I hope that the list will be of use! Please let me know if I have missed anything related, however remote…

List of ports used by SharePoint 2013 and its related services.
Reference links at the end.

Protocol Port Usage Comment
TCP 80 http Client to SharePoint web server traffic
(SharePoint – Office Web Apps communication)
TCP 443 https/ssl Encrypted client to SharePoint web server traffic
(Encrypted SharePoint – Office Web Apps communication)
TCP 1433 SQL Server default communication port. May be configured to use custom port for increased security
UDP 1434 SQL Server default port used to establish connection May be configured to use custom port for increased security
TCP 445 SQL Server using named pipes When SQL Server is configured to listen for incoming client connections by using named pipes over a NetBIOS session, SQL Server communicates over TCP port 445
TCP 25 SMTP for e-mail integration Cannot be configured
TCP 16500-16519 Ports used by the search index component Intra-farm only
Inbound rule Added to Windows firewall by SharePoint
TCP 22233-22236 Ports required for the AppFabric Caching Service Distributed Cache…
TCP 808 Search – Query processing component
Windows Communication Foundation communication
Search – Query processing component
WCF
TCP 32843 Communication between Web servers and service applications http (default) To use custom port, see references section
Inbound rule Added to Windows firewall by SharePoint
TCP 32844 Communication between Web servers and service applications https
Inbound rule Added to Windows firewall by SharePoint
TCP 32845 net.tcp binding: TCP 32845 (only if a third party has implemented this option for a service application)  Custom Service Applications
Inbound rule Added to Windows firewall by SharePoint
TCP 32846 Microsoft SharePoint Foundation User Code Service (for sandbox solutions)  Inbound on all Web Servers
Inbound rule Added to Windows firewall by SharePoint
Outbound on all Web and App servers with service enabled.
TCP 5725 User Profile Synchronization Service(FIM) Synchronizing profiles between SharePoint 2013 and Active Directory Domain Services (AD DS) on the server that runs the Forefront Identity Management agent
TCP + UDP 389 User Profile Synchronization Service(FIM) LDAP Service
TCP + UDP 88 User Profile Synchronization Service(FIM) Kerberos
TCP + UDP 53 User Profile Synchronization Service(FIM) DNS
UDP 464 User Profile Service(FIM) Kerberos change password
TCP 809 Office Web Apps Intra-farm Office Web Apps communication.

References:

Plan security hardening for SharePoint 2013
http://technet.microsoft.com/en-us/library/cc262849.aspx

Configure SQL Server security for SharePoint 2013 environments
http://technet.microsoft.com/en-us/library/ff607733.aspx#proc1

Blocking the standard SQL Server ports
http://technet.microsoft.com/en-us/library/cc262849.aspx#BlockingSQL

Service application communication
http://technet.microsoft.com/en-us/library/cc262849.aspx#ServiceApp

User Profile service hardening requirements
http://technet.microsoft.com/en-us/library/cc262849.aspx#UserProfile

Set-SPServiceHostConfig
http://technet.microsoft.com/en-us/library/ff607922.aspx

Get-SPServiceHostConfig
http://technet.microsoft.com/en-us/library/ff607794.aspx

TCP/IP Communications (Windows Server AppFabric Caching)
http://msdn.microsoft.com/en-us/library/ee790914(v=azure.10).aspx


___________________________________________________________________________________________________

Enjoy!

Regards

Twitter | Technet Profile | LinkedIn

Enterprise Edition of SharePoint Server 2013 – what’s in it?

February 11, 2013 1 comment

Why get the Enterprise edition of SharePoint Server 2013?

That is a question you should ask yourself at the beginning of every new SharePoint Project where you are planning to set up a new farm. Depending on what features and functionality you are planning to use, the editions will offer you a different solution.
Obviously, the Enterprise edition has a bigger prisetag, but if so only one of the features is what you or your customer is looking for, you could end up saving money by using a built in feature instead of developing your own.
Say that you only need one of the Enterprise features and you end up getting the Enterprise license, you get the functionality you was looking for, but in addition, you will have all the other Enterprise features available for use at a later time. The odds tell us that the farm will evolve and new functionality will be asked for.

Note: The complete list of all features in all editions of SHarePoint 2013 can be found here: SharePoint 2013 feature comparison chart all editions

The top 10 lost of features that make customers buy Enterprise edition, at least from my experience (feedback on this is welcomed and will be considered for implementation)

1 InfoPath Forms Services
2 Excel Services
3 PowerPivot
4 PerformancePoint Services
5 Power View
6 ScoreCards and DashBoards
7 Visio Services
8 Content Search Web Part
9 Analytics Plattform
10 Host Named Site Collections

Enough with the planning and strategy/sales/aquisitions dravel…lets dive into the features!

The ‘shortlist’ of ENT features looks like this, these are the features that you DO NOT get unless you have the Enterprise edition:

SharePoint Server 2013 Enterprise Edition feature Title
Short description 

Link to feature list

References, links

Developer – Access Services
Build web databases and publish them to a SharePoint site. SharePoint visitors can use your database application in a web browser by using SharePoint permissions to determine who can see what. And you can start with a template so that you can start collaborating immediately.
Access Services MSDN: What’s new in Access 2013
Habanero Consulting: Access Services in SharePoint 2013
Developer – BCS – Rich Client Integration
Business Connectivity Services (BCS) uses a complimentary client and server-side architecture that allows for Office clients, such as Outlook and Excel, to work directly with external data exposed to SharePoint through external content types. Learn more about Business Connectivity Services Client Runtime.
(Not available to SharePoint Online customers)
BCS:   Rich Client Integration MSDN: BCS client object model
Developer – BCS – Tenant-level external data log
Tenant-level external data logging allows for logging of transactions that affect specific SharePoint tenancies.
BCS:   Tenant-level external data log N/A
Developer – Custom Site Definitions
SharePoint Server 2013 customers can create their own site definitions that customize and extend standard SharePoint site templates.
(Not available to SharePoint Online customers)
Custom   Site Definitions MSDN: Overview of Creating Custom Site Definitions
Developer – Custom Site Provisioning
SharePoint Server 2013 customers get a quick and easy way for users to make their site requests and to start using their sites quickly.
(Documentation states that this is Not available to SharePoint Online customers, but it is and it is available from the SharePoint administration, settings, ‘Start a site’.)
Custom   Site Provisioning Steve Paeschka(MS): Configuring Self Service Site Creation in SharePoint 2013
Navantis:  Self-Service Site Creation in SharePoint 2013–Are the Changes Enough to Make this Feature Viable in the Enterprise?
Developer – InfoPath Forms Services
Forms Service provides a Web browser form-filling experience in SharePoint, based on form templates that are designed in InfoPath.
InfoPath   Forms Services MSDN: InfoPath Forms Services
IT Pro – Analytics Plattform
SharePoint Server 2013 customers can use the Analytics Platform, which replaces the Web Analytics service application, to help identify and surface the content that users consider to be the most useful and relevant.
(Not available to SharePoint Online customers)
Analytics   Platform Analytics Platform
IT Pro – Improved Self-Service Site Creation
SharePoint Server 2013 customers can use self-service site creation to configure things such as: whether to use a custom form to create the site, whether to create a subweb or site collection, what path should be used when the site collection is created, and whether to ask or require that a site policy be selected when the site is created.
Improved   Self-Service Site Creation Steve Paeschka(MS): Configuring Self Service Site Creation in SharePoint 2013
Navantis: Self-Service Site Creation in SharePoint 2013–Are the Changes Enough to Make this Feature Viable in the Enterprise?
Content – eDiscovery
Electronic Discovery, or eDiscovery, features   allow organizations to identify, hold, search, and export content from Exchange mailboxes, SharePoint sites, and file shares to support case management in addition to preservation and compliance. Learn more about.
eDiscovery Office: Planning and managing eDiscovery cases
Content – Preservation hold library
Content that is placed on hold is preserved, but users can still change it. The state of the content at the time of preservation is recorded. If a user changes the content or even deletes it, the item is retained at the time of deletion and the original, preserved version is still available.
Preservation   hold library TechNet: In-place holds
Office: Placing content sources on hold
Web Content Management – Video Search
An Asset Library is pre-configured to use special features that help you manage rich media assets, such as image, audio, and video files.
Video   Search Office: Setting up an Asset Library to store image, audio, or video files
Jasper Oosterveld: SharePoint 2013 – The new and improved asset library
TechNet: Digital asset libraries
Web Content Management – Catalog
A catalog is a library or list that is shared across other sites and site collections.
(Not available to SharePoint Online customers)
WCM:   Catalog TechNet: Catalog content for SharePoint authoring sites
Web Content Management – Cross Site Publishing
Cross-site publishing allows SharePoint Server 2013 customers to use one or more authoring site collections to author and store content, and one or more publishing site collections to control the design of the site and to show the content. The authoring site collection contains catalogs, such as Pages libraries and lists, which contain content that is tagged with metadata. These catalogs are indexed by the search system and made available to the publishing site collection. The publishing site collection issues queries for data that was indexed and shows it on web pages by using Web Parts that use search technology. Learn more about
(Not available to SharePoint Online customers)
WCM:   Cross-site publishing TechNet: Cross-site publishing in SharePoint Server 2013
Web Content Management – Faceted Navigation
Faceted navigation help users browser for content more easily by filtering on refiners that are tied to terms in a term set. By using faceted navigation, SharePoint Server 2013 administrators can configure different refiners for different terms in a term set without having to create additional pages.
(Not available to SharePoint Online customers)
WCM:   Faceted navigation TechNet: Refiners and faceted navigation
Web Content Management – Image Renditions
Image renditions let organizations have large source images on a SharePoint Server 2013 site and also have places on a site where pages only use smaller versions.
(Not available to SharePoint Online customers)
WCM:   Image Renditions Content authoring improvements
Web Content   Management – Host Named Site Collections/Multiple Domains
SharePoint Server 2013 can create host-named site collections with the host header. Host-named site collections in SharePoint provide URL management and scalability of sites within a single web application.
(Not available to SharePoint Online customers)
WCM:   Multiple Domains TechNet: Plan for host-named site collectionsSharePoint   Blues: Host Named Site Collections and Apps Host
Web Content Management – Category/Catalog item Pages
Category pages and catalog item pages are page layouts that you can use to show structured catalog content consistently across a SharePoint Server 2013 site.
(Not available to SharePoint Online customers)
WCM:   Topic Pages TechNet: Cross-site publishing
BI/Insights – The Business Intelligence Center
The Business Intelligence Center site enables you to store data connections, workbooks, reports, scorecards, and dashboards in a central, secure location.
Business Intelligence Center TechNet: configuring Business Intelligence Center
BI/Insights – Calculated Measures and Members
When you create PivotChart reports of PivotTable reports that use data that is stored in SQL Server Analysis Services, you can create calculated measure and calculated members for that report.
Calculated Measures and Members Office: Business intelligence capabilities in Excel Services.
BI/Insights – Data Connection Library
A data connection library is a special SharePoint library that is designed to store and manage shared data connections. These can include ODC files that you create by using Excel.
Data   Connection Library TechNet: Trusted Data Connection Libraries in SharePoint Server 2013
BI/Insights – PivotTable/PivotChart
When you create a PivotChart report, a corresponding PivtoTable report is automatically created. New in Excel 2013, you do not have to display a PivotTable report on the same worksheet as its corresponding PivotChart report. You can choose to display only the PivotChart report. This capability is called “decoupled PivotTables and PivotCharts”.
Decoupled PivotTables and PivotCharts Office: PivotTables and PivotCharts
BI/Insights – Excel Services
Excel Services enables you to share workbooks with others, view and explore information in a browser window, and refresh data. Excel Services enables you to view and interact with reports, scorecards, and   dashboards in a browser window, much like you would use the Excel client. Excel Services also enables you to share all or parts of workbooks with others, and control what information is displayed in those workbooks.
Excel   Services Office: Excel Services
BI/Insights – Field List and Field Well
Excel Services enables you to open the Field List and Field Well for PivotChart reports and PivotTable reports that are viewed in a browser windows. This capability makes it easy to temporarily change the information that is displayed in a PivotChart report or a PivotTable report without having to open Excel.
Field   list and Field Support TechNet: Business intelligence capabilities in Excel Services
BI/Insights – Slicers
Slicers are a kind of filter that you can use to select one or more items to use as a filter for reports and scorecards in a worksheet. For example, suppose that you want to see sales information for different colors of items, such as shirts that your company carries. You can create a slicer that lists shirt colors, connect it to a sales report, and then use the slicer to view sales information for the colors that are selected in the slicer.
Filter   Enhancements – Slicers TechNet:  Business intelligence capabilities in Excel Services
BI/Insights – Filter Search
You can search on filter results, which makes it easy to jump to a particular item in a long list.
Filter   Search Use filters and slicers to focus on specific information
BI/Insights – PerformancePoint Services
PerformancePoint Services enables SharePoint Server 2013 customers to create interactive dashboards that display key performance indicators (KPIs) and data virtualizations in the form of scorecards, reports, and filters.
(Not available to SharePoint Online customers.)
PerformancePoint   Services PerformancePoint Services in SharePoint Server 2013 overview
BI/Insights – Dashboard Migration
With Dashboard Migration, SharePoint Server 2013 customers will be able to copy complete dashboards and dependencies. This includes the .aspx file, to other users, servers, or site collections. This feature also allows the ability to migrate single items to other environments and migrate content by using Windows PowerShell commands.
(Not available to SharePoint Online customers)
PerformancePoint   Services (PPS) Dashboard Migration TechNet: Create Dashboards by using PerformancePoint Services
BI/Insights – Power View
Power View is an add-in for Excel that enables organizations to visualize and interact with modeled data by using highly interactive visualizations, animations, and smart querying. Organizations can present insights with other through storyboard presentation capabilities. Power View is powered by BI Semantic Model and the VertiPaq engine.
Power View Office: Power View: Explore, visualize, and present your data
BI/Insights – PowerPivot
PowerPivot is an add-in that organizations can use to perform powerful data analysis and create sophisticated data models. PowerPivot also enables organizations to mash up large volumes of data from various sources, analyze data quickly, and share insights.
PowerPivot Office: PowerPivot – Powerful data analysis and data modeling in Excel
BI/Insights – Quick Explore
Quick Explore enables organizations to select a value in a PivotChart report or a PivotTable report and see additional   information about that value. For example, if you are viewing a sales report and you select a value that represents total sales amounts, you can use Quick Explore to view additional information such as sales amounts across different product categories or geographical areas.
Quick   Explore Office: What’s new in Excel 2013 – Instant data analysis
BI/Insights – Scorecards and Dashboards
A scorecard shows at a glance whether  performance is on or off target for one or more key performance indicators (KPIs). A dashboard is a collection of views that can include scorecards and other reports. Scorecards and dashboard are designed to show current performance information and are typically rendered in a site such as a SharePoint Server 2013 site.
(Not available to SharePoint Online customers)
Scorecards   & Dashboards Office: Create and use a report or a scorecard
BI/Insights – Reporting Services
When SQL Server 2012 Reporting Services is integrated with SharePoint, you can use powerful SharePoint collaboration and centralized document management features for SQL Server 2012 Reporting Services content. Reports are stored in SharePoint document libraries, alongside other reports such as Excel Services files. SharePoint permissions can be used to control access to Reporting Services content, and people are able to start Report Designer, Model Designer, and Report Builder within a document library.
SQL   Server Reporting Services (SSRS) Integrated Mode TechNet: Reporting Services Report Server (SharePoint Mode)
BI/Insights – Report Viewer Web Part
The SQL Server 2012 Reporting Services Web Part enables people to display an existing Reporting Services report in its own Web Part in a SharePoint site. If the Reporting Services report contains parameters, people can connect filters to that report using the Web Part settings.
SQL   Server Reporting Services (SSRC) Web Part TechNet: Using the Report Viewer Web Part
BI/Insights – Timeline Controls
A timeline slicer is a control that can be added to a dashboard created by using Excel. A timeline control enables people to view information for a particular period of time.
(The use of existing Timeline Controls is available to SharePoint Online customers)
Timeline   Slicer Office: Business intelligence capabilities in Excel Services
BI/Insights – Visio Services
Visio Services is a service application that lets users share and view Microsoft Visio Drawing (*.vsdx) and Visio 2010 Web drawing (*.vdw) files.
Visio   Services TechNet: Visio Services in SharePoint Server 2013
Search – Content Search Web Part
The Content Search Web Part is a SharePoint Server 2013 feature that displays content that was crawled and added to an organization’s search index. It is a very powerful and versatile Web Part, especially when it is used in combination with managed navigation and category pages. The Content Search Web Part allows you to select a result source. This makes it very easy to specify which content should be searched. You can also use Keyword Query Language to add more filters and search terms to the query in this Web Part.
(Not available to SharePoint Online customers)
Content   Search Web Part MSDN: Content Search Web Part in SharePoint 2013
TechNet: Configure Search Web Parts in SharePoint Server 2013
Search – custom entity extraction
SharePoint Server 2013 administrators can create and deploy custom entity extraction dictionaries to configure the search system to look for specific words or phrases (entities) in unstructured content. The extracted entities are stored in separate managed properties, and you can use them to improve your organization’s search experience, for example by creating refiners.
(Not available to SharePoint Online customers)
Custom   entity extraction TechNet: Create and deploy custom entity extractors
Search – Content Enrichment
Developers can call out to an external content enrichment web service to change the managed properties of crawled items before they are indexed. The ability to change managed properties for items during content processing is helpful for tasks such as data cleansing, entity extraction, classification, and tagging.
(Not available to SharePoint Online   customers)
Extensible   content processing MSDN: Custom content processing with the Content Enrichment web service callout
Search – Query rules advanced
In this query   rule, specify conditions and correlated actions. When a query meets the conditions in a query rule, the search system performs the actions specified
in the rule.
Query   rules—advanced actions Steve Peschka: Query Rule Conditions in SharePoint 2013 Search
SharePoint ITPro blog: What happened to Best Bets? Introducing Query Rules
Search – Results formatted for Video
A targeted search experience that displays results that are custom filtered and formatted for video content.
Search   vertical: “Video” TechNet: What’s new in search in SharePoint Server 2013

I hope that this compilation of facts will help you in some way, I was looking for a similar list and I know I have many times before with 2003, 2007 and 2010.


___________________________________________________________________________________________________

Enjoy!

Regards

Twitter | Technet Profile | LinkedIn