Re: Sharepoint SQL upgrade

Thanks, yes that helps some, I wil try sp4. Yes I folowed the whitepaper so
SQL is on the C drive and the databases are not. Yes I selected to upgrade
the Sharepoint instance in both cases, it does not seem to have done so
however. How do I upgrade the Sharepoint database now? Thanks

"David Copeland [MSFT]" wrote:

Matt,

You probably will want to install SQL 2000 SP4 at this point. You can
download it from
http://www.microsoft.com/downloads/details.aspx?familyid=8E2DFC8D-C20E-4446-99A9-B7F0213F8BC5&displaylang=en

Depending on how/what you moved SQL itself may still be on the c: drive, but
the SharePoint databases may be elsewhere. For example if you followed the
steps in the whitepaper...
http://www.microsoft.com/windowsserver2003/sbs/techinfo/productdoc/alpha.mspx

Moving Data Folders for Windows Small Business Server 2003



Just to be sure, that when you installed SQL you selected the option to
upgrade the SharePoint instance, correct? And when you were attempting to
apply the SQL 2000 SP you were selecting the same instance.

Which, if you have SBS 2003 Premium Edition you may want to order the SBS
2003 SP1 cds so that a) it would have SQL 2000 SP4 on cd and b) you'd get
ISA 2004 along with the rest of the service pack components that make up
SBS 2003 SP1.

http://www.microsoft.com/windowsserver2003/sbs/downloads/sp1/default.mspx

---

Hope that helps,
David Copeland
Microsoft Small Business Server Support

This posting is provided "AS IS" with no warranties, and confers no rights.


SBS Newsgroups:

SBS v4.x: microsoft.public.backoffice.smallbiz
SBS 2000: microsoft.public.backoffice.smallbiz2000
SBS 2003: microsoft.public.windows.server.sbs

"Matt" <Matt@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:1EE2E23D-A3C7-4EA8-B570-958803B2230A@xxxxxxxxxxxxxxxx
Hi, I am attempting to upgrade the Sharepoint database following the
directions on the Premium CD5.
I have two problems
1)The installation of SQL2000 appeared to go fine, but when I attempt to
install sp3a I get an error the the Shairpoint instance alreeady has a
newer
servce pack installed so the operation is canceled.
2)I forgot that I moved the sharepoint database off of the c partition top
make space and it appears that the upgrade did not work because I did not
indicate the new location during the installation. So SQL is installed
but
the Sharepoint istance is not upgraded, any ideas on what I should do now?
Thanks for any help,
Matt



.

Relevant Pages

  • Re: SQL service pack 4 & SBS 2003 premimum version
    ... Thank you for posting in the SBS newsgroup. ... SBS SharePoint with SQL ... whether SQL server is being installed or not. ... it will install the sixteenth instance of MSDE ...
    (microsoft.public.windows.server.sbs)
  • Re: how do I change the user install wizard to create user folder in different location?
    ... Some people read the instructions in such a way that they install both a new ... instance of sql, ... Never slight the SBS wizards. ... I reinstalled from scratch using the Dell OpenManage Server ...
    (microsoft.public.windows.server.sbs)
  • Re: Sharepoint not working anymore
    ... I was trying to get to the point of installing the SBS 2003 SP1. ... the Exchange Server 2003 SP1. ... but the only thing that was truely suggested was to install SBS ...
    (microsoft.public.windows.server.sbs)
  • Re: Faulting Error
    ... it is not part of the default install...since you had to insert the disk and choose to install it. ... Was this a SBS server before and were you attempting an upgrade? ... with sql 2005 and isa and chose to install sql 2005. ...
    (microsoft.public.backoffice.smallbiz)
  • Re: how do I change the user install wizard to create user folder in different location?
    ... Les Connor [SBS Community Member] ... >> Regarding SQL and Sharepoint, ... >> file where I'm suppose to register the SHAREPOINT instance of SQL Server ... another install which is on just Windows 2003 server and SQL2000 ...
    (microsoft.public.windows.server.sbs)