... until the collector arrives ...

This "blog" is really just a scratchpad of mine. There is not much of general interest here. Most of the content is scribbled down "live" as I discover things I want to remember. I rarely go back to correct mistakes in older entries. You have been warned :)

2004-12-13

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).

Blog Archive