Solved

Sybase Rep Server - SA Permission is required to execute command

Posted on 2008-06-24
4
696 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

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

Restoring deleted objects in Active Directory has been a standard feature in Active Directory for many years, yet some admins may not know what is available.
Is your company's data protection keeping pace with virtualization? Here are 7 dynamic ways to adapt to rapid breakthroughs in technology.
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

707 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now