2024-06-27

ADSync database shrink

We have problem with a huge ADSync database and we are in process of shrinking - we can't do upgrade to new Entra tool, so shrinking loooks like below:
c:\Program Files\Microsoft SQL Server\Client SDK\ODBC\170\Binn\SQLCMD.exe -S "(localdb)\.\ADSync2019"
(sqlcmd prompt) DBCC shrinkdatabase(ADSync,1);
(sqlcmd prompt) GO

ADSync database statistics

c:\Program Files\Microsoft SQL Server\Client SDK\ODBC\170\Binn\SQLCMD.exe -S "(localdb)\.\ADSync2019"
(sqlcmd prompt) USE ADSync;
(sqlcmd prompt) EXEC sp_spaceused @updateusage = N'TRUE';
(sqlcmd prompt) GO

2024-06-25

how to find all placeholders in MV of Azure AD Connect?

Import-Module "C:\Program Files\Microsoft Azure Active Directory Connect\Tools\AdSyncTools.psm1"

Export-ADSyncToolsAadDisconnectors

2024-06-21

0x80040e14 during Azure ADConnect upgrade

During upgrade Azure ADConnect to Entra AD Connect 2.3.8.0 we've received 0x80040e14 error. At first we had an idea that it's connected with permission or communication limitation on firewall, after quick search possible reasons:
  • missing column
  • or not enough memory for sql

  • For us it's near not enough memory reason, but we have still SQL Express, so during upgrade there is no place for finishing upgrade (limit 10GB for database size). We must find if we have any not needed objects to remove them from Azure or to move to full SQL server.