FMCP
asked on
Sybase Rep Server - SA Permission is required to execute command
I setup replication server and configured it. I am able to use sybase central to step through the process of creating the environment. When the wizard tries to finish, right after it tries to create the primary connection to the database that is being replicated, I get the error "SA Permission is required to execute command."
Unfortunately, it doesnt tell me what command its trying to execute or what exactly needs SA permission. In an attempt to simply get past the issue I gave the sa_role to basically every login that has to do with replication on the replication database and the replicate database including the primary, maintenence, and replication agent logins.
What am I missing?
Unfortunately, it doesnt tell me what command its trying to execute or what exactly needs SA permission. In an attempt to simply get past the issue I gave the sa_role to basically every login that has to do with replication on the replication database and the replicate database including the primary, maintenence, and replication agent logins.
What am I missing?
ASKER
Yeah, I think that is the issue. I cant login to rep server itself as sa though. Its complaining of an incorrect password it looks like. Yes, I know I should know the password :) however, I thought I did. The password I thought I used when I configured the whole thing isnt working. Obviously I screwed something up. The question is how do I reset the sa password within rep server without already having it? Do I need to remove the rep server itself and re-install/configure it or is there a shorter way?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I'll just reinstall. Thanks. :)
Try "grant sa to [user]" within RepServer.