Hi All we have a lot of DTS packages in our production SQL server. some use windows authentication to connect to the server. i'm thinking if the windows authentication affects the package running if the id of windows authentication doesn't exist. or how this windows authentication deals with security issue when the connection takes place.
Hi, here are some article FYI, and as always refer BOL: http://www.databasejournal.com/features/mssql/article.php/3341651 http://www.developer.com/tech/article.php/721441 http://www.axosoft.com/support/docs/web/flash/OnTime_2006_Overview/How_authentication_works.htm Hemantgiri S. Goswami ghemant@gmail.com "Humans don't have Caliber to PASS TIME , Time it self Pass or Fail Humans" - by Hemantgiri S. Goswami ------------------------ http://hemantgirisgoswami.blogspot.com
Are you mapping network drives requiring windows authentication to access it, but you don't know to do so??
thank you, All actually the following is the answer i'm looking for: How are Windows NT-authenticated Connections Made? Sometimes a DTS package contains an object that makes a connection to a data source using Windows NT authentication. The security context used for this connection is the same as the context of the package that is running. If the package is run from a command prompt by using DTSRun.exe, the credentials of the currently logged-in Windows NT account is used. If the package is run as a SQL Server Agent job, then the integrated security connection is made using the account you used to start SQL Agent (assuming that the owner of the package is a member of the Sysadmin role).