Create a SQL Login user in SQL Server 2008

This article will give a walkthrough on creating a SQL Login user.

Step 1

Login to SQL Server 2008 instance using windows authentication

clip_image001

Step 2

Right click on server instance name and select properties.

clip_image002

Step 3

Property window will be open. In that select the Security tab.

clip_image004

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 .

clip_image005

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 .

clip_image006

Step 5

When you click on Login you will get the below window

clip_image008

Give the Login Name

clip_image009

Select SQL Server Authentication and provide your desired password

clip_image010

Disable Enforce password policy

clip_image011

Select default database

clip_image012

Leave default language and click OK to create a new SQL Server login

Now in object explorer you can see User1 login .

clip_image013

Now at time of connecting to SQL Server login User1 can be used.

4 thoughts on “Create a SQL Login user in SQL Server 2008

  1. esa disgrasa num presta ñ
    qando vai si conectar fl error:18456 o trem disgrasdo qem saber de alguma coisa ai mi fl pf

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s