Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Setting up a DTS Job with SQL Authentication vs Windows

Status
Not open for further replies.

ibethea

MIS
Feb 8, 2002
20
US
Are there advantages and/or Pitfalls to using SQL authentication with an administrator account for DTSs .vs. just using a windows account for authentication?
 
IBETHA,

From my limited experience, it depends on what your script is doing. If you need to access any files on the network, You need to use a domain account that has access to the network.

BigMickeyD
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top