April 26, 2007 at 1:31 pm
I'm getting Error 7399 OLE DB provider 'Microsoft.JET.OLEDB.4.0' reported error. OLE DB error trace [OLE/DB Provider 'Microsoft.JET.OLEDB4.0' IDBInitialize return 0x80004005 on my linked server connection to MS Access.
Linked Server Connection:
Provider:Microsoft Jet 4.0 OLEDB Provider
Datasource: \\servername\pathname\access.mdb
Security: be made using the logins current security context
The MS Access database in a file/print server different from the SQL 2000 sp server.
April 26, 2007 at 4:17 pm
Hi Swede,
I've had this, It could be that the user that you login to SQL Server to run the linked server query with doesn't have sufficient rights.
Checkout http://support.microsoft.com/kb/814398
As a test, login to SQL Server as a user with full admin rights to the server
April 27, 2007 at 5:32 am
The MSAccess database is on a different server (file/print) than SQL Server. I have logged onto the SQL Server with full admin rights, even used the SQLServer account...didn't make any difference. I have also setup the temp/tmp like in the kb814398...still does not work.
Any other ideas?
April 27, 2007 at 8:27 am
This may sound a little obvious but does the SQL Server account have full rights to the directory that the MSAccess database is on ?
April 27, 2007 at 8:30 am
I copied to MS Access database to a local drive on the SQL Server box and got the same results.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply