hi,
im trying to a run an Executable (in VB.NET + Office interportability) to write to an Excel file. I have been using same file on windows 2003 + SQL 2000 and it has been doing its job.

I recently created another server but with SQL 2005 and when imn running it through TSQL it gives me an error saying

SetExcel Error: 429-Cannot create ActiveX component.
SetExcel Error: 91-Object reference not set to an instance of an object.
SetExcel Error: 91-Object reference not set to an instance of an object.
SetExcel Error: 91-Object reference not set to an instance of an object.

I have been running the same script through TSQL on SQL2000 and it has been working.

I then tried executing the file manualy (double click) and that works.

can anyone help me with this issue?