November 18, 2005 at 11:26 pm
Hi,
Actually this is a follow up question regarding my post last june... =)
regarding the DTS, if I logged to the server as a SQL login(not windows authentication) and I have a DTS that generate a file a shared folder in another server, I execute it via enterprise manager, do I need the grant access my windows login or do i need to grant the "everyone" user in the shared folder? based from my last post, the login i used is the one that access the folder assuming i used windows login... any idea? I guess granting "Everyone" in a shared folder is a security issue... =)
:-):cool:
November 21, 2005 at 8:00 am
This was removed by the editor as SPAM
November 21, 2005 at 2:48 pm
If you are running DTS interactively, it will run under your credentials.
If you run it from SQL Server Agent, it will run under whatever account runs the SQL Server Agent service.
Whichever account is running the DTS Package will need read/write permissions.
December 4, 2005 at 7:06 pm
If I run the DTS interactively in my Enterprise manager, the credential it will used to access the windows folder is my windows account even if I used a SQL login to connect to the database?
:-):cool:
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply