Online Documentation for SQL Manager for SQL server
Microsoft® SQL Server™ uses two ways to validate connections to SQL Server databases:
Windows Authentication which uses Windows-level principals
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.
- Setting login parameters
- Allocating members
- Defining server permissions
- Defining server role permissions
- Defining endpoint permissions
- Defining database permissions
- User mapping
- Viewing DDL definition