After learning the hard way that SQL Server authentication is not enabled by default, we were finally able to CREATE LOGINS and USERS.

    CREATE LOGIN foo WITH PASSWORD = 'p@$$W0rd';
    CREATE USER FOR LOGIN foo;

We also learned that dropping the LOGIN before the USER will leave the USER orphan and we will not be able to drop the USER especially if the USER owns any object.

Download the class notes for day 5.

This entry is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International license.