Cannot Run Replication Setup From EM in SQL server 2000 EE

When we try to run the Configure Publishers, Subscribers, and Distribution
from the EM Wizrd, we get the Error 208 invalid Object
msdb.dbo.MSDitsributiondbs and the setup quits. The server is a Cluster,
with Log Shipping. Select @.@.Servername returns the correct server name. The
interesting thing is that we have three other servers with the same
configuration that are working just fine.Any ideas? Thanks.
Is this table present in msdb?
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Patrick Ikhifa" <patisi@.pacbell.net> wrote in message
news:uNhWwMi$FHA.912@.TK2MSFTNGP11.phx.gbl...
> When we try to run the Configure Publishers, Subscribers, and Distribution
> from the EM Wizrd, we get the Error 208 invalid Object
> msdb.dbo.MSDitsributiondbs and the setup quits. The server is a Cluster,
> with Log Shipping. Select @.@.Servername returns the correct server name.
> The
> interesting thing is that we have three other servers with the same
> configuration that are working just fine.Any ideas? Thanks.
>
|||No the table is not. I see the table in the stand alone servers that we have
Transactional Replication running on but not on the SQL Server 2000 Clusters
which are also running replication. This is the puzzle for us. By the way
good book you put out Hilary. Do you plan one for SQL 2005? if so please
hurry up!
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:ev75WZl$FHA.2156@.TK2MSFTNGP11.phx.gbl...[vbcol=seagreen]
> Is this table present in msdb?
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Patrick Ikhifa" <patisi@.pacbell.net> wrote in message
> news:uNhWwMi$FHA.912@.TK2MSFTNGP11.phx.gbl...
Distribution
>
|||There is something very wrong with the latest sp upgrade. Please reapply it.
I have to push out the SQL 2000 merge volume before 2005.
I am working on some tutorials for SQL 2005 replication for sswug.com.
I think I knew you from swynk.com in one of the nt groups.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Patrick Ikhifa" <patisi@.pacbell.net> wrote in message
news:u3KclHp$FHA.1600@.TK2MSFTNGP11.phx.gbl...
> No the table is not. I see the table in the stand alone servers that we
> have
> Transactional Replication running on but not on the SQL Server 2000
> Clusters
> which are also running replication. This is the puzzle for us. By the way
> good book you put out Hilary. Do you plan one for SQL 2005? if so please
> hurry up!
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:ev75WZl$FHA.2156@.TK2MSFTNGP11.phx.gbl...
> Distribution
>
|||The server is SP4 on Win2k Adv Svr. Are you suggesting re-applying the SP4?
Becuase that is the revision level that it is at now. It is a production
server with clusterign and log shipping on it already. So we are beign
cautious here. I remember you too from the early Stven Wynkoop Days. It dont
visit as often as it has taken a different tone as a site. Just an old DBA
here.
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:OYrMgxy$FHA.3852@.TK2MSFTNGP14.phx.gbl...
> There is something very wrong with the latest sp upgrade. Please reapply
it.[vbcol=seagreen]
> I have to push out the SQL 2000 merge volume before 2005.
> I am working on some tutorials for SQL 2005 replication for sswug.com.
> I think I knew you from swynk.com in one of the nt groups.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Patrick Ikhifa" <patisi@.pacbell.net> wrote in message
> news:u3KclHp$FHA.1600@.TK2MSFTNGP11.phx.gbl...
way[vbcol=seagreen]
name.
>
|||I am looking for information from others that may have run into issues with
SP4 and SQL Server 2000 Replication. I am suspicious that this may have been
the culprit in my inablility to configure publishing on one of my servers.
Please share you knowledge on this one. Thanks.
"Patrick Ikhifa" <patisi@.pacbell.net> wrote in message
news:uIY$sg6$FHA.2736@.TK2MSFTNGP11.phx.gbl...
> The server is SP4 on Win2k Adv Svr. Are you suggesting re-applying the
SP4?
> Becuase that is the revision level that it is at now. It is a production
> server with clusterign and log shipping on it already. So we are beign
> cautious here. I remember you too from the early Stven Wynkoop Days. It
dont[vbcol=seagreen]
> visit as often as it has taken a different tone as a site. Just an old DBA
> here.
>
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:OYrMgxy$FHA.3852@.TK2MSFTNGP14.phx.gbl...
> it.
we[vbcol=seagreen]
> way
please
> name.
>