August 14, 2008 at 2:52 am
Hi. I hope this is the right place to ask this question - if not, please direct me elsewhere.
I have an Excel 2002 workbook that gets data from SQL Server 2000. A user then copies a selection of this into another sheet, and this selection must be imported back into the SQL Server. The workbook is on another server in a shared location.
I created a package that does what I need it to do, and it runs with no problems. However, when it is scheduled the resultant job fails with the error "Error = -2147467259 (80004005) Error string: The Microsoft Jet database engine cannot open the file '\\[svraddress]\Reports$\Debtors\Workbook.xls'. It is already opened exclusively by another user, or you need permission to view its data. Error source: Microsoft JET Database Engine"
The thing is, this file is *not* open, so i can only guess that it is a permissions thing. On the other hand, as I said, the package runs through ok if i do it manually.
I'd appreciate any ideas.
Thanks
Lidia
August 14, 2008 at 4:35 am
Hello,
It sound like it could be a permissions issue to me as well. Can you check which account the SQL Agent runs under? (Via Computer Management --> Services node)
Can you then check if that account has permissions on the Network Folder where the Excel file is?
Regards,
John Marsh
www.sql.lu
SQL Server Luxembourg User Group
August 14, 2008 at 5:12 am
Hi
Thanks a million.
We changed the SQL Server Agent to run under a local user account which also exists on the machine which hosts the Excel file. All appears to be well now.
Your assistance is greatly appreciated.
August 14, 2008 at 5:24 am
Hi,
Thanks for the update. I'm glad to hear the issue is resolved.
Regards,
John Marsh
www.sql.lu
SQL Server Luxembourg User Group
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply