Get Active directory users info using UserPrincipal

//Config ADFS as tutorial in the link below :



Please note : we pass Sam-Account Name as Name in Claim Rule setting

//Get Property of user in AD for .Net 4.0 -4.5

// Get groups

Query and update an Excel 2010 spreadsheet via a linked server

First  I downloaded and installed the ‘AccessDatabaseEngine_x64.exe’ file on the SQL Server from No restart was required.

Next I started SQL Server Management Studio as ‘Administrator’.



Next I enabled the ‘Allow inprocess’ option for the Microsoft.ACE.OLEDB.12.0 provider.



The linked server was created with this script: