Wednesday, March 7, 2012

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]
--
>
>.
>

No comments:

Post a Comment