Logins Wizard (SQL Server)
Go Up to Microsoft SQL Server Object Wizards
The Login wizard lets you build and submit a CREATE LOGIN statement, adding a new SQL Server, Windows, certificate-based, or asymmetric key-based login. The Login wizard also lets you:
- Add the login to fixed server roles
- Create user accounts for the login on selected databases
To create a new login using a wizard:
- Open a creation wizard for alogin. For details, see Opening an Object Wizard.
- Use the following topics as a guide to setting properties and performing tasks as you pass through the wizard panels:
- Properties panel - for details, see Logins (SQL Server) - Properties.
- Server Roles panel - for details, see Logins (SQL Server) - Server Roles.
- Users panel - for details, see Logins (SQL Server) - Users.
- DDL View panel - for details, see Previewing the DDL Generated to Create the New Object.
- Finally, use the Execute button to create the object.
Logins (SQL Server) - Properties
When creating or editing a login, this tab/panel lets you work with the following properties:
Setting | Description |
---|---|
Name |
Specifies a name for this login. |
Default Database |
Lets you specify a DEFAULT_DATABASE argument, specifying a default database for this login. |
Default Language |
Lets you specify a DEFAULT_LANGUAGE argument, specifying a default language for this login. |
Account Type |
Lets you select one of the following login types: STANDARD - (SQL Server logins) if you select this type, you must also provide Password and Check Policy values. NTGROUP or NTUSER - (Windows logins) if you select one of these types, you must also provide a Domain value. CERTIFICATE - (certificate-mapped logins) if you select this type, you must also provide a Certificate value. ASYMMETRIC KEY - (asymmetric key-mapped logins) if you select this type, you must also provide an Asymmetric Key value. |
Password |
This is only available for an Account Type of STANDARD. It lets you provide a password for the login. |
Check Policy |
This is only available for an Account Type of STANDARD. If selected, login policies defined on the server apply to this login. |
Check Expiration |
This is only available if Check Policy is selected. If selected, password expiration policies are applied to this login. |
Must Change |
This is only available if Check Expiration is selected. If selected, the user will be prompted to change the password on the first login. |
Domain |
This is only available for an Account Type of NTUSER or NTGROUP. Lets you specify the domain name value that will be specified with the loginName argument ([<domainName>\<loginName>]). |
Certificate |
This is only available for an Account Type of CERTIFICATE. It lets you specify the name of a certificate that is to be associated with this login. It lets you specify the name of a certificate that is to be associated with this login. |
Asymmetric Key |
This is only available for an Account Type of ASYMMETRIC KEY. It lets you specify the name of an asymmetric key that is to be associated with this login. |
Logins (SQL Server) - Server Roles
When creating or editing a login, this tab/panel builds sp_addsrvrolemember procedure calls that will be submitted along with the CREATE LOGIN statement issued by this wizard/editor. This lets you add the login as a member of one or more fixed server roles (or common user-defined roles when selecting multiple databases) by selecting the check boxes associated with those roles.
For information on editing fixed server roles, see Roles Editor (SQL Server).
Logins (SQL Server) - Users
When creating or editing a role, this tab/panel lets you build CREATE USER... FOR LOGIN statements that will be submitted with the CREATE LOGIN statement issued with this wizard/editor. Maintain database user accounts for a login as follows:
- Add a user account for this login to a database by selecting a database from the Databases where the Login does NOT have a User Account and clicking the Add button. This opens the SQL Server User wizard, letting you define a new user on that database. For more information, see Users Wizard (SQL Server).
- Remove a user account for this login from a database by selecting a database from the Databases where the Login HAS a User Account and clicking the Remove button.