sql server replication: Juan,
what errors do you see? Presumably the same errors appear in control panel,
services if you configure it there?
Regards,
Paul Ibison

I´m trying to deploy a set of SQL servers which will act as
publishers/suscriptors. First, I´d like to perform a test and show the
results to my boss. The first problem I have is the following: When I try
to configure one of the servers as the publisher, by running the wizard I
get the following error:

"SQL Agent Server \\Monica is using the system account what will produce a
failure in the duplication between servers. Set another account in the
following dialog box.."

When I try to set another account in the above metioned dialog box, I
always get a row of errors. Could someone help me? I´ve done this before but
never had this kind of problems, any help will be appreciated.

Regards,

Juan

When I try from the control panel I get "error 5. Denied access.". I try to
start the service using a new user with advanced user permissions.... ¿?

Regards,


Juan
"Paul Ibison" <Paul.Ibison@Pygmalion.Com> escribió en el mensaje
news:Oi$iftrLEHA.2012@TK2MSFTNGP11.phx.gbl...
[quoted text, click to view]

Juan,
are you a local administrator on the sql server box?
Cheers,
Paul

what happens when you open a command prompt and go to c:\program
files\microsoft sql server\mssql\binn and then type sqlservr -con
[quoted text, click to view]

The account you are logged in with doesn't matter. The account the SQL
Server Agent is running under is where you start troubleshooting security.

--
Mike
Principal Mentor
Solid Quality Learning
"More than just Training"
SQL Server MVP
http://www.solidqualitylearning.com
http://www.mssqlserver.com

Hi,

No, I´m using two users with priviledged rights. But finally I could not
get it to work. The problem now is that the suscriber doesn´t connect to the
publisher. If I try to connect from the subscriber to the publisher the
weird error I get is that the subscriber cannot find the publisher (looks
like it searches for a computer with a different name, I cannot figure out
why....) and if I try to force the publisher to subscribe the subscriber the
error is "user (null) has no permission to log into the server" (it´s not an
exact quote but more or less....)

My guess is that the problem is users and permissions in both computers.
In both of them the user logged is Administrator (local administrator), and
the permissions on the databases are different (maybe). But I still had no
time to test it.

Cheers,

Juan

"Paul Ibison" <Paul.Ibison@Pygmalion.Com> escribió en el mensaje
news:#qVA4msLEHA.1644@TK2MSFTNGP09.phx.gbl...
[quoted text, click to view]

Juan,
it's worth verifying the basic setup. To make things simple you could: start
sql server service using a domain user local administrator account. Have the
same account start the sql server agent service. Use the same account on
publisher and subscriber (also local admin here). Add the subscriber to the
list of applicable subscribers for the publication. There are many
variations that will work, but you can use this as a starting point.
Regards,
Paul Ibison