Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Permissions for SQL Server Expand / Collapse
Posted Thursday, January 20, 2011 10:43 AM



Group: Administrators
Last Login: Today @ 8:38 AM
Points: 34,366, Visits: 18,586
This can be tricky, but can someone explain how the SQL Server service account actually is used for processes like backups, attaching dbs, etc and how to check it's permissions? Maybe show an example of where you have rights from your account to a folder for backup, or moving an MDF, but the service account does not and how to fix this.

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1051001
Posted Thursday, January 20, 2011 11:19 AM



Group: General Forum Members
Last Login: Today @ 8:47 AM
Points: 7,506, Visits: 8,658
I'll give it a shot.

Brandie Tarvin, MCITP Database Administrator

LiveJournal Blog:
On LinkedIn!, Google+, and Twitter.

Freelance Writer: Shadowrun
Latchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.
Post #1051043
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse