November 4, 2010 at 11:20 am
I have a linked server to a directory with several csv files in there on a network share.
I have referenced the network share via its UNC
The SQL Server Service account is a domain user that has access to the folder.
(Originally I wanted to use a seperate domain user as a remote login from the linked server but that gave less results)
Anyway, when I access the linked server from SSMS, nothing appears in the list of 'Tables' under 'Catalogs', to me suggesting something isnt quite right.
At the same time, if I run a new query on the local server and query one of the files in that directory via the linked server name... (select * from [csvdir]...[file1#csv]), data is returned.... So it appears to be working....
Until I try and run the same query from a desktop....
I get the following error
[font="Courier New"]OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "CSVDIR" returned message "'\\fileserver1\hiddendata$\Team1\Docs\' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.".
Msg 7303, Level 16, State 1, Line 1
Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "CSVDIR". [/font]
Adding a local login and a valid domain account to the remote login of the linked server, still executes a query AOK locally on the server, but remotely I now get
[font="Courier New"]OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "CSVDIR" returned message "Not a valid account name or password.".
Msg 7399, Level 16, State 1, Line 1
The OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "CSVDIR" reported an error. Authentication failed.
Msg 7303, Level 16, State 1, Line 1
Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "CSVDIR".[/font]
Has anyone else had issues with this and know how to fix it for both local and remote access?
Can anyone explain the behaviour??
Thanks in advance
November 5, 2010 at 7:20 am
Sounds like a Kerberos issue because of a double-hop authentication. Check out this article[/url].
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply