Post reply

Permissions problem

  • July 28, 2005 at 8:32 am

    #88315 

    Hi
     
    I have some code that I am testing to read data from a FoxPro file.
    I have copied the FoxPro file locally to test.
    I have created a linked server that points to this file.
    Enterprise manager correctly shows the tables available.
    Works fine.!
     
    However, when I create another linked server pointing towards the network files,
    enterprise manager shows no available tables and my code returns an error stating that the table does not exist.
    I can however import these tables using a DTS job.
    The following 2 lines of code ALSO fail:
    EXEC sp_tables_ex @table_server='OPERA_SERVER'
    EXEC sp_columns_ex @table_server='OPERA_SERVER', @table_name='ssale'
    I have checked the security permissions on the network drive/directories and I appear to have full access.
    I can indeed move, delete etc these files.
    Any ideas why I cannot connect in enterprise manager and execute my code..?
     
    Thanks

  • July 28, 2005 at 8:28 pm

    #578060

    Does the service account which SQL Server runs under have the ability to access the network share?

    K. Brian Kelley
    @kbriankelley

  • July 29, 2005 at 5:43 am

    #578146

    It sure does.  Infact I can set up a linked server that accesses an Excel file on the same drive.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply