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)
>

ERROR - Subscription Failure (Please Help!)

The report subscription is returning the following error message.
How should I resolve this issue?
However, according to the Job executed, the process was successful but the
report manager is displaying the following.
ERROR:
Failure sending mail: The report server has encountered a configuration
error. See the report server log files for more information.
Also, the event viewer is displaying the following error message well.Also, the event viewer is displaying the following error message well.
User: NT AUTHORITY\SYSTEM
Computer: REPORTSERV
Event Type: Failure Audit
Event Source: Security
Event Category: Logon/Logoff
Event ID: 529
Date: 11/30/2005
Time: 10:49:03 AM
User: NT AUTHORITY\SYSTEM
Computer: REPORTSERV
Description:
Logon Failure:
Reason: Unknown user name or bad password
User Name:
Domain:
Logon Type: 3
Logon Process: Authz
Authentication Package: Kerberos
Workstation Name: REPORTSERV
Caller User Name: NETWORK SERVICE
Caller Domain: NT AUTHORITY
Caller Logon ID: (0x0,0x3E4)
Caller Process ID: 5928
Transited Services: -
Source Network Address: -
Source Port: -
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
"Terry" wrote:
> The report subscription is returning the following error message.
> How should I resolve this issue?
> However, according to the Job executed, the process was successful but the
> report manager is displaying the following.
> ERROR:
> Failure sending mail: The report server has encountered a configuration
> error. See the report server log files for more information.
> Also, the event viewer is displaying the following error message well.
>
>