Azure AD DS Sync Account Permissions – Replicating Directory Changes

Microsoft has a decent outline for getting started with setup of the Azure AD Sync tool.  One of the prerequisites is to prepare the AD account used for the synchronization of passwords is to grant it permissions for “Replicating Directory Changes” and “Replicating Directory Changes All”.  This blog post serves as a quick guide on how to configure that. 1.  Within...

Read More»

Azure AD Setup – Sync Service Account – Login Failure

When setting up Azure AD synchronization tools, such as Azure AD Connect, there is the option to specify an on-premise AD user/service account to be used for the local sync authentication.  During the setup wizard, you may encounter the error “Logon failure: the user has not been granted the required logon type at this computer” (image below). This error occurs may...

Read More»

Script to Convert XLS to XLSX

Wrote this little diddy to convert an Excel 2003 file to Excel 2010 file. ‘ http://technet.microsoft.com/en-us/library/ff198017.aspx Const xlExcel12 = 50 Set oExcel = CreateObject(“Excel.Application”) ‘ Set below value to false to hide the Excel window oExcel.Visible = True ‘ Convert Set oWorkbook = oExcel.Workbooks.Open(“C:\filename.xls”) Set oWorksheet = oWorkbook.Worksheets(1) oWorkbook.SaveAs “C:\filename.xlsb”, xlExcel12   ‘ End oExcel.quit (oWorkbook.Close) [...]

Read More»