I'm new in MSDE and I do not know how to create a db user, running MSDE in SQL Authenticfication mode.
I can create a user using osql :
osql -E -S myserver -Q"sp_grantlogin @loginame = N'myserver\myadmin'"
and i assigned this user sysadmin role.
But when I try to connect to the db with this user, I get the following error: Login failed : reason : user not associated with a trusted SQL Server Connection.
Can anyone help me please?
Thanks a lot in advance
Your problem is that you create a sql server login and the msde is set to accept only windows accounts as a login. So you have use a windows account for your login. Another solutions is to set the authentication mode of the database to "mixed" but I'm not sure if this is possible in msde.
First of all, thanks for your answer.
Yes, I set the mode to be a mixed Authentification, it is possible at least by modifying a registry key.
I 'm now able to create a user but i can not manage to open its default db.
here are my commands :