>Looks like you set up MSDE 2000 with Windows Authentication. You can use EM to change it to the Mixed mode on the Server property page.

Thanks for your response, Sergey. Just checked and it indicates Authentication: SQL Server and Windows. What else could be the problem?

Alex

>
>>I was able to setup MSDE 7 so that another developer could access it using the enterprise tools or through a VFP connection which was defined with a connection string without needing a "trusted connection".
>>
>>I have now installed MSDE 2000, and this same method fails. The message is:
>>Connection failed:
>>SQLState: '28000'
>>SQL Server Error: 18452
>>[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'sa'.Reason: Not associated with a trusted SQL Server connection.
>>
>>Is it possible to setup security as before (account and password only) or do I always have to setup trusted connections? Is it the same for full SQL Server 2000?
>>
>>If a trusted connection is required, how do I set it up for developers in other machines?
>>
>>TIA,
>>
>>Alex