Thursday, February 9, 2012

Adding a user to a database in SQL Server Management Studio Express?

Can someone provide me with instructions or a link on how to add a user to a database using SQL Server Management studio Express?

I also would like to know how you set the db_owner permission to the user?

My host has an sql express database and I would like to use the same connection string on my local machine, but need to set up the username/pw on the database locally.

Thanks

go to the security tab of the management express

in the object explorer. double click logins to expand

right click and then add new user

from there you can grant the user access to database.

you can also open the database to add new user to it when you

already created a login in the security tab

No comments:

Post a Comment