Get Active directory users info using UserPrincipal

//Config ADFS as tutorial in the link below :

http://www.dotnetcurry.com/windows-azure/1158/using-adfs-azure-single-signon-aspnet-mvc

http://blogs.msdn.com/b/card/archive/2010/06/25/using-federation-metadata-to-establish-a-relying-party-trust-in-ad-fs-2-0.aspx

ecsp-banner2

//——————————————————//

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 http://www.microsoft.com/download/en/details.aspx?id=13255. 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: