Solved

Sybase Rep Server - SA Permission is required to execute command

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in Office 2013. Users had hopes that it would be in Office 2016/Office 365, but it is not. Fortunately, the same zero-cost technique that works to install it with …
This article aims to explain the working of CircularLogArchiver. This tool was designed to solve the buildup of log file in cases where systems do not support circular logging or where circular logging is not enabled
In this video I am going to show you how to back up and restore Office 365 mailboxes using CodeTwo Backup for Office 365. Learn more about the tool used in this video here: http://www.codetwo.com/backup-for-office-365/ (http://www.codetwo.com/ba…
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.

910 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

20 Experts available now in Live!

Get 1:1 Help Now