Adding a new user in SQL Server

Hello,

I need a new user in SQL that has full access to an existing database and the required tables. I would need Mixed Mode turned on so I can use something other than Windows Authentication. I appreciate your help.

I have SQL Server 2008.

Thank,

nimdatx



FROM SSMS ->Security -> logins
right click and select create new login
if you have mied mode enabled on your database , choose windows authentication and put the domain account (or click search and find the user )
once you have the user, click on user mapping from the left pane and choose the database you want to give full permission (set the default schema usually dbo. and on bottom pane choose db_owner ) ..



FROM SSMS ->Security -> logins
right click and select create new login
if you have mied mode enabled on your database , choose windows authentication and put the domain account (or click search and find the user )
once you have the user, click on user mapping from the left pane and choose the database you want to give full permission (set the default schema usually dbo. and on bottom pane choose db_owner ) ..



THANKS!

Two question...

How does it distinguish from windows authentication and SQL if I add a AD account which is windows form of authentication?

I added a AD account is that ok?



for Windows authentication, you don't need to enter the password, for sql authentication, you need to have a password. also there is a check button when you create the logins





Share this

Related Posts

There was an error in this gadget