Re: Linked Server to Excel Issue

From: oj (nospam_ojngo_at_home.com)
Date: 01/21/05 

Date: Fri, 21 Jan 2005 15:06:06 -0800

Your proxy account does not have access to network resources.

See this article for more info:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_xp_aa-sz_8sdm.asp 

-- 
-oj
"Raul" <raul@nothere.com> wrote in message 
news:6AD242AB-BD43-49B2-AC3D-119EC788CF91@microsoft.com...
>I am using a linked server to connect SQL Server to an Excel Spread*** on
> the network.  If I'm physically on the SQL Server box I can open the 
> linked
> server and see the named range on the desired spread***.  Also If I'm on
> the SQL Server box I can query the spread*** using OPENQUERY and 
> everything
> comes across beautifully.
>
> However, if I connect to the SQL Server box from a different location (via
> Enterprise Manager) and try to run a query using the OPENQUERY and linked
> server in question.  I keep getting the dreaded "error 7399: blah, blah,
> blah".
>
> Any thoughts?
>
> Thanks in advance,
> Raul