Solved

MS SQL db ccount question

Posted on 2016-08-12
3
48 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 250 total points
Comment Utility
0
 
LVL 45

Assisted Solution

by:Vitor Montalvão
Vitor Montalvão earned 250 total points
Comment Utility
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
Comment Utility
can you create tasks, schedule tasks as db_owner
0

Featured Post

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Join & Write a Comment

Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
OfficeMate Freezes on login or does not load after login credentials are input.
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

762 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now