Post SP3 upgrade

I upgraded a server last night to SP3 and all of my push subscriptions
disappeared, but all the publications remained. When I go to recreate
them, the push subscriptions, I receive the following message...
Error 2812: Could not find stored rocedure
'distribution.dbo.sp_MShelp_subscriber_info'. Could not find the
Distributor or the distribution database for the local server. The
Distributir may not be installed, or the local server may not be
configured as a Publisher at the Distributor.
What does this mean? Can I create the push subscriptions?
TIA,
Larry...b
can you issue these queries for me?
select count(*) from master.dbo.sysobjects
go
select count(*) from distribution.dbo.sysobjects
go
Issue them in both the publisher and subscriber.
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
<lreames@.gmail.com> wrote in message
news:1108496768.247604.52820@.z14g2000cwz.googlegro ups.com...
> I upgraded a server last night to SP3 and all of my push subscriptions
> disappeared, but all the publications remained. When I go to recreate
> them, the push subscriptions, I receive the following message...
> Error 2812: Could not find stored rocedure
> 'distribution.dbo.sp_MShelp_subscriber_info'. Could not find the
> Distributor or the distribution database for the local server. The
> Distributir may not be installed, or the local server may not be
> configured as a Publisher at the Distributor.
> What does this mean? Can I create the push subscriptions?
> TIA,
> Larry...b
>
|||on publisher
select count(*) from master.dbo.sysobjects --> 1265
select count(*) from distribution.dbo.sysobjects --> 63
on subscriber
select count(*) from master.dbo.sysobjects --> 1308
select count(*) from distribution.dbo.sysobjects --> 245
|||Oops wrong queries - although right now I strongly suspect you have had an
incomplete service pack deployment on your publisher. Can you post these
logs here:
%windir%\sqlsp.log
%windir%\sqlstp.log
Then post the results of these queries
on the publisher
select count(*) from master.dbo.sysobjects where type='p'
select count(*) from distribution.dbo.sysobjects where type='p'
select @.@.version
on the subscriber
select count(*) from master.dbo.sysobjects where type='p'
select count(*) from distribution.dbo.sysobjects where type='p'
select @.@.version
Please do not apply the sp on your subscriber again. Also do you have
backups of your master database over the past couple of days?
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
<lreames@.gmail.com> wrote in message
news:1108498247.749656.228490@.f14g2000cwb.googlegr oups.com...
> on publisher
> select count(*) from master.dbo.sysobjects --> 1265
> select count(*) from distribution.dbo.sysobjects --> 63
> on subscriber
> select count(*) from master.dbo.sysobjects --> 1308
> select count(*) from distribution.dbo.sysobjects --> 245
>
|||can you also save the results of this query and post them here:
select name, crdate from sysobjects where type='p'
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
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:OMUZ8D9EFHA.1348@.TK2MSFTNGP14.phx.gbl...
> Oops wrong queries - although right now I strongly suspect you have had an
> incomplete service pack deployment on your publisher. Can you post these
> logs here:
> %windir%\sqlsp.log
> %windir%\sqlstp.log
> Then post the results of these queries
> on the publisher
> select count(*) from master.dbo.sysobjects where type='p'
> select count(*) from distribution.dbo.sysobjects where type='p'
> select @.@.version
> on the subscriber
> select count(*) from master.dbo.sysobjects where type='p'
> select count(*) from distribution.dbo.sysobjects where type='p'
> select @.@.version
> Please do not apply the sp on your subscriber again. Also do you have
> backups of your master database over the past couple of days?
> --
> 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
> <lreames@.gmail.com> wrote in message
> news:1108498247.749656.228490@.f14g2000cwb.googlegr oups.com...
>

Post SP3 ERROR

upgraded a server last night to SP3 and all of my push subscriptions
disappeared, but all the publications remained. When I go to recreate
them, the push subscriptions, I receive the following message...
Error 2812: Could not find stored procedure
'distribution.dbo.sp_MShelp_subscriber_info'. Could not find the
Distributor or the distribution database for the local server. The
Distributir may not be installed, or the local server may not be
configured as a Publisher at the Distributor.
What does this mean? Can I create the push subscriptions?
TIA,
Larry...
Is this proc in the distribution database? Can you post your sqlsp.log and
your sqlsp.logs here? You can find them in %windir%
Also can you give us some history of your server? Is this the first time you
applied SP 3 to them? What was on these servers before you applied SP3?
This problem occasionally occurs on SQL Servers - I'd like to try to get to
the bottom of it.
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
<lreames@.gmail.com> wrote in message
news:1108653185.903933.16440@.c13g2000cwb.googlegro ups.com...
> upgraded a server last night to SP3 and all of my push subscriptions
> disappeared, but all the publications remained. When I go to recreate
> them, the push subscriptions, I receive the following message...
>
> Error 2812: Could not find stored procedure
> 'distribution.dbo.sp_MShelp_subscriber_info'. Could not find the
> Distributor or the distribution database for the local server. The
> Distributir may not be installed, or the local server may not be
> configured as a Publisher at the Distributor.
>
> What does this mean? Can I create the push subscriptions?
>
> TIA,
> Larry...
>
|||Hilary,
You responded to me via email, this was a repost.
Larry....

Post SP Install issue

