SQL Server Performance Forum – Threads Archive

Drive mapping without login to server

Hi, I have a remote server with SQL Server 2000. There is another server which have some text files. Everytime I boot the remote server, I need someone on the server login and then map a drive letter, say S:, to the place that text files are located on the second server. Then applications or DTS packages can access to that S: drive and import those text files. The remote server must always be logged in and we just LOCK it. If the remote server is boot, then there is no access to S: (cause it is not mapped yet) until someone login and MAP process is done. Is there a better way to map a path without login to server? Thanks,
Farhad

---

Software exists to do this and other things during startup. One example:
http://www.greyware.com/software/autoexec/index.asp Some free software might exists as well.

---

Alternatively using UNC paths would be more secure… Cheers
Twan

---

I think in WINDOWS EXPLORER while mapping network drive you can enable it to ‘Reconnect at logon’. Otherwise as suggested by Twan using of UNC names as a starting step in DTS step or another job would be ideal. HTH Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

---

Thanks Twan, Assume that I have to read the text data from //MyServer/Shared/TextFiles/
Then should I have view and read access rights to the above UNC path? How server will recognize me to issue such rights when I am running a stored procedure which calls the DTS package to read the text file? Where can I find How-To information and examples about security setting in SQL Server? The above problem got at lease this week of my time and still I was unable to handdle it. I appreciate all replies in advance. Farhad

---

More to go fromhttp://www.microsoft.com/sql/techinfo/administration/2000/security/default.asp here. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

---

]]>