VB6.0 and SQL server 2000

[Sonia]

Hi.
I have problem on connecting my DB to application which written in VB6.0.

when I want to connect the appl. to SQL server2000 it says that:

"Login failed for user 'sa'.Reason: Not associated with a trusted SQl server connection."

any help will be appriciated.

[pclement]

Sounds like a configuration issue. Since you are attempting to use integrated security I would make certain the authentication mode in SQL Server is set to Mixed (Integrated and SQL Server).

Also, you would need to be in a domain based networking environment (not just a workgroup environment).