Solved

Sybase Rep Server - SA Permission is required to execute command

Posted on 2008-06-24
4
707 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

No single Antivirus application (despite claims by manufacturers) will catch or protect you from all Virus / Malware or Spyware threats. That doesn't stop you from further protecting yourself however - and this article is to show you how.
Active Directory security has been a hot topic of late, and for good reason. With 90% of the world’s organization using this system to manage access to all parts of their IT infrastructure, knowing how to protect against threats and keep vulnerabil…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

735 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