Runtime error: ActiveX component can't create object: 'SQLDMO.SQLServer'

 

When you use SQLDMO ???

Install SQL Server2005 Backward compatibility

https://download.microsoft.com/download/3/1/6/316FADB2-E703-4351-8E9C-E0B36D9D697E/SQLServer2005_BC.msi

Also remember if you have installed 32-Bit SQL Server on 64-Bit you have to use Cscript.exe from SysWOW64