OPENROWSET/OPENDATASOURCE, Security, UNC - Help Please

From: Mike Mortensen (mmortensen@#N#O#S#P#A#Mresolutionhealth.com)
Date: 02/19/03

  • Next message: John Chen: "Login failed for user 'sa'" 
    From: Mike Mortensen <mmortensen@#N#O#S#P#A#Mresolutionhealth.com>
Date: Wed, 19 Feb 2003 18:36:59 -0000

    Posted this in .programming, thought this might be a more appropriate
    newsgroup...

    Hi All!

                I have a question about the security context of the Jet Provider
    when using OPENROWSET or OPENDATASOURCE. Below is the setup of the
    environment:

    Server: Win2k Server SP2
    SQL: SQL 2000 SP2
    Query:
    SELECT *
    FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
       'paradox 5.x;database=\\server\share\', table)

    Security on '\\server\share': Everyone has Full Control

    Here is the problem I am seeing. When i log into the server using
    integrated security (the account is a domain admin) the query fails with
    Msg 7399 which reads:

    [OLE/DB provider returned message: '\\server\share\' 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.]

    However, when i login to the SQL Server as SA, the query runs
    successfully. The SQL Server service account is an administrator on both
    machines.

    I have auditing turned on on the remote server and when i use the SA
    account, the event viewer shows the SQL Server service account
    connecting. When i use the integrated security account, i see the
    Anonymous account trying to login. Why is that? Why does it not use the
    SQL Server service account when i'm logged in as a windows user? Setting
    up a SQL Proxy account didn't resolve the problem. I cannot find any
    explanation of this behavior. Please help!

    Relevant Pages