On your SQL server.
Run Enterprise Manager,
Locate your SQL server
RIght click, properties
Click security
Change the authentication to SQL Server and Windows.

-Mark


>
>Are you talking about the settings when you setup the DSN for first time or is this a setting on SQL Server (if so is it when you define local users)? Sorry for asking such stupid question, I'm new to SQL Server.
>
>Thanks
>Nick Patel