From the lack of positive responses that have been posted here, it appears Greg is correct! A SQL auth. user doesn't seem to have any rights to the server's...

I've created a ODBC linked server to excel called: CORPORATE_ODBC2 by following the instructions in the 1st link. I've setup the provider parameters as suggested also. ie. Nested...

I cannot create linked server to an excel file logged in as sql auth. user (I've logged in as sa). The following error comes up:

TITLE: Microsoft SQL Server Management...

Thanks. As I mentioned above, I can successfully create a linked server to an Excel file and I can successfully query it if I log in as a windows...