Solved

Sybase Rep Server - SA Permission is required to execute command

Posted on 2008-06-24
4
706 Views
Last Modified: 2008-06-26
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?
0
Comment
Question by:FMCP
  • 2
  • 2
4 Comments
 
LVL 24

Expert Comment

by:Joe Woodhouse
ID: 21861902
It might be that it's complaining about SA permissions within Rep Server itself, rather than within ASE.

Try "grant sa to [user]" within RepServer.
0
 

Author Comment

by:FMCP
ID: 21865329
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?
0
 
LVL 24

Accepted Solution

by:
Joe Woodhouse earned 500 total points
ID: 21871009
If you haven't actually done anything with the RepServer it may be faster to reinstall it, yeah.

Failing that I think we can fool around with it's RSSD (unless you used an embedded RSSD) and hack a password there. Reinstalling doesn't take that long though and it will definitely work. 8-)
0
 

Author Comment

by:FMCP
ID: 21875043
I'll just reinstall. Thanks. :)
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you are looking at this article, you have most likely been hit by some version of ransomware and are trying to find out if there is anything you can do, or what way you should react - READ ON!
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

840 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