Excel Linked server

Question

Excel Linked server

stephen charlesworth

SSC Enthusiast

Points: 183
More actions
March 5, 2006 at 2:00 pm

#113606

We recently changed the system startup service from the system account to a domain user account. We had been using a linked server (using Jet 4.0 OLE DB provider) to connect to an excel spreadsheet on a share on the same machine as SQL Server. Once we switched accounts the linked server no longer functions.
Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error.
[OLE/DB provider returned message: Unspecified error]
OLE DB error trace [OLE/DB Provider 'Microsoft.Jet.OLEDB.4.0' IDBInitialize::Initialize returned 0x80004005: ].
I have verified the domain account can open the spreadsheet by logging in using that account and opening the spreadsheet.
Any help appreciated.

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

lholman SSCrazy Points: 2810 More actions · Answer 1

Stephen,

Have you checked the SQL Errorlog to see if you're getting anything reported in there? May also be worth changing the audit level so that you capture failed logins (if you haven't got it set already) and see if that's your problem? Failing this try dropping the linked server and creating it again using sp_dropserver and sp_addlinkedserver.

ll

Jon-183221 SSCommitted Points: 1908 More actions · Answer 2

Have you checked the security information of the Linked Server?

stephen charlesworth SSC Enthusiast Points: 183 More actions · Answer 3

Thanks for your suggestions.

Tried the audit of failed logins. Nothing.

The only error trapped is :

OLEDB Errors OLE/DB Provider 'Microsoft.Jet.OLEDB.4.0' IDBInitialize::Initialize returned 0x80004005: SQL Query Analyzer

I've tried a few security options to no avail. It used to work with the 'Be made with using the login's current security context' with using the system account login.

I've deleted and recreated the linked server many times.

I have an instinct this has something to do with Jet driver security but no proof.

philcart SSC-Forever Points: 47795 More actions · Answer 4

Try this,

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=53340

--------------------
Colt 45 - the original point and click interface

philcart SSC-Forever Points: 47795 More actions · Answer 5

And this one as well,

http://support.microsoft.com/default.aspx?scid=kb;en-us;814398

--------------------
Colt 45 - the original point and click interface

stephen charlesworth SSC Enthusiast Points: 183 More actions · Answer 6

The last one (Microsoft link) worked !

Thank you for your help !