|
Discuss about SQL Server Login.- SQL server login is used to connect to SQL server.
- It is used when the windows login credentials is not existent.
- This is possible when SQL Server is configured to operate in Mixed Mode.
- SQL server login is typically needed when applications are connected to external vendors or for users who don’t have any windows NT/2000 account.
- It provides securable entities through authentication and authorization.
- Authentication is the process of logging on to SQL server. It establishes the identity of the user or process being authenticated.
- Authorization is the process of determining the securable resources.
|
