Overview
Adding a SQL Server Login
Editing a SQL Server Login
Removing a SQL Server Login
Overview
SQL Server logins provide a means for authenticating connections made to the SQL Server database.
A login may include database users to allow access to a particular database.
Adding a SQL Server Login
To add a new login click the Create new Login link located towards the upper right hand of
the screen. The following table describes the fields that are necessary in order to create a new login:
Authentication Method |
Determines whether you want to use Windows Integrated or SQL based authentication. |
Login Name |
Name of the SQL login you wish to create. This should be the same as the Windows login
you wish to use if Windows Integrated is selected as the Authentication Method
(eg: [domainname]\[username]).
|
Password |
The password associated with this login. This property is applicable only when SQL based
authentication is selected.
|
After clicking Create Login you will be sent to the edit screen for that login so that you may
edit additional properties. Please see Editing a SQL Server Login for more information.
Editing a SQL Server Login
After a login has been created, it may be necessary to change the password,
default database, or default language. For example, a user may forget her
password, want to change the password for security reasons, need to use a
different database on a regular basis, or need to see messages in a different
language. When you are done making changes click Save Changes to commit the changes
to the system.
NOTE: This tool does not currently support the ability to update passwords.
You may edit multiple properties which are divided into the following sections:
General, Server Roles, and Database Access.
General
This section allows you to manage general properties.
Security Access |
This option is only applicable when a login uses Windows Authentication. Select
Grant if you wish to grant login access to a Windows NT 4.0 or Windows 2000
account. Select Deny if you wish to deny login access to a Windows NT 4.0
or Windows 2000 account.
|
Default Database |
The default database for this login.
|
Default Language |
The default language for this login.
|
Server Roles
This section allows you to view, add, or remove roles for this login.
Database Access
This section allows you to specifiy which databases this login has access to. When
a login has access to a database a database user is created for that database. See
Database Users for more information.
Removing a SQL Server Login
You can not remove SQL Server Logins with this tool. Please use the SQL Server Enterprise Manager to
perform this operation.
|