SQL Server 2005 distribution agent failed
Home > IT Answers > SQL Server > SQL Server 2005 distribution agent failed
ITKE
10290 pts.
0
Q:
SQL Server 2005 distribution agent failed
SQL Server 2005, SQL Server Distributor, SQL Server error messages
Getting this error message

[code]Only members of the sysadmin or
db_owner roles can perform this operation.

[/code]

Software/Hardware used:
SQL Server 2005
ASKED: Oct 16 2009  5:01 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Mrdenny
47440 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
The account which you are running the distribution agent under isn't a member of one of those roles on the publisher, distributor or subscriber. Correct the permissions and restart the agent.
Last Answered: Oct 16 2009  9:08 PM GMT by Mrdenny   47440 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



0