• Managing Users
  • Populating the User List
  • Connect to Active Directory Server dialog
  • Active Directory Import
  • Importing users and groups from Active Directory
  • Adding users from the Windows Active Directory
  • Active Directory tab
  • Enabling Windows Active Directory
  • Active Directory Integration dialog
  • Adding a Login Using SQL Server Management Studio
  • Using LDAP Import Filters

Adding a Login Using SQL Server Management Studio

When Windows Authentication is turned on you must login through the SQL server. If your login is not recognized you will not be able to login. You can add logins to SQL Server Management studio. This is useful when Windows Authentication is turned on for a SQL Data Store.

Prerequisites

Ensure SQL Server Management Studio is installed on your machine (bundled with the SQL Server installation package).

Procedure

1. Launch SQL Server Management Studio.
2. Login using your credentials. Click Connect.
3. Navigate into the folders Security | Logins.
4. In the Logins window, right-click and select New Login.
5. Specify all of the fields in the Login - New dialog. Click OK.

Results

Your login has been created. Reattempt logging into Data Store if you were having issues.

Related Topics

• Create/Connect
• Connecting to a Data Store