Friday, March 30, 2012

Replication Error Message

I get the following error message when I run replication that I have set up
on one of our servers. I have no ideal why, any help would be appreciated.
This error is from the application log on the replication server to our web
server. I think it is because it is trying to login as user "null" but i
have no ideal where to set this.
Thank you.
Greg
Event Type: Information
Event Source: SQLAgent$INST2DB
Event Category: Job Engine
Event ID: 203
Date: 11/15/2005
Time: 5:03:45 PM
User: N/A
Computer: VS2DB
Description:
SubSystem Message - Job 'VS2DB\INST2DB-Charity-WEBSERVER-13'
(0x5F1388610429AD4B8860D51DF8504198), step 2 - Login failed for user
'(null)'. Reason: Not associated with a trusted SQL Server connection. The
process could not connect to Subscriber 'WEBSERVER'.
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
It looks like you are trying to logon to a SQL Server using SQL
authentication and this server is not configured for mixed mode
authentication.
"greg" <anomious@.microsoft.com> wrote in message
news:O9UGJqj6FHA.2040@.TK2MSFTNGP14.phx.gbl...
>I get the following error message when I run replication that I have set up
>on one of our servers. I have no ideal why, any help would be appreciated.
>This error is from the application log on the replication server to our web
>server. I think it is because it is trying to login as user "null" but i
>have no ideal where to set this.
> Thank you.
> Greg
> Event Type: Information
> Event Source: SQLAgent$INST2DB
> Event Category: Job Engine
> Event ID: 203
> Date: 11/15/2005
> Time: 5:03:45 PM
> User: N/A
> Computer: VS2DB
> Description:
> SubSystem Message - Job 'VS2DB\INST2DB-Charity-WEBSERVER-13'
> (0x5F1388610429AD4B8860D51DF8504198), step 2 - Login failed for user
> '(null)'. Reason: Not associated with a trusted SQL Server connection. The
> process could not connect to Subscriber 'WEBSERVER'.
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
>
|||Hillary, thanks for the response, I check both servers and they are set up
to user both SQL and Windows authentication. Do you have any other ideas?
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:%237M1YNk6FHA.1140@.tk2msftngp13.phx.gbl...
> It looks like you are trying to logon to a SQL Server using SQL
> authentication and this server is not configured for mixed mode
> authentication.
> "greg" <anomious@.microsoft.com> wrote in message
> news:O9UGJqj6FHA.2040@.TK2MSFTNGP14.phx.gbl...
>

No comments:

Post a Comment