Written by James McDonald

November 12, 2007

Trying to get an MSDE going with the SQL gui. These are my personal notes.

osql -U sa -S SERVER\INSTANCE
Password: ******

1. Give the group the ability to login to the MSDE Instance

use master
go
EXEC sp_addlogin ‘DOMAIN\domainGroup’
go

2. Grant Access to DB (still won’t be able to edit tables / data)
use dbname
go
exec sp_grantdbaccess ‘DOMAIN\domainGroup
go
Granted database access to ‘DOMAIN\domainGroup’

3. Give the group admin access to the db to allow editing etc.
EXEC sp_addrolemember ‘db_owner’ , ‘DOMAIN\domainGroup’
go
‘DOMAIN\domainGroup’ added to role ‘db_owner’.

0 Comments

Submit a Comment

Your email address will not be published. Required fields are marked *

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

The reCAPTCHA verification period has expired. Please reload the page.

You May Also Like…