Sunday, August 16, 2009

SQL Server 2005 Authentication

How a add SQL Login to SQL Server


1-Login to SSMS with Windows Authentication

2-Click on Security/Login

3-RC Login/Add New Login

4-Enter name/Choose SQL Authentication/Enter strong password(8 characters min with
special key @#...) and click OK.

SECOND STEP: Assign grants

1-Login in again with Windows Auth

2-Click on Databases then choose the db on which you want to assign User

3-Go to security(inside the db) then Users

4-RC Users/Add New User

5-Click on Eclipse after Login name and select login will popup

6-Enter first 2 letters of the user you want to add and click on Check Name Button

7-Choose the name of the user you added on first step and click OK twice.

8-Copy the same name on step 7 and paste on the textbox after Username

9-Under Schemas owned by this user choose appropriate schemas especially db_datareader,
db_datawriter,db_datacessadmin,db_owner).You can add more later.

10-Database role membership choose roles for this user(Usually the same as 9) and click OK.

You done with SQL Authentication.
Start SSMS and login with the user and password you just created. Make sure you choose SQL Server Authentication.

No comments:

About Me

My photo
Raleigh, NC, United States
I am a software developer based in Raleigh,NC,USA.I design softwares and systems ;i also do consulting for companies worldwide.I program with these languages:VB.NET 2003/2005/2008;C#;Java(fun),SQL(200,2005,2008);ASP.NET 2.0/3.5;ASP.NET AJAX;ASP.NET MVC;JavaScript;JQuery;Windows Workflow Foundation;Web Services.I have 4 years + in programming.