Re: Having trouble getting Sharepoint over to SQL 2000 during Premium Upgrade
From: Rod (sbs_info_at_lancreation.net)
Date: 07/28/04
- Next message: root: "Re: SATA vs. SCSI, RAID?"
- Previous message: Michael: "SBS2003 upgrade issues"
- In reply to: Rod: "Having trouble getting Sharepoint over to SQL 2000 during Premium Upgrade"
- Messages sorted by: [ date ] [ thread ]
Date: 27 Jul 2004 21:53:17 -0700
This was my first post to a newsgroup... Have I done something wrong
or have I put this in the wrong forumn? Not one reply..
Do I need to call MS and pay some money to get it sorted?
Thanks
Rod Arthur
sbs_info@lancreation.net (Rod) wrote in message news:<1fba07f0.0407261714.2d9cee18@posting.google.com>...
> Any help on this would be much appreciated...
>
> Last week my client wanted me to upgrade a SBS standard edition to
> premium. They purchased the Premium Upgrade CD which basically has
> ISA and SQL 2000
> ISA went on fine and it is up and running.
>
> I ran through the html procedure to install single instance of SQL
> server
> 2000 from the premium disk. No issues.
> I then applied SP3a as per procedure, again no issues.
>
> I then tried to upgrade Sharepoint from MSDE to SQL as per same
> document on premium CD.
>
> During this process it froze on a SQL script
> Error running script: replsys.sql(1)
> Where replsys.sql is script 11 out of 17 scripts??
>
> I had stopped all Antivirus services, Exchange, SQL services
> (including Sharepoint) and SQL agents and instances, IIS services, etc
> prior to upgrade.
>
> Now each time I try to rerun the installation I get the following
> message window titled Setup.
> Setup has detected that the previous install attempt was not
> completed. Press Retry to continue installation or Cancel to exit
> Setup.
>
> Pressing Cancel stops any further progress and cancels out of
> installation.
>
> Pressing Retry uses the same failed installation and continues copying
> files and trys to update the Sharepoint database. It always fails at
> replysys.sql script.
>
> I thought it would roll back sharepoint to use MSDE database
> configuration. But one clue to my error may be the fact that if I open
> Enterprise manager and open the properties of the
> Servername\Sharepoint database, it states it is already using SQL
> Server Standard Edition (8.00.884 (SP3)) So either enough of the
> scrips had already completed to do the upgrade, or it completed
> automatically during the first successful single instance upgrade??
> This may be the reason why it now fails to complete install.
>
> My dilema is that the main reason my client wanted to upgrade to SBS
> 2003 Premium is to have Search capabilites (Full Text Indexing) in
> Sharepoint Domunet libraries. I don't seem to have that enabled yet??
>
> So I thought if I could get rid of the annoying message to Retry the
> failed installation and start again, it would let me go through the
> process again. So is there a way to stop it remembering a failed
> installation? Or am I barking up the wrong tree.
>
> I had applied Hot fix found in KB832880 during initial install of SBS
> Standard edition. No errors...
>
> I then applied all Windows Updates shortly there after and this
> applied the KB829358 through the critcal updates.... Have had no
> issues with Sharepoint running on MSDE
>
>
> Hopefully I don't have to go down uninstall/reinstall of Sharepoint.
> Besides it
> talks about uninstall when Sharepoint still uses MSDE, I am not sure
> what will happen now the Databases seems to be in SQL
>
> See kb829114 Uninstall and Re-install Sharepoint
>
> The client is still operating as normal with this instance of
> sharepoint seemingly operating in SQL Server now? Just no FULL TEXT
> search
> features?
>
> When I try to do the following, it states that The database this
> server is using does not support search.
>
> Turn on full-text search in Windows SharePoint Services
> To turn on full-text Search in Window SharePoint Services, follow
> these steps:
> 1) Click Start, point to Administrative Tools, and then click
> SharePoint Central Administration to connect to Windows SharePoint
> Service Central Administration.
> 2) In the Component Configuration area, click Configure full-text
> search.
> 3) Click to select the Enable full-text search and index component
> check box, and then click OK.
>
> In ADD or REMOVE Programs, there is the following...
> Microsoft SQL Server
> Microsoft SQL Server (SHAREPOINT)
> Microsoft SQL Server Desktop Engine (SBSMONITORING)
>
> So it appears to be using SQL Server 2000? What would happen if I
> Remove it in ADD or Remove Programs?? Would it go back to MSDE, so I
> could start over again??
>
> If anyone is wondering, yes I can run Service Pack 3 on the SHAREPOINT
> SQL database with out any issues. Runs through all 7 scripts, then
> requests reboot of computer and Sharepoint still operates as expected
> except NO FULL TEXT Search capability...
>
> The original install process will keep coming up in resume mode...
> and still stop on Error running script: replsys.sql(1)
>
> This is the logged results for replysys.out
> 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 SVR-SB01\SHAREPOINT, Procedure
> sp_dropextendedproc, Line 18
> Cannot use DROP PROCEDURE with 'xp_execresultset' because
> 'xp_execresultset' is a procedure. Use DROP PROCEDURE.
>
> Thanks in Advance
> Rod Arthur
- Next message: root: "Re: SATA vs. SCSI, RAID?"
- Previous message: Michael: "SBS2003 upgrade issues"
- In reply to: Rod: "Having trouble getting Sharepoint over to SQL 2000 during Premium Upgrade"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
