Hi Paul,
I found out how to add logging on the merge agent.
But here is the wierd thing - with the Pull Subscription, and error (The
schema script .sch could not be propagated to the subscriber), there is
no Merge Agent created - so I could not enable logging.
I then created a Push Subscription, and this time the error was:
The process could not connect to Subscriber 'POWERQUEST\CRM'.
(Source: POWERQUEST\CRM (Agent); Error number: 20084)
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
For this Push Subscription, the Merge Agent was created, and I did enale
logging, and here is the output:
Microsoft SQL Server Merge Agent 8.00.760
Copyright (c) 2000 Microsoft Corporation
Microsoft SQL Server Replication Agent:
PSADEMO01-Northwind-NorthwindPub-POWERQUEST\CRM-37
Percent Complete: 0
Connecting to Distributor 'PSADEMO01'
Repl Agent Status: 3
Connecting to Distributor 'PSADEMO01.'
Server: PSADEMO01
DBMS: Microsoft SQL Server
Version: 08.00.0760
user name: dbo
API conformance: 2
SQL conformance: 1
transaction capable: 2
read only: N
identifier quote char: "
non_nullable_columns: 1
owner usage: 31
max table name len: 128
max column name len: 128
need long data len: Y
max columns in table: 1024
max columns in index: 16
max char literal len: 524288
max statement len: 524288
max row size: 524288
[2/13/2004 10:05:32 AM]PSADEMO01.: {call sp_MSgetversion }
[2/13/2004 10:05:32 AM]PSADEMO01.: {call sp_helpdistpublisher
(N'PSADEMO01') }
[2/13/2004 10:05:32 AM]PSADEMO01.EYT_MSCRMDistribution: select
datasource, srvid from master..sysservers where upper(srvname) =
upper(N'PSADEMO01')
[2/13/2004 10:05:32 AM]PSADEMO01.EYT_MSCRMDistribution: select
datasource, srvid from master..sysservers where upper(srvname) =
upper(N'POWERQUEST\CRM')
[2/13/2004 10:05:32 AM]PSADEMO01.EYT_MSCRMDistribution: {call
sp_MShelp_merge_agentid (0, N'Northwind', N'NorthwindPub', 4,
N'NorthwindReplica')}
[2/13/2004 10:05:32 AM]PSADEMO01.EYT_MSCRMDistribution: {call
sp_MShelp_profile (37, 4, N'')}
Percent Complete: 0
Connecting to Publisher 'PSADEMO01.Northwind'
Initializing
Server: PSADEMO01
DBMS: Microsoft SQL Server
Version: 08.00.0760
user name: dbo
API conformance: 2
SQL conformance: 1
transaction capable: 2
read only: N
identifier quote char: "
non_nullable_columns: 1
owner usage: 31
max table name len: 128
max column name len: 128
need long data len: Y
max columns in table: 1024
max columns in index: 16
max char literal len: 524288
max statement len: 524288
max row size: 524288
Repl Agent Status: 1
[2/13/2004 10:05:32 AM]PSADEMO01.Northwind: set nocount on declare
@dbname sysname select @dbname = db_name() declare @collation
nvarchar(255) select @collation = convert(nvarchar(255),
databasepropertyex(@dbname, N'COLLATION')) select
collationproperty(@collation, N'CODEPAGE') as 'CodePage',
collationproperty(@collation, N'LCID') as 'LCID',
collationproperty(@collation, N'COMPARISONSTYLE') as 'ComparisonStyle'
Percent Complete: 1
Connecting to Publisher 'PSADEMO01.Northwind'
Connecting to Publisher 'PSADEMO01'
Server: PSADEMO01
DBMS: Microsoft SQL Server
Version: 08.00.0760
user name: dbo
API conformance: 2
SQL conformance: 1
transaction capable: 2
read only: N
identifier quote char: "
non_nullable_columns: 1
owner usage: 31
max table name len: 128
max column name len: 128
need long data len: Y
max columns in table: 1024
max columns in index: 16
max char literal len: 524288
max statement len: 524288
max row size: 524288
Repl Agent Status: 3
[2/13/2004 10:05:32 AM]PSADEMO01.Northwind: {call sp_MSsetaccesslist (?,
?, ?)}
[2/13/2004 10:05:33 AM]PSADEMO01.Northwind: {call sp_MSgetversion }
[2/13/2004 10:05:33 AM]PSADEMO01.Northwind: {call
sp_MSchecksnapshotstatus (N'NorthwindPub')}
[2/13/2004 10:05:33 AM]PSADEMO01.Northwind: {call
sp_helpmergepublication (N'NorthwindPub')}
[2/13/2004 10:05:33 AM]PSADEMO01.Northwind: {call
sp_MSgetreplicainfo(?,?,?,?,?,?,?)}
[2/13/2004 10:05:33 AM]PSADEMO01.EYT_MSCRMDistribution: {call
sp_MShelp_subscriber_info (N'PSADEMO01', N'POWERQUEST\CRM')}
Connecting to Subscriber 'POWERQUEST\CRM.NorthwindReplica'
Percent Complete: 2
Connecting to Subscriber 'POWERQUEST\CRM'
Repl Agent Status: 3
Percent Complete: 0
The process could not connect to Subscriber 'POWERQUEST\CRM'.
Repl Agent Status: 6
Percent Complete: 0
Category:AGENT
Source: POWERQUEST\CRM
Number: 20084
Message: The process could not connect to Subscriber 'POWERQUEST\CRM'.
Repl Agent Status: 3
Percent Complete: 0
Category:SQLSERVER
Source: POWERQUEST\CRM
Number: 18456
Message: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
Repl Agent Status: 3
Disconnecting from Subscriber 'POWERQUEST\CRM'
Disconnecting from Publisher 'PSADEMO01'
Disconnecting from Publisher 'PSADEMO01'
Disconnecting from Distributor 'PSADEMO01'
Any suggestions on how to fix this error will be greatly appreciated!
Thank you.
*** Sent via Developersdex
http://www.developersdex.com ***
