Online Documentation for SQL Manager for SQL server

Logins

Microsoft® SQL Server™ uses two ways to validate connections to SQL Server databases:

Windows Authentication which uses Windows-level principals

and

SQL Server Authentication which uses logins to validate the connection.

A login is an indivisible principal which is used to connect to the server and use its resources.

Login Editor allows you to define login properties. It opens automatically when you create a new server login and is available on editing an existing one.

To open a login in Login Editor, double-click it in the DB Explorer tree or in the Login Manager. Alternatively, you can right-click the login alias and select the Edit Login context menu item.

• Setting login parameters
• Allocating members
• Defining server permissions
• Defining server role permissions
• Defining endpoint permissions
• Defining database permissions
• User mapping
• Viewing DDL definition