March 26, 2008 at 3:16 pm
Trying to run a job I get this error
Executed as user: domain\service_sql. ...cuting... DTSRun OnStart: Copy Data from TblTaxesInsurance to [db].[dbo].[Tbl] Step DTSRun OnError: Copy Data from TblTaxesInsurance to [Grams_Current].[dbo].[TblTaxesInsurance] Step, Error = -2147467259 (80004005) Error string: The Microsoft Jet database engine cannot open the file '\\server\dfsprod\folder\data\folder\folder.mdb'. It is already opened exclusively by another user, or you need permission to view its data. Error source: Microsoft JET Database Engine Help file: Help context: 5003051 Error Detail Records: Error: -2147467259 (80004005); Provider Error: -534709256 (E020FBF8) Error string: The Microsoft Jet database engine cannot open the file '\\server\dfsprod\folder\data\folder\folder.mdb'. It is already opened exclusively by another user, or you need permission to view its data. Error source: Microsoft JET Database Engine . The step failed.
But running the dts direct works. Any ideas?
¤ §unshine ¤
March 26, 2008 at 3:31 pm
Check to see if the login that runs SQL Server Agent as permission to open the Access database. When a package is run from a job, it will use the security context of the Agent login unless you specify a login and password in the Access connection in the package.
Greg
March 26, 2008 at 3:57 pm
That may be the trick having the network guys look at the original paths now.
Thank you so much!
¤ §unshine ¤
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply