error 14151

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
Is server-sql live? Is your distributor on the same server as your
publisher?
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"JFB" <jfb@.newSQL.com> wrote in message
news:eJjuEuD7EHA.4040@.TK2MSFTNGP14.phx.gbl...
> 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
>
|||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" <hilary.cotter@.gmail.com> wrote in message
news:eabcw1D7EHA.1404@.TK2MSFTNGP11.phx.gbl...
> Is server-sql live? Is your distributor on the same server as your
> publisher?
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> "JFB" <jfb@.newSQL.com> wrote in message
> news:eJjuEuD7EHA.4040@.TK2MSFTNGP14.phx.gbl...
> working
> agent
> The
>
|||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)
|||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" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:uNJRmfJ7EHA.936@.TK2MSFTNGP12.phx.gbl...
> 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)
>