MSSQL: Users and databases

Security -> Logins (right click) -> New Login
    Login name: sql-guid-local
    (X) SQL Server authentication

Databases -> sql-guid -> Security -> Users (right click) -> New User
    User name: sql-guid-local
    (X) Login name: sql-guid-local
    Database role membership
        (X) db_owner

localhost (SQL Server 10.50.1600...) (right click) -> Properties -> Security
    (X) SQL Server and Windows Authentication mode

Databases (right click) -> New Database
    General
        Database name: sql-guid
        Owner: <default>
        Initial size, Autogrowth, ...
    Options:
        Recovery model: Full
        Compatibility level: SQL Server 2008 (100)