Thursday, January 16, 2014

Configuring the Excel Services Service Application in SharePoint 2013

Configuring the Excel Services Service Application in SharePoint 2013

The following steps describe how to create the Excel Services service application

1.    Log onto your SharePoint box as the Farm account.
2.    Open SharePoint Central Administration, and then select Manage service applications under the Application Management heading.
3.    From the Manage service applications screen, click the New button in the Ribbon. From the menu, select Excel Services Application.
                  

4.    For Name, enter Excel Services.
              

5.    Scroll down to Application Pool and select “Use existing application pool.”
6.    From the drop-down, select Default SharePoint Service App Pool.
7.    Leave the default of “Add this service application’s proxy to the farm’s default proxy list.”
8.    Click OK at the bottom of the page.

 To start the service application

10. From the left-hand menu, click Application Management.
11. Under the Service Applications section, click “Manage services on server.”
12. Find Excel Calculation Services and click Start to the right of it.
               
    
13. The Excel Services service application is now up and running, configured for SharePoint Users
14. should now be able to upload basic workbooks and view them inside of SharePoint.

Please Comment if you need Any Help.Your Feed back is always Welcome.I Am Happy to Help !!!!! -

Wednesday, January 15, 2014

create a new Farm Administrator via Power Shell

create a new Farm Administrator via Power Shell

Copy the below script and paste in noted pad as .PS1

Add-PSSnapin Microsoft.SharePoint.PowerShell -erroraction SilentlyContinue
# Creates a new Farm Administrator
$newFarmAdministrator = Read-Host -Prompt 'Please provide the name of the new Farm Administrator in the form of DOMAIN\Username'
$caWebApp = Get-SPWebApplication -IncludeCentralAdministration | where-object {$_.DisplayName -eq "SharePoint Central Administration v4"}
$caSite = $caWebApp.Sites[0]
$caWeb = $caSite.RootWeb

$farmAdministrators = $caWeb.SiteGroups["Farm Administrators"]
$farmAdministrators.AddUser($newFarmAdministrator, "", $newFarmAdministrator, "Configured via PowerShell")

$caWeb.Dispose()
$caSite.Dispose()

$caDB = Get-SPContentDatabase -WebApplication $caWebApp
Add-SPShellAdmin -Database $caDB -Username $newFarmAdministrator



Once copied as .PS1 run the script.


Note: The user must exist in AD before run the script.

Please Comment if you need Any Help.Your Feed back is always Welcome.I Am Happy to Help !!!!!

Vulnerabilities in Microsoft Word and Office web apps could allow remote code execution MS14-001

Vulnerabilities in Microsoft Word and Office web apps could allow remote code execution MS14-001: January 14, 2014

Link: http://technet.microsoft.com/en-us/security/bulletin/MS14-001

Known issues and additional information about this security update

The following articles contain additional information about this security update as it relates to individual product versions. The articles may contain known issue information. If this is the case, the known issue is listed below each article link.
·         2827224 MS14-001: Description of the security update for Word 2013: January 14, 2014

·         2837577 MS14-001: Description of the security update for Word Automation Services in SharePoint Server 2010: January 14, 2014

Note: After you install this security update on all SharePoint servers and SharePoint services, you have to run the PSconfig tool to complete the installation.

·         2837596 MS14-001: Description of the security update for Word Web App: January 14, 2014

·         2837615 MS14-001: Description of the security update for Office Compatibility Pack: January 14, 2014

·         2837617 MS14-001: Description of the security update for Word 2007: January 14, 2014

·         2837625 MS14-001: Description of the security update for Word Automation Services in Microsoft SharePoint Server 2013: January 14, 2014

Note After you install this security update on all SharePoint servers and SharePoint services, you have to run the PSconfig tool to complete the installation.

·         2863834 MS14-001: Description of the security update for Word 2013 primary interop assembly (PIA): January 14, 2014

·         2863866 MS14-001: Description of the security update for Word 2003: January 14, 2014

·         2863867 MS14-001: Description of the security update for Microsoft Word Viewer: January 14, 2014

·         2863879 MS14-001: Description of the security update for Office Web Apps Server 2013: January 14, 2014


·         2863901 MS14-001: Description of the security update for Microsoft Office 2010: January 14, 2014

·         2863902 MS14-001: Description of the security update for Word 2010 Service Pack 1 and Service Pack 2: January 14, 2014

Tuesday, January 14, 2014

Business Intelligence Enhancements in SharePoint 2013

 Business Intelligence Enhancements in SharePoint 2013
                                 


Power Pivot: Introduced in SharePoint 2010, Power Pivot now offers deeper integration with Excel Services, giving users the ability to create relationships between data from different sources. This allows users to view complex data in a more refined, normalized form.
Power View: Excel Services 2013 takes better advantage of the new Microsoft data modeling and visualization engine that sits a top the SQL Server Reporting Services add-in to SharePoint.
Business Connectivity Services: Users can now connect diagrams directly to external data, opening a wealth of opportunities for user-driven data displays. Because SharePoint can provide and control access to key data, administrators can easily share data sources through the SharePoint interface.
Dashboard Designer: Tool to define data sources and regions on a page to hold such artifacts as filters, grids, charts and graphs. With the push of a button, it creates Web Part Pages and connected Web Parts that represent the dashboard.
Ipad Interface: The iPad is now a first-class client to Performance Point dashboards, meaning executives using the popular tablet can now access Performance Point dashboards using the interactive form factor, including ability to use touch intuitively and effectively.


Please Comment if you need Any Help.Your Feed back is always Welcome.I Am Happy to Help !!!!!

Monday, January 13, 2014

Applications for SharePoint

Applications for SharePoint          


Download applications for SharePoint from below link.

http://office.microsoft.com/en-us/store/results.aspx?qu=sharepoint&av=osu150

Please Comment if you need Any Help.Your Feed back is always Welcome.I Am Happy to Help !!!!!

ShareThis

X