error 14151

1. The server-sql is live
2. The distributor is in the same server.
3. The Publisher is in the same server.
4. Only the suscription is in different server
Tks for you reply and help
Johnny

"Hilary Cotter" wrote in message

 > Is server-sql live? Is your distributor on the same server as your
 > publisher?
 >
 > --
 > Hilary Cotter
 > Looking for a SQL Server replication book?
<font color=purple> > <a rel="nofollow" style='text-decoration: none;' href="http://www.nwsu.com/0974973602.html</font" target="_blank">http://www.nwsu.com/0974973602.html</font</a>>


  >> Hi all,
  >> I got this error this morning... what is the problem? everything was
 > working
  >> fine...
  >>
  >> Executed as user: sqlUser. Replication-Replication Snapshot Subsystem:
 > agent
  >> SERVER-SQL-Jobsheet-Jobsheet-12 failed. The process could not connect to
  >> Distributor SERVER-SQL'. The step failed. [SERVER42000] (Error 14151).
 > The
  >> step failed.
  >>
  >> Tks in advance
  >> Johnny
  >>
  >>
 >
 >
 >> Stay informed about: error 14151 

What do you ge if on your publisher/distributor you run:
Select @@Servername, SERVERPROPERTY('ServerName')
- are the values the same?
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
 >> Stay informed about: error 14151 

Tks for you reply and help Paul
Yes is the same value, the only different thing that I did is to deny
permission for the BUILTIN/Administrators user because I don't want people
to login and have full access to my server... this could be cause the
problem?

Johnny

"Paul Ibison" wrote in message

 > What do you ge if on your publisher/distributor you run:

 > - are the values the same?
 > Rgds,
<font color=purple> > Paul Ibison SQL Server MVP, <a rel="nofollow" style='text-decoration: none;' href="http://www.replicationanswers.com</font" target="_blank">www.replicationanswers.com</font</a>>
 > (recommended sql server 2000 replication book:
 > <a rel="nofollow" style='text-decoration: none;' href="http://www.nwsu.com/0974973602p.html" target="_blank">http://www.nwsu.com/0974973602p.html</a>)
 >
 >
 >> Stay informed about: error 14151 

Yes that was the problem... I have to use securityMode 0 with login and pwd.
Tks
Johnny

-PublisherSecurityMode [0|
Specifies the Publisher's security mode. A value of 0 indicates Mixed Mode
(default), and a value of 1 indicates Windows NT Authentication Mode.
-PublisherLogin publisher_login
-PublisherPassword publisher_password

"JFB" wrote in message

 > Hi all,
 > I got this error this morning... what is the problem? everything was
 > working
 > fine...
 >
 > Executed as user: sqlUser. Replication-Replication Snapshot Subsystem:
 > agent
 > SERVER-SQL-Jobsheet-Jobsheet-12 failed. The process could not connect to
 > Distributor SERVER-SQL'. The step failed. [SERVER42000] (Error 14151).
 > The
 > step failed.
 >
 > Tks in advance
 > Johnny
 >
 >
 >> Stay informed about: error 14151