?
Solved

MS SQL db ccount question

Posted on 2016-08-12
3
Medium Priority
?
83 Views
Last Modified: 2016-08-18
HI

What account in SQL will give me rights to execute Replication and copy DB?

I can't use sysadmin account


What rules accounts will allow execute this kind of task?

Please advice, M
0
Comment
Question by:michalek19
3 Comments
 
LVL 75

Accepted Solution

by:
Aneesh Retnakaran earned 1000 total points
ID: 41754036
0
 
LVL 53

Assisted Solution

by:Vitor Montalvão
Vitor Montalvão earned 1000 total points
ID: 41755999
You'll always need sysadmin role to enable a SQL Server instance to be a Distributor, Publisher, or Subscriber. As you'll need the same role to enable a database for replication.
If you can get a DBA to enable those for you then you'll need to be db_owner of the database to create the desired replication.
0
 

Author Comment

by:michalek19
ID: 41756945
can you create tasks, schedule tasks as db_owner
0

Featured Post

Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
How to deal with a specific error when using the Enable-RemoteMailbox cmdlet to create a mailbox in the cloud-based service, for an existing user in an on-premises Active Directory.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
This tutorial will walk an individual through the process of configuring their Windows Server 2012 domain controller to synchronize its time with a trusted, external resource. Use Google, Bing, or other preferred search engine to locate trusted NTP …

864 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question