We have a active/active W2K3 SQL cluster with 3 instances that was upgraded
to SP4 with the 2148 hotfix. All 3 instances upgraded to SP 4 with no
problems.
However, when applying the hotix only the first instance upgraded correctly.
The hotfix install for instances 2 and 3 indicated success but the version
for both still shows build 2139. Can't seem to get the install to work for
these instances. Any help would be appreciated.Hi
You may want to re-contact PSS for this as this is a PSS only hotfix!
John
"GManino" wrote:
> We have a active/active W2K3 SQL cluster with 3 instances that was upgraded
> to SP4 with the 2148 hotfix. All 3 instances upgraded to SP 4 with no
> problems.
> However, when applying the hotix only the first instance upgraded correctly.
> The hotfix install for instances 2 and 3 indicated success but the version
> for both still shows build 2139. Can't seem to get the install to work for
> these instances. Any help would be appreciated.|||Hi
Your answer is Windows Task Scheduler.
See http://msmvps.com/epprecht/archive/2005/08/28/64380.aspx
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"GManino" <GManino@.discussions.microsoft.com> wrote in message
news:9BBD59DE-12E8-4A0C-AA9B-61B25D031BB3@.microsoft.com...
> We have a active/active W2K3 SQL cluster with 3 instances that was
> upgraded
> to SP4 with the 2148 hotfix. All 3 instances upgraded to SP 4 with no
> problems.
> However, when applying the hotix only the first instance upgraded
> correctly.
> The hotfix install for instances 2 and 3 indicated success but the version
> for both still shows build 2139. Can't seem to get the install to work
> for
> these instances. Any help would be appreciated.|||Does anyone know if this will work for all types of corruption?
"John Bell" wrote:
> Hi
> You may want to re-contact PSS for this as this is a PSS only hotfix!
> John
> "GManino" wrote:
> > We have a active/active W2K3 SQL cluster with 3 instances that was upgraded
> > to SP4 with the 2148 hotfix. All 3 instances upgraded to SP 4 with no
> > problems.
> >
> > However, when applying the hotix only the first instance upgraded correctly.
> > The hotfix install for instances 2 and 3 indicated success but the version
> > for both still shows build 2139. Can't seem to get the install to work for
> > these instances. Any help would be appreciated.

Post SP Install issue

We have a active/active W2K3 SQL cluster with 3 instances that was upgraded
to SP4 with the 2148 hotfix. All 3 instances upgraded to SP 4 with no
problems.
However, when applying the hotix only the first instance upgraded correctly.
The hotfix install for instances 2 and 3 indicated success but the version
for both still shows build 2139. Can't seem to get the install to work for
these instances. Any help would be appreciated.
Hi
You may want to re-contact PSS for this as this is a PSS only hotfix!
John
"GManino" wrote:

> We have a active/active W2K3 SQL cluster with 3 instances that was upgraded
> to SP4 with the 2148 hotfix. All 3 instances upgraded to SP 4 with no
> problems.
> However, when applying the hotix only the first instance upgraded correctly.
> The hotfix install for instances 2 and 3 indicated success but the version
> for both still shows build 2139. Can't seem to get the install to work for
> these instances. Any help would be appreciated.
|||Hi
Your answer is Windows Task Scheduler.
See http://msmvps.com/epprecht/archive/2.../28/64380.aspx
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"GManino" <GManino@.discussions.microsoft.com> wrote in message
news:9BBD59DE-12E8-4A0C-AA9B-61B25D031BB3@.microsoft.com...
> We have a active/active W2K3 SQL cluster with 3 instances that was
> upgraded
> to SP4 with the 2148 hotfix. All 3 instances upgraded to SP 4 with no
> problems.
> However, when applying the hotix only the first instance upgraded
> correctly.
> The hotfix install for instances 2 and 3 indicated success but the version
> for both still shows build 2139. Can't seem to get the install to work
> for
> these instances. Any help would be appreciated.
|||Does anyone know if this will work for all types of corruption?
"John Bell" wrote:
[vbcol=seagreen]
> Hi
> You may want to re-contact PSS for this as this is a PSS only hotfix!
> John
> "GManino" wrote:

Post SP Install issue

We have a active/active W2K3 SQL cluster with 3 instances that was upgraded
to SP4 with the 2148 hotfix. All 3 instances upgraded to SP 4 with no
problems.
However, when applying the hotix only the first instance upgraded correctly.
The hotfix install for instances 2 and 3 indicated success but the version
for both still shows build 2139. Can't seem to get the install to work for
these instances. Any help would be appreciated.Hi
You may want to re-contact PSS for this as this is a PSS only hotfix!
John
"GManino" wrote:

> We have a active/active W2K3 SQL cluster with 3 instances that was upgrade
d
> to SP4 with the 2148 hotfix. All 3 instances upgraded to SP 4 with no
> problems.
> However, when applying the hotix only the first instance upgraded correctl
y.
> The hotfix install for instances 2 and 3 indicated success but the versio
n
> for both still shows build 2139. Can't seem to get the install to work fo
r
> these instances. Any help would be appreciated.|||Hi
Your answer is Windows Task Scheduler.
See http://msmvps.com/epprecht/archive/...8/28/64380.aspx
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"GManino" <GManino@.discussions.microsoft.com> wrote in message
news:9BBD59DE-12E8-4A0C-AA9B-61B25D031BB3@.microsoft.com...
> We have a active/active W2K3 SQL cluster with 3 instances that was
> upgraded
> to SP4 with the 2148 hotfix. All 3 instances upgraded to SP 4 with no
> problems.
> However, when applying the hotix only the first instance upgraded
> correctly.
> The hotfix install for instances 2 and 3 indicated success but the version
> for both still shows build 2139. Can't seem to get the install to work
> for
> these instances. Any help would be appreciated.|||Does anyone know if this will work for all types of corruption?
"John Bell" wrote:
[vbcol=seagreen]
> Hi
> You may want to re-contact PSS for this as this is a PSS only hotfix!
> John
> "GManino" wrote:
>