From further investigation it appears that MSDE only had two modes
1 Windows NT Authentication
2 Mixed mode (Windows NT or SQL Server Authentication)
Regards
Geoff
>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???
>>
May all your weeds be wildflowers