Database Reference
In-Depth Information
Figure 1-12.
Running a simple T-SQL command on SQL Azure
Creating Logins and Users
With SQL Azure, the process of creating logins and users is mostly identical to that in SQL Server,
although certain limitations apply. To create a new login, you must be connected to the master
database. When you're connected, you create a login using the
CREATE LOGIN
command. Then, you need
to create a user account in the user database and assign access rights to that account.
Creating a New Login
Connect to the master database using the administrator account (or any account with the loginmanager
role granted), and run the following command:
CREATE LOGIN test WITH PASSWORD = 'T3stPwd001'
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-13:
