Do I need to install Excel inDatabase server

[debimishra]

Hi , Can anyone help me in this regard...
My system works on ASP as front end and Sql server2005 as backend. The database server and file servers are on different IPs.I have written a package in which several stored procedures are there and some of them operate microsft excel to generate reports.
I have used Microsoft.OleDB.Jet 4.0 engine to operate excel from stored procedure.
The package runs smoothly but the excel sheets are not generated.
Do I need to install excel.exe in the database server/File server???
Please help me I am in big trouble...
Thanks

[RobDog888]

I believe that if you install any office product on a server you need to also buy office CALs. Client Access licenses are based upon a per user license but if your db server is the only "client" accessing it then you may be able to get away with just once license.

[debimishra]

Thank u very much for your quick reply.
I just want to clarify that the DTS package is a scheduled package and it will copy a excel template from file server(which is in different IP ) and fill the template with data and then put it in file server Ip.
So I need to install MS office in database server not in file server,inspite of using the microsoft.ole jet 4.0, right??

Thanks Again....

[RobDog888]

Do you get any error messages? Using the jet 4 shouldnt be a requirement to install Excel but the issue just may be permissions as its executed from an ASP page? The IUSER_ANOMINOUS user account may not have the perms on the other system or something like that. You dont want to be giving it increased perms as its a security risk but without any error messages or logs its hard to say.