New User Creation and Admin User Creation in SQL Server 2012

1. Open ssms2012

Image1.jpg

2. Right Click the Security Tab then new->login

Image2.jpg

3. When you click that a new window open like this,

Image3.jpg

4. Give new instance name then choose which login method you have to use better you create SQL Auth for Security and maintenance plans mainly this login is helpful.

Image4.jpg

5. Then pick the default database as well as language then click Ok button.

Image5.jpg

6. After creating user check whether created or not in the security ->logins tab.

Image6.jpg

Ebook Download
View all
SQL Jobs
Read by 0 people
Download Now!
Learn
View all