About Me

Having 12 years experience in Microsoft technologies.Since more than 7 years working in SharePoint technologies. Expert in providing consultation for SharePoint projects. Hands on with development and administration.

Thursday 23 July 2015

Set up the SharePoint 2013 Online Management Shell environment

SharePoint Online global administrators use the SharePoint Online Management Shell to remotely manage site collections, upgrade site collections to a new version, configure SharePoint Online company-level settings, and get logs from data connections between SharePoint Online and other services through Business Connectivity Services.
 
To set up the SharePoint Online Management Shell environment, follow these steps:
 
1.Install Windows Management Framework 3.0 from http://www.microsoft.com/en-us/download/details.aspx?id=3459
 
2.Install SharePoint Online Management Shell.http://www.microsoft.com/en-us/download/details.aspx?id=35588

3.From the Start button, choose All Programs, and then select SharePoint Online Management Shell.

4.Run Connect-SPOService.
Connect-SPOService -Url
https://xxxxxx-admin.sharepoint.com -credential admin@yourdomain.com
 Where URL is the URL of the SharePoint Online Administration Center

5.Credential is the user name to which you want to grant access to the SharePoint Online Administration Center site.

6.Try it out! Run Get-SPOSite to get a list of all the sites.

Turn scripting capabilities on or off for SharePoint 2013 Online

Default scripting capabilities are disabled in SharePoint online, because of this we can’t run scripts in the site & we don’t fine few web parts like, content editor (CEWP) & script editor web part (SEWP) which is very essential in current development trend.

The default scripting capabilities are:
  • For personal sites, custom scripting is disabled by default.
  • For self-service created sites, custom scripting is disabled by default.
  • For the Root Site Collection of the Tenant, custom scripting is disabled by default.
To enable or disable scripting from the SharePoint admin center
  1. Sign in to Office 365 with your registered account.
  2. Go to the SharePoint admin center (https://portal.office.com/admin/default.aspx)
  3. Search for settings, the direct url

4. Select Settings.
5. Under Custom Script choose following
    • Allow users from running custom script on personal sites
    • Allow users to run custom script on self-service created sites.
 
 
Select OK. It takes about 24 hours for the change to take effect.
To enable scripting on a particular site collection immediately, use the following PowerShell command
Run following command from SharePoint Online Management Shell
Set-SPOsite <SiteURL> -DenyAddAndCustomizePages 0
Make sure the scripting setting in the admin portal matches what you set using PowerShell or the site collection setting may be overridden again in the next 24 hours

Wednesday 6 May 2015

SharePoint 2013 Provider host app with MVC5 Example


There are many articles in the web which explains their own scenarios and few are generic though... but few articles haven't covered few settings like Provider Host web app (MVC) settings in IIS server & there are many... In this article I would explain in detail about SharePoint 2013 provider host app with MVC sample. 

I am assuming following is the DEV environment topology

Single server farm–

·         DNS, Active Directory

·         SharePoint 2013 enterprise

·         SQL Server 2012 enterprise with SP1

·         Visual Studio 2013

Following are high level steps which we are going to discuss in detail in later sections of the article

1.      Creating certificates for SharePoint Web application& Provider Host Web (MVC) – Generally, for demo purpose we can create IIS self-signed certificates; however in real time scenarios we should create SAN certificates. In this article I am going to show how we can create SAN (Subject Alternative Names) DNS server.

2.      Export certificates to local drive.

3.      Create DNS host entries for SharePoint site & Provider Host web (MVC)

4.      Create SharePoint Web application with SSL enabled (ignore if you already have one)

5.      Create host named site collection under SharePoint web application which we created in step3 (ignore if you already have one)

6.      Create virtual directory for Provider Host web (MVC) in IIS. We can test our application using IIS express which VS 2012/2013 provides by default for testing purpose; however I want to explain real time settings by creating virtual directory in IIS with proper deployment steps.

7.      IIS authentication settings for Provider Host web (MVC) – Very important.

8.      Register and generate app ids, app secret & provider host web app (MVC) entries.

9.      Deploy Provider Host App (MVC) certificate to SharePoint 2013 trusted root authority. - Very important.

10.   Create SharePoint 2013 provider host app with MVC in visual studio 2013

11.  Add client id, client secret& issuer id to Provider host web app (MVC) web.config

12.   Deploy SharePoint app & provider host web (MVC).

 will add detailed steps soon......

Friday 20 February 2015

Steps to provision SharePoint 2013 Performance Point Services

Following are steps to create or provision performance point services in SharePoint 2013
There are two ways we can do this
  1. Through GUI
    1. Go to SharePoint Central Administration --> Application Management--> Manage Service Application
       
    2. Click Create
    3. Upon successful, click on newly created service application
    4.  PerformancePoint Service Application Settings --> Secure Store Unattended Service Account
    5. Provide ‘Secure Store Service Application ‘ name
    6. Click ‘Change User’ for Unattended Service Account
    7. Provide PPS service account user name and password. And hit OK