I have configured the job on the SQL Adapter in two different machine using
the UDL file to access the database. In one machine the job works fine and
extract the data from the sql server to biztalk and producess a  flat file.
The other machine the jobs keeps on failing with an error that says  i have
entered a wrong user name and password, but my question is how is that
possible cause is the same UDL File, i have not made any changes to the
file. Can someone explain this to me?

[ Post a follow-up to this message ]

If the UDL file specifies that "Windows Integrated Security" should be
used then you have found the problem..

Jan Eliasen

On Mon, 12 Jul 2004 14:23:33 +0200, "MANDLA MKHWANAZI"
<mandlam@avision.co.za> wrote:

>I have configured the job on the SQL Adapter in two different machine using
>the UDL file to access the database. In one machine the job works fine and
>extract the data from the sql server to biztalk and producess a  flat file.
>The other machine the jobs keeps on failing with an error that says  i have
>entered a wrong user name and password, but my question is how is that
>possible cause is the same UDL File, i have not made any changes to the
>file. Can someone explain this to me?
>

--
Jan Eliasen, representing himself and not the company he works for.

[ Post a follow-up to this message ]

On the UDL file i am not using the Windows Integrated Security i have a user
that is allocated to that specific database which i am using that user and
the password. This works on one machine but the other machine fails because
of the user and password. Now my question is how can this be if i am
accessing the same database from different machines using the same user and
the password, the other machine connects fine but the other fails because of
the user name and password cause thats what the error says invalid username
or password.
"Jan Eliasen" <spam@eliasen.dk> wrote in message
 news:9dbff0t40g51ds6jcj9mf71g6l9vq2bf78@
4ax.com...
> If the UDL file specifies that "Windows Integrated Security" should be
> used then you have found the problem..
>
> Jan Eliasen
>
> On Mon, 12 Jul 2004 14:23:33 +0200, "MANDLA MKHWANAZI"
> <mandlam@avision.co.za> wrote:
> 
using[vbcol=seagreen] 
and[vbcol=seagreen] 
file.[vbcol=seagreen] 
have[vbcol=seagreen] 
>
> --
> Jan Eliasen, representing himself and not the company he works for.

[ Post a follow-up to this message ]