I have a script on sql that uses a vbscript to create an excel file
It was working well on a server 2008R2 and sql 2008r2 with excel 2007 but now we upgraded to server 2019 and sql 2019 with excel 2016 but the script broke
If i run the script in CMD , it works well
If i run if from sql i get no permission create object , meaning i cannot create the excel
I tried with dcom but nothing worked ( added everyone to the excel application )
i checked the logon users shown here and added the sql agent and server to the folder permissions but still same error
what can i try ?