I have a DLL that uses Microsoft Excel objects and works fine in my local environment. My local desktop has a full version of MS Office 2003 installed. But when I deploy it on Windows 2003 server (it cannot have Office 2003 installed), we are getting the following error.
Msg 10301, Level 16, State 1, Line 1
Assembly 'DashboardExcelCharts' references assembly 'microsoft.office.interop.excel, version=126.96.36.199, culture=neutral, publickeytoken=71e9bce111e9429c.', which is not present in the current database. SQL Server attempted to locate and automatically load the referenced assembly from the same location where referring assembly came from, but that operation has failed (reason: 2(The system cannot find the file specified.)). Please load the referenced assembly into the current database and retry your request.
I downloaded the interop library and installed them on the server but still facing challenges. Can anyone suggest any solutions to this issue.