Post reply

SQL server connection to network share

  • June 22, 2006 at 6:30 am

    #70422

    I am trying to access a file on a Network share from SQL server 2000.  I know that the file exists but it seems that SQL server doesn't recognize the path of the file on the Network share

  • June 23, 2006 at 7:30 am

    #645528

    Try to type the path at Run and see SQL server can access the path or not. If not, place IP address and target server name in SQL Server's local host file. You should use \\target server Name\Driveor shared folder\filename.xxx

    I have used this to access files in different server in a lot of my scripts without issue.

    Good luck!


    Jie Ma

  • June 23, 2006 at 7:35 am

    #645532

    Thanks for the response.  But I am not sure what you mean by "type the path at Run".  I am trying to execute a job within SQL.

  • June 23, 2006 at 7:45 am

    #645538

    From SQL Server that you try to execute a job, from Menu Bar, Start and Run. This just check your SQL server can access the network shared folder or not. The DNS may have problem to resolve the name, so that you can place target server IP address in SQL Server local host file to resolve the name. Here is location:

    C:\Windows\system32\drives\etc\Hosts


    Jie Ma

  • June 23, 2006 at 7:52 am

    #645539

    Paul, it's a SQLServerAgent service permission trouble. First, if you start SQLServerAgent with LocalSystem account, it's ok but can't access network resources (as any service that uses LocalSystem). I create an special account in my domain for the SQL2K pair (MSSQLServer and SQLServerAgent) with administrative rights to do so, and then in SQL Enterprise Admin i change the service properties for both.

    Regards

    Julio Moreyra

Viewing 5 posts - 1 through 4 (of 4 total)

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