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.
How do I allow users to run replication without assigning SA rights? Thanks.
Microsoft SQL Server 2005
Last Comment
barnesco
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.
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
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Ok, thank you.