February 7, 2008 at 3:21 pm
Hello.
I have an application that uses stored procedures to access (READ) .CSV files on the network (AD). These .CSV files are in a folder that is accessible only by users in a particular Windows AD group.
What is the best way to access these files?
Should I configure my SQL Server Agent to use a Windows Domain user account and add that user to the group with access to the folder? Or, should I use a Proxy Account with the Windows Domain user account? If it is a Proxy Account, can you please explain how I would be able to use it without modifying the application's stored procedures?
Any help is greatly appreciated.
Thank You,
TG
February 7, 2008 at 5:10 pm
You can use a windows domain account to access the file in the network share path so that you can avoid authentication problems with the shared file.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
February 8, 2008 at 6:05 am
Sugesh Kumar (2/7/2008)
You can use a windows domain account to access the file in the network share path so that you can avoid authentication problems with the shared file.
Thank you Sugesh!
Is it possible to use a Proxy account in this situation without modifying the stored procedures?
Thanks!
TG
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply