Using UNC Path in SQL Server

[FarhadR]

I am testing useage of UNC path in a DTS package. This DTS imports a text file into a table. The text file is located on File Server. I have set up a DTS package which uses UNC path to grab the text file from the File Server. While the first server can 'see' the File Server, the DTS works perfectly.

Question is that if I reboot the first server and don't login, then the server shouldn't be able to 'see' the File Server. What happens to my DTS package? Does it fail? My test shows that it would fail if my machine is not able to access the File Server.

Therefore, is it true that we can use UNC only when our machine or the server has at least read right on the File Server?

How can I use UNC path without need to login the File Server? I have heard that I can create a SQL user that has access to the File Server but I don't know how.

I appreciate all your replies.

 

[Corran007]

how will the dts package be run? if its from a job, the job owner needs permissions to acess the file loaction. if you are calling it from something like vb. the user you supply needs permission.

its all about the user. if your in a domain, the owner should be a domain user.

 

[FarhadR]

I have Domain\sqladmin which is a domain user id. I use it for FTP to the server. Also, I was able to map to the server using this id.

In SQL-Server EM I have the Domain\sqladmin id as windows user under Security->logins. This id is Server Admin and Sys Admin in EM. It also have permissions to all my DBs. But I can not connect to the server using this id in QA. Even in EM I tried to use it but I was not able to connect. Why?

 

[SQLBill]

All that doesn't matter. Right click on My Computer icon. Select Manage. Expand Services and Applications. Click on Services. In the right window, find the SQL Server services. What login do they use? That's what needs to have a Domain account to be able to access a network drive.

-SQLBill