installation of Azure AD Connect Azure

I followed this blog and successfully able to synchronize  users from local ad to azure ad.
make sure username and password used to synchronize here while configuring it,

https://azure.microsoft.com/en-us/documentation/articles/active-directory-aadconnect-get-started-custom/

Cheers...

Step-by-Step: Build a FREE SharePoint 2013 Dev/Test Lab in the Cloud with Windows Azure Infrastructure Services

http://blogs.technet.com/b/keithmayer/archive/2013/01/07/step-by-step-build-a-free-sharepoint-2013-lab-in-the-cloud-with-windows-azure-31-days-of-servers-in-the-cloud-part-7-of-31.aspx

Durable Links in SharePoint Server 2016

SharePoint 2016 got new feature called "Durable Links",

http://blogs.technet.com/b/wbaer/archive/2015/09/22/durable-links-in-sharepoint-server-2016-it-preview.aspx

SharePoint 2013 CU Updates

You can find latest updates for SharePoint 2013 here,

https://technet.microsoft.com/en-us/library/dn789211(v=office.14).aspx

SharePoint Online preventing Users to download multiple documents

Error: Users are not prevented to download multiple documents and folders from SharePoint online.
getting following error while doing it,

Solution:
 added https URL into trusted sites under Internet Options/Security tab.
restarted IE browser and it works...Cheers..

Some Users didn't migrate after migration from SharePoint 2010 to 2013

i got following error after migration users from SharePoint 2010 to SharePoint 2013.

Error: i got error from log file,

"SPWebApplication 'QAS Intranet Portal', SPSite '7e4e36d2-6187-4cc5-a95f-d2155e20f2cd', SPUser 'contoso\MS5592': Could not get migration data for user with name 'contoso\MS5592' and identifier 'S-1-5-21-3166358256-3741618376-1075545218-3045' so SKIPPING. 

Checked migration for further logs".

i ran following command to migrate users from SharePoint 2010 to 2013,
$wa = get-SPWebApplication "webappname"
Convert-SPWebApplication -Identity $wa -To Claims –RetainPermissions -Verbose
$wa.MigrateUsers($true)

Solution:

I followed below blog and found it that users are migrated while checking people picket in SharePoint 2013. 
you can run full synchronization to make sure all users are imported properly.
Troubleshoot Database upgrade issue in SharePoint 2013,
https://technet.microsoft.com/en-us/library/cc262967.aspx

Migrate from classic mode to claims based authentication in SP 2013,
https://technet.microsoft.com/en-us/library/gg251985.aspx


That's all....

Database upgrade issues in SharePoint 2013

You have to read this blog before migration from SharePoint 2010 to SharePoint 2013 otherwise you will get error regrading with access issue or user not found in SharePoint or SharePoint sites or AD.

Troubleshoot database upgrade issues in SharePoint 2013

https://technet.microsoft.com/en-us/library/cc262967.aspx

Migrate from classic mode to Claims based authentication in SharePoint 2013,

https://technet.microsoft.com/en-us/library/gg251985.aspx

Hide Open with explorer based on user group permission

hiding open with explorer based on users group permission who log in system by following j query,

<script type="text/javascript" language="javascript" src="https://intranet.sharepoint.com/sites/portal/SiteAssets/jquery-1.8.2.js" ></script>
<script type="text/javascript" language="javascript" src="https://intranet.sharepoint.com/sites/portal/SiteAssets/jquery.SPServices-2014.02.js" ></script>
<script type="text/javascript" language="javascript">

_spBodyOnLoadFunctionNames.push("ConfigRcoTopNav");

function ConfigRcoTopNav() {

$().SPServices({
         operation: "GetGroupCollectionFromUser",
         userLoginName: $().SPServices.SPGetCurrentUser(),
         async: true,
         completefunc: function (xData, Status) {
             if (($(xData.responseXML).find("Group[Name='EndUsersGroup']").length) == 1) {
               //document.getElementById('suiteBarTop').style.display = 'none';
                    $('div.o365cs-nav-leftAlign').css({'display':'none'});
                   $('#O365_MainLink_Settings').css({'display':'none'});
                   $('#O365_MainLink_Help').css({'display':'none'});
                   $('#O365_SubLink_ShellO365Settings').css({'display':'none'});
$('#O365_SubLink_ShellAboutMe').css({'display':'none'});
$('#O365_SubLink_SuiteMenu_zz2_ID_PersonalInformation').css({'display':'none'});
$('#O365_SubLink_SuiteMenu_zz4_ID_PersonalizePage').css({'display':'none'});
$('#O365_SubLink_SuiteMenu_zz5_ID_SwitchView').css({'display':'none'});
                   $('button.o365cs-nav-item o365cs-nav-button o365button ms-bgc-w ms-fcl-b o365cs-spo-topbarMenuOpen').css({'display':'none'});
                   //$('#RibbonContainer-TabRowRight').css({'display':'none'});
                   $('div.ms-cui-TabRowRight s4-trc-container s4-notdlg ms-core-defaultFont').css({'display':'none'});

document.getElementById('RibbonContainer-TabRowRight').style.display = 'none';
                 
                           

HideOpenFileWithExplorer();


     }
         }
     });

 
 }

 function HideOpenFileWithExplorer() {
        if(window.location.href.indexOf('Forms') != -1) {
                $('a[title="Browse"]').click();
             
             
                setTimeout(
                        function() {
                                var objLibrary = $("li[title='Library']");
                                if(objLibrary.length > 0) {
                                        objLibrary.click(function() {
                                                setTimeout(
                                                        function() {
                                                                $("a[id='Ribbon.Library.Actions.OpenWithExplorer-Medium']").hide();
 
                                                        },
                                                92);
                                        });
                                }
                               
                        $("li[title='Library']").click();
                        },
               
                1800);
             
        }
}

</script>

// make sure everything copy and paste proper in master page to make it across SharePoint environment.

SharePoint 2016

SharePoint 2016 installation step by step...

You can follow this site to configure it,,,

http://www.enjoysharepoint.com/Articles/Details/sharepoint-server-2016-installation-step-by-step-21272.aspx

Thanks,

Power Pivot Data Refresh Error Using Power pivot unattended account SharePoint 2013 & Sql 2014

error:

Getting following error while refreshing power pivot data in excel sheet,

we installed power pivot perfectly but somewhere some permission is missing but could not able to find it,

when i check event viewer, found following error though i m able to connect sql server instance from SharePoint box and able to ping,

can some one help me to fix this?

"OLE DB or ODBC error: A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.; 08001; Client unable to establish connection; 08001; Encryption not supported on the client.; 08001."

Solution;

Power pivot has been installed successfully. it was issue with Sql server adventureworks2014 db sample.

I fixed this issue by restoring AdventureWorks2012 database on sql server 2014 and it works now.

it does not work with AdventureWorks2014 db with sql 2014 as of now.

Thanks,