sobota, 29 czerwca 2024

query WINS service from command line

by nblookup.exe - tool from Microsft - this is the only way now - no modules for Powershell or just I'm not aware of it

czwartek, 27 czerwca 2024

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

wtorek, 25 czerwca 2024

piątek, 21 czerwca 2024

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.