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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy