Reader Level:
ARTICLE

Create a SQL Login User in SQL Server 2008

Posted by Dhananjay Kumar Articles | SQL Server September 28, 2010
This article will give a walkthrough on creating a SQL Login user.
  • 0
  • 0
  • 56590

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

  1. Windows authentication mode

  2. 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.

COMMENT USING

Trending up