Hi Craig

Thanks for that.
In the SQL Server help file I found

SQLDMOSecurity_Integrated 1 Allow Windows NT Authentication only 
SQLDMOSecurity_Mixed      2 Allow Windows NT or SQL Server Authentication (IntegratedSecurity object only) 
SQLDMOSecurity_Normal     0 Allow SQL Server Authentication only

and in the MSDE readme I found that the parameter

SECURITYMODE=SQL

installs using SQL Server Authentication but have been unable to find the setting for mixed mode.

Do you (or does anyone else) know what that setting is?

Thanks again
Geoff Scott

>Geoff,
>
>Just expanding on what Sergey has given you, this nailed me for ages until I understood why.
>
>SQL server/MSDE has several security modes that it runs in i.e. SQL server, Windows or mixed.
>If the server is setup for Windows security - it ignores your "sa" login and uses the NT login YOU are logged on as. That NT login needs to be given the relevant permission to SQL Server.
>
>I found with MSDE that different installs had different default settings. In the readme file it tells you how to set the default security mode when installing the product.
>
>Hi
>I am new to SQL Sever/MSDE and have run into a bit of a problem at the basic level, that of signing in.
>How do I associate a user with a trusted SQL Connection???
>