{"id":2447,"date":"2013-10-31T15:14:51","date_gmt":"2013-10-31T05:14:51","guid":{"rendered":"http:\/\/support.cybersecure.com\/?p=2447"},"modified":"2014-10-13T12:10:48","modified_gmt":"2014-10-13T02:10:48","slug":"how-to-grant-privileges-to-a-user-with-sql-management-studio","status":"publish","type":"post","link":"http:\/\/support.cybersecure.com\/?p=2447","title":{"rendered":"How to add a dedicated SQL backup service account"},"content":{"rendered":"
    \n
  1. Open SQL management studio<\/li>\n
  2. Connect to the session as an appropriate admin user (this can be done using either Windows or SQL authentication) to the SQL instance<\/li>\n
  3. Expand Security->Logins<\/li>\n
  4. Right-click Logins and choose “new Login”
    \n\"\"<\/a><\/li>\n
  5. Add the backup service account details, ensuring that you select SQL authentication and deselect “enforce password policy”
    \n    \"\"<\/a><\/li>\n
  6. Select “User mapping” on the left-hand panel tab, and ensure that ” db_backupoperator is ticked for the databases you wish to backup – you do not need to alter or add any other privileges.
    \n    \"\"<\/a><\/li>\n
  7. Choose OK<\/li>\n
  8. Now the backup agent should be able to use this SQL service account to backup the selected databases.<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"

    Open SQL management studio Connect to the session as an appropriate admin user (this can be done using either Windows or SQL authentication) to the SQL instance Expand Security->Logins Right-click Logins and choose “new Login” Add the backup service account … Continue reading →<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[7],"tags":[],"_links":{"self":[{"href":"http:\/\/support.cybersecure.com\/index.php?rest_route=\/wp\/v2\/posts\/2447"}],"collection":[{"href":"http:\/\/support.cybersecure.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/support.cybersecure.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/support.cybersecure.com\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/support.cybersecure.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2447"}],"version-history":[{"count":5,"href":"http:\/\/support.cybersecure.com\/index.php?rest_route=\/wp\/v2\/posts\/2447\/revisions"}],"predecessor-version":[{"id":2743,"href":"http:\/\/support.cybersecure.com\/index.php?rest_route=\/wp\/v2\/posts\/2447\/revisions\/2743"}],"wp:attachment":[{"href":"http:\/\/support.cybersecure.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2447"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/support.cybersecure.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2447"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/support.cybersecure.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2447"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}