Re: Replication Failure with Event ID 203
From: Hilary Cotter (hilaryk_at_att.net)
Date: 07/25/04
- Next message: Hilary Cotter: "Re: 1 table 2 Publications"
- Previous message: Hilary Cotter: "Re: Merge replication - Check network document"
- In reply to: Terry Glass: "Replication Failure with Event ID 203"
- Next in thread: Terry Glass: "Re: Replication Failure with Event ID 203"
- Reply: Terry Glass: "Re: Replication Failure with Event ID 203"
- Messages sorted by: [ date ] [ thread ]
Date: Sun, 25 Jul 2004 08:51:32 -0400
it looks like your distribution agent has no problems connecting to your
Publisher, but is having a problem connecting to your Distributor. I take it
you are using a local distributor on the server MSSQLServer. Is this the
name of your Publisher?
Can you also expand replication monitor, expand agents, expand distribution
agent, right click on your distribution agent, select agent properties, go
to the steps tab, and click on commands and tell me your values for
-Distributor
and
-DistributorSecurityMode
-- Hilary Cotter Looking for a book on SQL Server replication? http://www.nwsu.com/0974973602.html "Terry Glass" <Terry Glass@discussions.microsoft.com> wrote in message news:53C96240-EB20-4CE5-8669-22F6F60CA76E@microsoft.com... > I set up a test computer running Windows 2000 Advanced Server with SP4 called INST. It has Exchange 2000 with SP3 on it and is the only domain controller for its forest. > I loaded two instances of SQL 2000 Enterprise, default instance and another called SECOND. SQL has SP3A loaded. > I sent up snapshot replication with the distributor and publisher running on the default instance, to a database on the second instance. Should be no problem but the distribution agent is failing and the event log has the following: > > Source: SQLServerAgent > Category: Job Engine > Event ID: 203 > Description: > SubSystem Message - Job 'Inst-docsdb-INST\Second - 1' (0X10CBFD71D9B6AA4EB7B6B6FE875521A4). step 2 - The process could not connect to Distributor 'MSSQLServer'. > > The service agent is a member of the administrator and domain adminstrator groups, both SQL instances are using the same service account for both MSSQLServer and SQLServerAgent. I have System Administrator rights in SQL on both instances. I tried uninstalling then reinstalling SQL with and without SQL SP3A, same problem. I have set this up before, the only difference is Windows has Service Pack 4 on it. As we are going to be ugrading to SP4 on our SQL servers I would like to figure out what is going on. > > Help would be appreciated. > >
- Next message: Hilary Cotter: "Re: 1 table 2 Publications"
- Previous message: Hilary Cotter: "Re: Merge replication - Check network document"
- In reply to: Terry Glass: "Replication Failure with Event ID 203"
- Next in thread: Terry Glass: "Re: Replication Failure with Event ID 203"
- Reply: Terry Glass: "Re: Replication Failure with Event ID 203"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
