This article will give a walkthrough on creating a SQL Login user.
Step 1
Login to SQL Server 2008 instance using windows authentication
![Image1.gif]()
Step 2
Right click on server instance name and select properties.
![Image2.gif]()
Step 3
Property window will be open. In that select the Security tab.
![Image3.gif]()
In server authentication tab you can see your SQL Server in configured for
-
Windows authentication mode
- SQL Server and Windows Authentication mode
So if you want to enable SQL User login to SQL Server then select checked mixed
mode here .
![Image4.gif]()
And then click ok. Now SQL Server is configured for mixed mode login.
Step 4
Now to create SQL LOGIN, right click on Security tab and select New and then
Login .
![Image5.gif]()
Step 5
When you click on Login you will get the below window
![Image6.gif]()
Give the Login Name
![Image7.gif]()
Select SQL Server Authentication and provide your desired password
![Image8.gif]()
Disable Enforce password policy
![Image9.gif]()
Select default database
![Image10.gif]()
Leave default language and click OK to create a new SQL Server login
Now in object explorer you can see User1 login .
![Image11.gif]()
Now at time of connecting to SQL Server login User1 can be used.