It was a sql account which worked accessing the file when sysadmin role was applied .. but did not work when sysadmin role was revoked.

Thanks! I will be trying this today, I did not user cluster administrator when creating the share .. I will let you all know how it goes .....

I might be confused but I was figuring since I was using 64 bit sql server on a 64 bit os, that driver had to be the 64 bit version....

I am using 64 bit SQL Server .. and microsoft has released the x64 version of this driver.. Does that driver to your knowledge not work properly or something?

Thank you for the reply .. I did run that dbcc traceon .. waited for another deadlock and the output is the same .. I am using this commands...

in the security tab I have no mappings in the local to remote user as I am trying to read an excel file, and I have tried both options of...

Well I am creating the linked server like this

EXEC master.dbo.sp_addlinkedserver @server = N'ICD9_EXCLUSIONS', @srvproduct=N'Excel', @provider=N'Microsoft.ACE.OLEDB.12.0', @datasrc=N'C:\ICD9_EXCLUSIONS.xlsx', @provstr=N'Excel 12.0'

( I have also created them using the .xls and Excel...

No it has not worked before. I have shared out the folder as SQLLINK opened up the share permissions to to Everyrone Full Control, then opened up the...

.. edit .. I meant allow them to delete data from within the table .. not delete database from within the table. And unfortunately its a database that has...

Yeah .. you are correct in your assessment .. but it was mainly due to my own oversight .. the file had 17 columns and the table had 16.. so...

never mind .. im dumb .. missed how many columns there actually were and how many were in file.. and I counted them like 15 times .. dumb dumb dumb...

Thanks all for your replies .. you have provided me with the needed ammo .. 😎

When I do this in Active Passive I notice no issue. Its only when I online any instance on the node that doesn't have the cluster...

Ahh .. I see .. I switched those settings on my dev cluster .. and I still see the same thing on the non dtc node .. oh well .....

Mike .. just curious .. was there a doc that you used to change the parameters for the security config? when I checked my config the defaults did...