• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 736
  • Last Modified:

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?
0
FMCP
Asked:
FMCP
  • 2
  • 2
1 Solution
 
Joe WoodhousePrincipal ConsultantCommented:
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
 
FMCPAuthor Commented:
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
 
Joe WoodhousePrincipal ConsultantCommented:
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
 
FMCPAuthor Commented:
I'll just reinstall. Thanks. :)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now