Getting Started with SQL Database - Pro SQL Database for Windows Azure - page 16

At this point, you should have a new login available called test . However, you can't log in until a user has been
created. To verify that your login has been created, run the following command, for which the output is shown in
Figure 1-12 :
select * from sys.sql_logins
Figure 1-12. Viewing a SQL login from the master database
If you attempt to create the login account in a user database, you receive the error shown in Figure 1-13 . The login
must be created in the master database.
Figure 1-13. Error when creating a login in a user database
If your password isn't complex enough, you receive an error message similar to the one shown in Figure 1-14 .
Password complexity can't be turned off.