Hi,
I have a DTS, there is a connection in it. I use the use
sa to connect, but I got "Login failed for user "sa"". I
can login by sa in QA. what's the problem? Thanks

In article <015501c3a235$5518c940$a401280a (AT) phx (DOT) gbl>, Jen
<anonymous (AT) discussions (DOT) microsoft.com> writes
Double check the details, name (including resolution if on different
machines) and password. There is nothing special about the connections
in DTS. If this happens after the connection has been setup then it may
be this-

Recurring login failed for user 'xyz' errors
(http://www.sqldts.com/default.aspx?267)
--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org