SQL server connection to network share

Question

SQL server connection to network share

Paul J Sweeney

SSC Enthusiast

Points: 100
More actions
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

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

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

jiema SSC-Addicted Points: 486 More actions · Answer 1

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

Paul J Sweeney SSC Enthusiast Points: 100 More actions · Answer 2

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.

jiema SSC-Addicted Points: 486 More actions · Answer 3

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

Julio Daniel Moreyra Valued Member Points: 70 More actions · Answer 4

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