Window Authentication Login User in SQL Server
#SQL Server Security
Creating window authentication login user to access sql server database. Window authentication is termed secure as compared to sql authentication.
To add a window-authentication login to SQL server:-
- Create a domain , local or group user .
- Add it to sql server instance.
- Add user on each database on which access require.
- Add map user / assign access
Open Computer Management (type [compmgmt.msc] in Run (window + R))
>> System tools > Local Users and Groups
Create new user (Right click on Users & click new user)
Open SQL Server Management Studio (SSMS): Window+R & Type [SSMS]
Create New User
Search for window user
Change location if you wants to fetch user from domain[Active Directory(AD)].
Click on advance and Find Now
Click Ok button
Follow User Mapping to provide mapping to database for accessing with (SunitKanyan) window user.
new user created with read only access on Database [AuditDB]
Switch user to SunitKanyan & login SQL server
Tried another database which does not have permission (ssms show database inaccessible).
Active directory user also used to create window authentication sql login user.