Merge Replication Problem (814916)

I got a big problem with the Merge replication. detail as below:
Failed to enumerate changes in the filtered articles.
Category: NULL Source:
Merge Replication Provider
Number: -2147200925
Message: Failed to enumerate changes in the filtered articles.
Category: COMMAND
Source: Failed Command
Number: 0
Message: create table #belong_agent_-2147483646 (tablenick int NOT NULL,
rowguid uniqueidentifier NOT NULL,generation int NULL, lineage
varbinary(255) NULL, col v varbinary(2048) NULL)
Category: SQLSERVER
Source: ServerName
Number: 170
Message: Line 1: Incorrect syntax near '-'.
the Bug# is 363726 (SHILOH_BUGS)
KB814916
I do know how to fix the problem. It seems the service pack3 does not solve
the problem. i am very very upset with this problem since the boss order me
to finish the replication within two weeks.
would anybody help me. save my life.
As far as I know this isn't fixed in sp3a, but is a separate requested fix
from MS. Details are in
http://support.microsoft.com/default...;en-us;814916.
HTH,
Paul Ibison
|||Sorry, i have saw this article much times. but Microsoft have not given the
hot fix. just said "To resolve this problem immediately, contact Microsoft
Product Support Services to obtain the fix. For a complete list of Microsoft
Product Support Services phone numbers and information about support costs,
visit the following Microsoft Web site"
how can i got the hot fix.
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> д?
:epZtOjhdEHA.3964@.TK2MSFTNGP10.phx.gbl...
> As far as I know this isn't fixed in sp3a, but is a separate requested fix
> from MS. Details are in
> http://support.microsoft.com/default...;en-us;814916.
> HTH,
> Paul Ibison
>
|||I'm not too sure if I have understood you - did you get in
touch with PSS through the link provided, quote the KB
article and then the MS representative didn't give you the
hotfix? If this is the case what reason was given?
Regards,
Paul Ibison

Merge Replication Error

Dear Friends
I am getting the following error for the Merge
replication.
Login failed for user '(null)'. Reason: Not associated
with a trusted SQL Server connection.
(Source: SERVER (Data source); Error number: 18452)
The process could not connect to Subscriber 'SERVER'.
(Source: SERVER (Agent); Error number: 20084)
----
Login failed for user '(null)'. Reason: Not associated
with a trusted SQL Server connection.
(Source: SERVER (Data source); Error number: 18452)
----
I can connect to the Server with Enterprise manager and
also with OSQL. Please suggest what can be the problem.
Best regards
Sharad
Your sql server agent is runing using the defaulot system account you have
to make a user in sql server and assign this user to load sqlserver agents.
do this to both the server so that the agent of publisher can connect to
agent of subscriber.
regards
Kashif
"Sharad" <Niitmalad@.yahoo.co.in> wrote in message
news:1f8901c5103b$460dc6b0$a601280a@.phx.gbl...
> Dear Friends
> I am getting the following error for the Merge
> replication.
> Login failed for user '(null)'. Reason: Not associated
> with a trusted SQL Server connection.
> (Source: SERVER (Data source); Error number: 18452)
> The process could not connect to Subscriber 'SERVER'.
> (Source: SERVER (Agent); Error number: 20084)
> ----
> ----
> Login failed for user '(null)'. Reason: Not associated
> with a trusted SQL Server connection.
> (Source: SERVER (Data source); Error number: 18452)
> ----
> ----
> I can connect to the Server with Enterprise manager and
> also with OSQL. Please suggest what can be the problem.
> Best regards
> Sharad
|||Dear Kashif
Thanks for your quick reply. Kindly suggest if i have
diffrent domains then how the same problem can be solved.
Best regards
Sharad

>--Original Message--
>Your sql server agent is runing using the defaulot
system account you have
>to make a user in sql server and assign this user to
load sqlserver agents.
>do this to both the server so that the agent of
publisher can connect to[vbcol=seagreen]
>agent of subscriber.
>regards
>Kashif
>
>"Sharad" <Niitmalad@.yahoo.co.in> wrote in message
>news:1f8901c5103b$460dc6b0$a601280a@.phx.gbl...
--[vbcol=seagreen]
--
>
>.
>