SQL Server

In the absence of Enterprise Manager, here is how to create and configure a login using OSQL:

1. sp_addlogin 'userid','password','defaultdb'
2. sp_adduser 'userid'
3. sp_addrolemember 'db_owner','userid'

To switch MSDE to use 'mixed mode' authentication, set the registry key:

HKLM\Software\Microsoft\MSSqlserver\MSSqlServer\LoginMode

to '2' ('1' is Windows authentication mode only, the default).