When using Microsoft Data Link as Data Source, I use SQL Server
authentication with the correct password (including the sa account) I test
the connection and it succeds. However when I try to get the dts package to
use the udl file I get a package error:
Login failed for user 'xxx'.

If I re-enter the password and test the connection it succeeeds. However, If
I try to save the package it fails with the same error. When I use windows
authentication for the udl file I don't get this problem. Any Ideas
appreciated?
--
fhillipo

You might want to consider *not* using a UDL file and supplying the
connection information by other means. UDLs store user credentials in
plain text, and are a considerable security risk. That being said, the
fact that it works with Windows authentication indicates that it may
be a problem with the SQL login you are using. Check to make sure that
it is a valid SQLS login and has the necessary permissions to the
resources you are trying to access.

--Mary

On Wed, 12 Jan 2005 02:07:02 -0800, "fhillipo"
<fhillipo (AT) discussions (DOT) microsoft.com> wrote: