Link to home
Create AccountLog in
Avatar of barnesco
barnesco

asked on

SQL 2005 permissions to setup and run replication

I need to allow users to setup and run replication in SQL 2005 without giving them SA rights. I've set up a proxy account and assigned the group to the proxy, but the user is receiving a message that "You must be a member of the sysadmin fixed server role to complete this transaction."

How do I allow users to run replication without assigning SA rights? Thanks.
Avatar of chapmandew
chapmandew
Flag of United States of America image

If you get the error "You must be a member of the sysadmin fixed server role to complete this transaction.", then there isn't much you can do to get around not giving them that permission.
Avatar of barnesco
barnesco

ASKER

But what about all those proxies that allow replication in 2005? What are those about then? I had thought that was the whole reason for having them.
ASKER CERTIFIED SOLUTION
Avatar of chapmandew
chapmandew
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Ok, thank you.