How to create new user login to SQL Server.

When we install Microsoft SQL Server Management Studio 2005, during instaltion it will asked the password for SA account (Sa is a default login to SQL Server). In that step provide suitable password for default Sa account. After installed the Sql Server.

You can create user login accoding to your preferences.

1st step:

First of all it is must to loged in using SA account. After loged SA account go to Security of that account and it contain login and by write clicking you can add new login. Figure 1 show that how to create new login to SQL Server.


















Figure 1 show that how to create Logins

2nd step:

After create logins, in the Genereal Tab of that open form, it ask what is login name, password and what is default data base and so on by providing that information. Figure 2 show that how to add login details.

















Figure 2 show that how to add login details

3rd step:

Next in Server Role on Select page click. It provide such a form Figure 3.
In that select sysadmin.

















Figure 3 show Server Role

4th step:

Next select Securables and it gives such a form Figure 4. In that form should select the server which we decide to use to create Logins.















Figure 4 show that how securable handle

5th step

Next should provide the status of the Logins. Figure 5 show that how to provide Permision to the data base.

















Figure 5

After following above steps carefully it will be create new logins.

Your Comments are highly appreciated; it will be improving my knowledge also.