Who's Online
10 visitors online now
0 guests, 10 bots, 0 members
Support my Sponsor

Archive for the ‘SharePoint’ Category

Seminar on 18th April on Sharepoint & Knockout by Inderjeet Singh and Pradeep Shet

Hello Friends,

Mark your calender for weekend to make it worth. We are coming up with our next offline seminar which we are planning to conduct on 18th April, Sunday from 11:00 am to 4:00 pm. This time we have a session on Sharepoint Installation & configuration which would be conducted by my friend me Inderjeet Singh (MVP) and other half of the session would be conducted by (Pradeep Shet) on JavaScript framework i.e. – Knockout. This will be an hands on session so get your laptops with you.
We want lots of people to take the benefit of these sessions. Contact your friends and tell them about this free seminar.

Venue: – Microsoft Office (4th Floor, Windsor Bldg, Off. CST Road, Kalina, Santacruz[E], Mumbai – 400098.

Landmark:- Near Mumbai University

Date :- 18th April, 2015
Timings :- 11:00 am to 4:00 pm

Pre requisites :
Get your laptop with you as this would be hands on session. Please don’t forget to bring it if you have it.

Share this event details across your friend circle who are interested in attending. We have created facebook event for this. Mark it as going if you are willing to attend it.

Update on SharePoint server 2016 release date

Today big news coming from Microsoft is release date of SharePoint 2016

 

Finally, Microsoft announced the most awaited release dates of on-premises SharePoint 2016.
Microsoft Blog site “SharePoint Server 2016 update” says that the next version of SharePoint Server 2016 has advanced content management, team collaboration, user experiences across devices, and how the cloud can be blended into existing on-premises scenarios in new and compelling ways.

 

Major focused areas for development of SharePoint Server 2016 were to deliver enhancements and new capabilities in three major areas:
1. New user experiences
2. Cloud-inspired infrastructure with Hybrid at the core
3. People-centric compliance

 

I find the most interesting comment to be “People-Centric File Storage and Collaboration”. I take this to suggest a move to storing the majority of files in OD4B rather than team sites and promote people to use it. Now that Microsoft owns Yammer, I assume Yammer will be tightly integrated with SharePoint and soon may disappear just like Fast search.

 

Now most awaited SharePoint Server 2016 RTM will be available to customers in Q2 CY 2016 but a Public Beta would be available in Q4 CY 2015.

 

Another good news is that if your company is interested in providing feedback on early versions of SharePoint 2016, Microsoft can invite you to nominate them for the Technology Adoption Program (TAP). Joining the on-premises TAP Program provides companies with a number of advantages, such as providing input and feedback for future releases of SharePoint, Project Server, and/or Exchange Server; developing a close relationship with the Product Teams; and receiving pre-release information about SharePoint, Project Server and Exchange.

To apply for TAP you need to visit
http://prereleaseprograms-public.sharepoint.com/Pages/BusinessProfile.aspx

Microsoft AppFabric 1.1 support will end soon but what about its integration in SharePoint 2013

I recently  found article which says “Microsoft AppFabric 1.1 for Windows Server Ends Support 4/2/2016“. This was a shocking news for me because SharePoint 2013 uses Microsoft AppFabric 1.1, and this means support for SharePoint will also be effected.

 

In case if you don’t know what is AppFabric 1.1, AppFabric provides hosting, management and caching capabilities for Web applications and middle-tier services. This application helps us to build, scale and manage applications, in particular those built using ASP.NET, Windows Communication Foundation (WCF) and Windows Workflow Foundation (WF).

 

Microsoft has recommended all applications using AppFabric 1.1 for Windows Server to migrate off this technology by April 2, 2016. Recommended alternative is Azure Redis cache.

 

Azure Redis Cache is was build on the popular open source Redis Cache. It provies you access to a secure, dedicated Redis cache, managed and fully supported by Microsoft, so you can focus on your application rather than the infrastructure. We recommend all Microsoft AppFabric customers using Cache to move to Microsoft Azure Redis Cache.

 

As per my knowledge SharePoint 2013 leverages Workflow Manager and an internal workflow hosting for legacy workflows.

 

Finally I found a comment by Erica Mohler(Microsoft) which says “SharePoint functionality (including the Distributed Cache feature) will be supported under the Microsoft Support lifecycle for SharePoint 2013” which was a relief moment for me.

 

Another important point to consider that the next version of SharePoint which is suppose to be SharePoint 2016 will integrate with Azure Redis.

 

Hope this will help you.

ADFS signout issue for SharePoint site in IE browser due to FedAuth Cookie

 

Hi All,

 

Today we will discuss on a very famous SharePoint ADFS sign Out issue. Let me start with some background on the issue. I have configured SharePoint with ADFS authentication, everything(login, logout, claims, etc) works except when I try to logout, I am redirected to a page similar to https://your_sts_server/adfs/ls/?wa=wsignout1.0.

 

Now without closing the browser windows(Logout message says “Sign out: Close browser to complete sign out”) type the SharePoint site URL in address bar, I won’t be asked to login and SharePoint site will be accessible. This shows that Signout was incomplete.

 

This is a known issue with SharePoint site working with ADFS authentication. This is is caused due to ADFS FedAuth Cookie. In order to have correct sign out behaviour we need to make the FedAuth cookies as session based. We can achieve this by running the following SharePoint Powershell command:
$sts = Get-SPSecurityTokenServiceConfig
$sts.UseSessionCookies = $true
$sts.Update()

 

You need to run above command on a single server but you need to perform iisreset on all SharePoint servers.

 

To understand more about the FedAuth Cookie check below article:
https://msdn.microsoft.com/en-us/library/office/hh147183(v=office.14).aspx

 

Hope this will help you all.

Access SQL server database of any version of SharePoint Standalone farm

I assume you know if we want to install SharePoint in a Workgroup environment, the only recommended Microsoft solution is to install SharePoint standalone server. Here SQL server embedded edition is installed with SharePoint server and SharePoint databases are created on this Embedded SQL server.

 

Normally we don’t perform any task on these SQL databases but incase if you want to access sharepoint databases for backup, troubleshoot, etc, you need to install SQL server management studio to achieve the same.

 

  1. Install SQL server Management studio. You can download the management studio from below link:
    http://www.microsoft.com/en-in/download/confirmation.aspx?id=29062
    0226

  2. Once installation is completed, open SQL Studio management studio
    0230

Once We have management studio installed, you can either use below registry value or servername\sharepoint to access database. Make sure you use SharePoint farm account when you connect to SQL server.

  1. Go to below registry path:
    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10_50.SHAREPOINT\MSSQLServer\SuperSocketNetLib\Np

0231
2. Use the value in key “PipeName” to connect to SharePoint database server. As discussed above you can also use servername\sharepoint to connect to SQL instance
0232

Note: You need to install SQL server management studio on SharePoint server. You cannot remote connect to this SQL instance. Do not manually modify any SharePoint database, if modified, your farm\database would be unsupported

 

Applies to all version of SharePoint servers

Configure a SharePoint server in non domain(Workgroup) environment

Hi All,

Lets try to configure a SharePoint farm in a workgroup environment. Normally if we have to configure a SharePoint on a Workgroup environment only option available for us is Standalone environment. Now lets us try to understand how we can configure a SharePoint farm environment in a Workgroup environment. We need to run below powershell commands. Make sure you update passphase and SQL server name in below powershell. We have SharePoint and SQL installed on same machine. Make sure account used during FarmAccount does have access to SQL server.

$FarmAccount = Get-Credential
$PassPhrase = “FarmPassphrase”
$FarmPassphrase = (ConvertTo-SecureString $PassPhrase -AsPlainText -force)
$FarmConfigDatabase = “Wss_config_2”
$AdminContentDatabase = “SPFarm_Admin_ContentDB_2”
$CentralAdminPort = 8080
New-SPConfigurationDatabase -DatabaseServer (SQLservername) -DatabaseName $FarmConfigDatabase -AdministrationContentDatabaseName $AdminContentDatabase -Passphrase $FarmPassphrase -FarmCredentials $FarmAccount

Now let’s move a steps ahead and try to use different server for SharePoint and SQL server. Here we created a SQL user account and updated credentials in dbcredential.
$dbcredential = New-Object –typename System.Management.Automation.PSCredential –argumentlist “SQLuser”, (ConvertTo-secureString “SQLpassword” –AsPlainText –Force)
$PassPhrase = “FarmPassphrase”
$FarmPassphrase = (ConvertTo-SecureString $PassPhrase -AsPlainText -force)
$FarmConfigDatabase = “Wss_config”
$AdminContentDatabase = “SPFarm_Admin_ContentDB”
$CentralAdminPort = 8080
$FarmAccount = Get-Credential
New-SPConfigurationDatabase -DatabaseServer “SQLservername” -DatabaseName $FarmConfigDatabase -AdministrationContentDatabaseName $AdminContentDatabase -Passphrase $FarmPassphrase -FarmCredentials $FarmAccount -DatabaseCredentials $dbcredential

0227

0228

Note: We still cannot create a Multiple SharePoint server farm in Workgroup environment. Using above script you can connect only 1 SharePoint server with a SQL server.

This script works for both SharePoint 2010 and SharePoint 2013

Windows Admin take extra care with windows update and head up for SharePoint admin

We all know that SharePoint Security update get downloaded and install with windows update. Normally these update do not change any build number so SharePoint admin were least concerned about the update. The only time a SharePoint admin would look at these update if users start facing a unknown SharePoint issue after windows update.

Since February 2015 things have changed for admins. Microsoft has started pushing cumulative update(this will change build number) along with Microsoft security update. Now every-time you install Windows update, you will have to run PSCONFIG and SharePoint build number will change.

Now SharePoint admins don’t have to schedule a different slot for SharePoint update or download and install them separately.

Windows admin has to take additional care to make sure appropriate SharePoint updates are selected while installing Windows update.

As part of normal practice, when a update is installed we need to run the psconfig wizard to seal the patch and update SQL tables. Now after every windows update, SharePoint admin needs to run this psconfig wizard to make sure patches are properly installed.

If you have a Standalone server I don’t think you should have any issues, if you have a Farm server setup I would recommend manually installing these update instead of windows update.

Lot of my friends use to make note of all the ASP.net, SharePoint security update and IIS update so that he can narrow down in case any issue occurs in future. Now he has to make note of SharePoint CU as well. Fortunately for everyone it was easy to filter out and decline the updates in our on-premises WSUS server or normal windows update.

Highlights:
1. SharePoint cumulative update is now part of windows updates
2. Run PSconfig after every windows update
3. Windows admin take extra care when installing Windows update.

Hope this will be helpful for you all.

You need to think if its additional burden on Windows Admin or heads up for SharePoint admin.

 

Download and Install Cumulative Update February 2015 for SharePoint 2013

Microsoft has released another SharePoint 2013 Cumulative Update in February 2015. Let me help you know how we can install  February 2015 on SharePoint 2013 server.

Its per-requisites is either SharePoint 2013 SP1 or SharePoint 2013 March PU.

Now the most important part is how to install SharePoint server February 2014 Cumulative Update.

Previous releases of the SharePoint Server 2013 cumulative update included both the executable and the .CAB file in the same self-extracting executable download. Because of the file size, the SharePoint Server 2013 package has been divided into several separate downloads. One contains the executable file, while the others contain the CAB file. All are necessary and must be placed in the same folder to successfully install the update. All are available by clicking the same Hotfix Download Available link in the KB article for the release.

Here is link for all the updates:

Sharepoint Foundation 2013 has only 1 setup file ubersts2013-kb2920801-fullfile-x64-glb.exe
Download SharePoint Foundation 2013 February 2015 CU

Now here the twist starts, SharePoint 2013 update has 3 setup files ubersrv_1.cab, ubersrv_2.cab, ubersrv2013-kb2920804-fullfile-x64-glb.exe. You can download this from:
Download SharePoint Server 2013 February 2015 CU

Project Server 2013 update has 3 setup files ubersrvprj_1.cab, ubersrvprj_2.cab, ubersrvprj2013-kb2920796-fullfile-x64-glb.exe. You can download this from below
Download Project Server 2013 February 2015 CU

Office Web App server 2013 has only 1 setup filewacserver2013-kb2956101-fullfile-x64-glb.exe.
Download Office Web App 2013 February 2015 CU

The KB articles for September CU are available at the following locations:

  • KB 2920801 – SharePoint Foundation 2013 February 2015 CU
  • KB 2920804 – SharePoint Server 2013 February 2015 CU
  • KB 2920796 – SharePoint Server 2013 with Project Server February 2015 CU
  • KB 2956101 – Office Web App Server 2013 February 2015 CU

Once the updated the downloaded you need to extract all the updates in 1 folder as shown below:

  • Now when you run the main setup file exe file, you will be able to extract and install the update.Do not try to extract cab file it will be extracted by exe.
  • Once you install these updates, you need to reboot the server
  • Now system needs to be restarted.
  • Follow the same steps on all SharePoint servers in farm.
  • SharePoint PSconfig wizard on all servers.
  • Finally it is installed

Note : SharePoint Server 2013 update contains the SharePoint Foundation update.Where as SharePoint Server 2013 with Project Server update contains Project Server update, SharePoint Server update and SharePoint Foundation update.

For more information:
http://blogs.technet.com/b/stefan_gossner/archive/2015/02/10/february-2015-cu-for-sharepoint-2013-has-been-released.aspx

Cumulative Update February 2015 for SharePoint 2010

Microsoft has released SharePoint 2010 Cumulative Update in February 2015.

Its per-requisites is Sharepoint 2010 SP2. Rather I would recommend you to install September 2014 CU before installing February 2015 CU.

Note: This CU does contains all SharePoint 2010 fixes released after Service pack 2. 

All are available by clicking the same Hotfix Download Available link in the KB article for the release.

Here is link for all the updates:

For SharePoint Foundation 2010 you need setup wssloc2010-kb2910904-fullfile-x64-glb.exe
Download SharePoint Foundation 2010 February 2015 CU

For SharePoint server 2010 you need setup ubersrv2010-kb2899558-fullfile-x64-glb.exe
Download SharePoint Server 2010 February 2015 CU

For Project server 2010 you need setup ubersrvprj2010-kb2899557-fullfile-x64-glb.exe
Download Project Server 2010 February 2015 CU 

 

The KB articles for December CU are available at the following locations:

  • SharePoint Foundation 2010: KB 2910904
  • SharePoint Server 2010: KB 2899558
  • Project Server 2010: KB 2899557

Once the updated are downloaded, you need run the main setup file ubersrv.exe file, you will be able to extract and install the update.

Once updates are installed, run SharePoint Products and configuration wizard to seal the update on the server.

Follow the same steps on all SharePoint servers in farm. Now run SharePoint PSconfig wizard on all servers.

For more information:

http://blogs.technet.com/b/stefan_gossner/archive/2015/02/10/february-2015-cu-for-sharepoint-2010-has-been-released.aspx 

 

Release date of SharePoint Beta 2016

Hi All,

Just a head-up on SharePoint 2016 release details. This dates are not yet confirmed but good for initial guidance.

SharePoint Beta 5th June 2015

Some Highlights for the SharePoint 2016:
The next version of SharePoint is not the last version of SharePoint server that Microsoft will SHIP. So thats a very good news for the SharePoint On-premises community.
You can still use Infopath Forms 2013 with SharePoint 2016. Forms for SharePoint library seems dropped from the list.
More integration features with Office 2016.
Delve and yammer still does not have much of clarity on integration with SharePoint 2016.
Lot more site and list templates to use from.
Hybrid mode of SharePoint is also given some extra consideration.
Improved Business Intelligence features.

Hope this head-up is helpful for you.