Re: Error when upgrading SBS Sharepoint to use SQL 2000
From: Jerry (nospam_at_newsreader.org)
Date: 07/21/04
- Next message: Tester: "Re: Multi nic question and WINS question w/sbs2003"
- Previous message: Laura: "Re: Unable to Ping Network from Outside"
- In reply to: Tim: "Re: Error when upgrading SBS Sharepoint to use SQL 2000"
- Next in thread: Jerry: "Re: Error when upgrading SBS Sharepoint to use SQL 2000"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 21 Jul 2004 12:35:48 -0400
I do not recall explicitly stopping the MSSQL$SHAREPOINT service prior to
the first pass. After we received the error message, we checked the service
and it was stopped. As per my original posting, we have since tried to run
the install with all possible combinations of MSSQL services started and
stopped and it seems to make no difference as the error remains consistent.
~Jerry
"Tim" <tim_hames@hotmail.com> wrote in message
news:ulPdyGtbEHA.1152@TK2MSFTNGP09.phx.gbl...
> Hi Jerry
>
> Did you stop the the MSSQL$SHAREPOINT service before starting the upgrade?
>
> Kind Regards
>
> Tim
>
> "Marina Roos [SBS-MVP]" <marina@roos.nodontwantspam.nl.com> wrote in
message
> news:uKYQ9enbEHA.2840@TK2MSFTNGP11.phx.gbl...
> > Hi Jerry,
> >
> > On the Premium CD you will find the PREMIUMINSTALLSTEPS.HTM in the root.
> > Are
> > you following that exactly?
> >
> > --
> > Regards,
> >
> > Marina
> > Microsoft SBS-MVP
> >
> > "Jerry" <nospam@newsreader.org> schreef in bericht
> > news:Odw4ZbnbEHA.3596@tk2msftngp13.phx.gbl...
> >> This question is in regards to an SBS server, so I assumed that this
was
> > the
> >> appropriate newsgroup to post it in. If this is not the correct group,
> >> please point me to the right group. We really need to resolve this
issue.
> >>
> >> "Jerry" <nospam@newsreader.org> wrote in message
> >> news:Osy%237X2aEHA.1656@TK2MSFTNGP09.phx.gbl...
> >> > Any insight on this issue would be appreciated.
> >> >
> >> > We installed SQL 2000 and SP3 from the SBS Premium install media
> >> yesterday.
> >> > The install apparently went fine.
> >> >
> >> > After rebooting the server from the SP3 install, we attempted to
> >> > upgrade
> >> the
> >> > Sharepoint install by performing another SQL 200 install (this time
> >> choosing
> >> > the sharepoint instance). This install begins and reaches the point
> > where
> >> it
> >> > is 'Running script(s)'. It runs the first 10 scripts fine, and then
it
> >> fails
> >> > on replsys.sql with a message of 'Error running script:
replsys.sql(1)'
> >> >
> >> > I checked the replsys.out file from the install directory and it
> > contains
> >> > the following:
> >> >
> >> > ---Begin Copy---
> >> > DBCC execution completed. If DBCC printed error messages, contact
your
> >> > system administrator.
> >> > Configuration option 'allow updates' changed from 0 to 1. Run the
> >> > RECONFIGURE statement to install.
> >> > DBCC execution completed. If DBCC printed error messages, contact
your
> >> > system administrator.
> >> > Msg 3705, Level 16, State 1, Server SBSERVER\SHAREPOINT, Procedure
> >> > sp_dropextendedproc, Line 18
> >> > Cannot use DROP PROCEDURE with 'xp_execresultset' because
> >> > 'xp_execresultset' is a procedure. Use DROP PROCEDURE.
> >> > ---End Copy---
> >> >
> >> > When we attempt to retry the install we are greeted with 'Setup has
> >> detected
> >> > that the previous install attempt was not completed. Press Retry to
> >> continue
> >> > installation or Cancel to exit setup'. If we click retry, the install
> >> fails
> >> > at the same point with the same message.
> >> >
> >> > We have tried running the upgrade with all combinations of SQL
services
> >> > started and stopped and it seems to make no difference.
> >> >
> >> > If it helps, the original sharepoint install is on the C drive with
the
> >> data
> >> > files residing on the D drive (the same configuration as the
> > SBSMONITORING
> >> > instance). When SQL 2000 was installed, it was installed on the D
drive
> >> with
> >> > its data files residing on the S drive. The sharepoint instance runs
> > under
> >> > the local system account (was to be changed after the upgrade) and
the
> >> main
> >> > SQL instances runs under a privileged user account.
> >> >
> >> > We would very much like to complete this install and enable
sharepoint
> >> > indexing on this machine.
> >> >
> >> >
> >>
> >>
> >
> >
>
>
- Next message: Tester: "Re: Multi nic question and WINS question w/sbs2003"
- Previous message: Laura: "Re: Unable to Ping Network from Outside"
- In reply to: Tim: "Re: Error when upgrading SBS Sharepoint to use SQL 2000"
- Next in thread: Jerry: "Re: Error when upgrading SBS Sharepoint to use SQL 2000"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
