November 20, 2008 at 4:16 am
I am getting lot of knowledge as a DBA from this source, i must thank you all for your information exchanges between our group members.
I in need of one help from you to solve the following issue
When Creating the publication everything succeeded, but in agent history there is a exception message as follows:
Date11/20/2008 5:48:56 AM
LogJob History (XXXXXXXXXXX)
Step ID2
ServerXXXXXXXXXXX
Job NameXXXXXXXXXXX
Step NameRun agent.
Duration00:00:01
Sql Severity0
Sql Message ID0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted0
Message
2008-11-20 10:48:56.92 User-specified agent parameter values:
2008-11-20 10:48:56.92 --------------------------------------
2008-11-20 10:48:56.92 -Publisher XXXXXXXXXXX
2008-11-20 10:48:56.92 -PublisherDB XXXXXXXXXXX
2008-11-20 10:48:56.92 -Publication XXXXXXXXXXX
2008-11-20 10:48:56.92 -Distributor XXXXXXXXXXX
2008-11-20 10:48:56.92 -DistributorSecurityMode 1
2008-11-20 10:48:56.92 -XJOBID 0xE4CCC7889D72014890DFC2263E0D85BB
2008-11-20 10:48:56.92 --------------------------------------
2008-11-20 10:48:56.92 Connecting to Distributor 'XXXXXXXXXXX'
2008-11-20 10:48:56.96 The replication agent had encountered an exception.
2008-11-20 10:48:56.96 Source: Replication
2008-11-20 10:48:56.96 Exception Type: Microsoft.SqlServer.Replication.ConnectionFailureException
2008-11-20 10:48:56.96 Exception Message: Login failed for user ''. The user is not associated with a trusted SQL Server connection.
2008-11-20 10:48:56.96 Message Code: 18452
2008-11-20 10:48:56.96
error 2:
Date11/20/2008 12:34:17 AM
LogJob History (XXXXXXXXXXX)
Step ID2
ServerXXXXXXXXXXX
Job NameXXXXXXXXXXX
Step NameRun agent.
Duration00:00:01
Sql Severity0
Sql Message ID0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted0
Message
2008-11-20 05:34:17.89 User-specified agent parameter values:
2008-11-20 05:34:17.89 --------------------------------------
2008-11-20 05:34:17.89 -Publisher XXXXXXXXXXX
2008-11-20 05:34:17.89 -PublisherDB XXXXXXXXXXX
2008-11-20 05:34:17.89 -Publication XXXXXXXXXXX
2008-11-20 05:34:17.89 -Distributor XXXXXXXXXXX
2008-11-20 05:34:17.89 -DistributorSecurityMode 1
2008-11-20 05:34:17.89 -XJOBID 0xCF4FA932A5C60D4AB104AA7D2D70158C
2008-11-20 05:34:17.89 --------------------------------------
2008-11-20 05:34:17.89 Connecting to Distributor 'XXXXXXXXXXX'
2008-11-20 05:34:17.93 The replication agent had encountered an exception.
2008-11-20 05:34:17.93 Source: Replication
2008-11-20 05:34:17.93 Exception Type: Microsoft.SqlServer.Replication.ConnectionFailureException
2008-11-20 05:34:17.93 Exception Message: Login failed for user ''. The user is not associated with a trusted SQL Server connection.
2008-11-20 05:34:17.93 Message Code: 18452
2008-11-20 05:34:17.93
Anyone please help me to solve this issue....
your help is more valuable for me
with thanks
mohideen
November 20, 2008 at 9:59 am
Post belongs in the replication forum...
In any case, if I had to guess the SQL Server Agent on your distributor is running as an account that doesn't have rights to the publisher, therefore you get the login failure when it tries to connect to the publisher and take the snapshot.
November 21, 2008 at 12:20 am
Thank You Kendal,
I checked with distributor property and I changed the local user password for publisher to connect to the distributor. because both publisher and distributor at the same server and the same instance.
after changing this, again i checked job view history, i found the following error.
Date11/21/2008 2:06:43 AM
LogJob History (XXXXXXXXXXXX)
Step ID2
ServerXXXXXXXXXXXX
Job NameXXXXXXXXXXXX-1
Step NameRun agent.
Duration00:00:00
Sql Severity0
Sql Message ID0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted0
Message
2008-11-21 07:06:43.328 Copyright (c) 2000 Microsoft Corporation
2008-11-21 07:06:43.328 Microsoft SQL Server Replication Agent: logread
2008-11-21 07:06:43.328
2008-11-21 07:06:43.328 The timestamps prepended to the output lines are expressed in terms of UTC time.
2008-11-21 07:06:43.328 User-specified agent parameter values:
-Publisher XXXXXXXXXXXX -PublisherDB XXXXXXXXXXXX -Distributor XXXXXXXXXXXX
-DistributorSecurityMode 1
-Continuous
-XJOBID 0x69F64F012F621443AA0B4710F3F15348
-XJOBNAME XXXXXXXXXXXX-1
-XSTEPID 2
-XSUBSYSTEM LogReader
-XSERVER XXXXXXXXXXXX
-XCMDLINE 0
-XCancelEventHandle 00000000000006E8
2008-11-21 07:06:43.375 Status: 0, code: 20015, text: 'Login failed for user ''. The user is not associated with a trusted SQL Server connection.'.
2008-11-21 07:06:43.375 Login failed for user ''. The user is not associated with a trusted SQL Server connection.
our sqlserver services runs under the local user accounts. please give me your idea to resolve this, which is more valuable for me.
WITH THANKS AND REGARDS
MOHIDEEN
November 21, 2008 at 12:24 am
tharvesmohideen (11/21/2008)
Login failed for user ''. The user is not associated with a trusted SQL Server connection.
This error also will come If the destination SQL Server to which you are connecting is running with Windows Only Authentication but you are trying to connect using SQL Server Login.
Regards,
Sakthi
My Blog -> http://www.sqlserverdba.co.cc
November 21, 2008 at 2:01 am
Thanks for ur tips Sakthi,
But I configured the same server instance as both publisher and distributor.
Give ur worthful ideas in this regard.
with thanks
Mohideen
November 21, 2008 at 6:05 am
Hi,
Do not run the SQL services under local account. Create a seperate account and run the services on that account.
That should solve the problem
Shree
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply