Users require a login account to access SQL Server(Database Engine). By default, the administrator of the computer have full access to SQL Server.
If you want to have a less privileged user, you will have to create a new local Windows Authentication account
on your computer. To do this, you must be an administrator on your computer. Then you will grant that new user access to SQL Server. Create a new Windows account
1. Click Run
in the Start
menu, type %SystemRoot%\system32\compmgmt.msc /s
, and then open the Computer Management program.
2. Create New User
by right clicking on the Users
under Local Users and Groups
of System Tools
3. In the User name
box type ABC
4.In the Password
and Confirm password
box, type a strong password, and then click Create
to create a new local Windows user.
After creating Windows account by following above instructions, create Login for that user in SQL Server by executing the below query in Query Editor of SSMS.
CREATE LOGIN [computer_name\ABC]
WITH DEFAULT_DATABASE = [TestData];