Re: SBS 2003 Premium R2 - SQL2005 Install. by Johnpleasedontspamme
Johnpleasedontspamme
Tue Jul 01 01:27:02 PDT 2008
Hi bass_player,
Thanks for your response.
All the sharepoint, monitoring etc Db's including System Db's (Master,
TempDb etc) appear are showing to be 2000 Db's.
How do I now go about correcting this?
Do I remove SQL2005 and then remove SQL2000 and reinstall SQL2005 using the
R2 Premium?
--
Kind Regards
John.
"bass_player" wrote:
> You need to check the SQL Server instances (SBSMONITORING, SHAREPOINT, etc)
> and see if they are already running on SQL Server 2005. To check, you can
> use osql.exe and run this command
>
> osql -Sservername\SHAREPOINT -E -q"SELECT @@VERSION"
>
> Do this on all instances. Changing the system databases to compatibility
> mode 90 is another thing.
>
> "John please don't spam me!"
> <Johnpleasedontspamme@discussions.microsoft.com> wrote in message
> news:EECE9271-A0BE-4343-A5AC-25B697D6A27C@microsoft.com...
> > I upgraded a clients SBS2003 Premium to R2 and all went swimmingly until
> > this morning I found that reporting services would not configure. When I
> > looked in All Programs the upgrade appears to have left the SQL2000
> > installed
> > and placed all the System Databases in Mode 80 as a result, not upgraded.
> >
> > Therefore Reporting Services Config cannot create a reporting DB.
> >
> > Did I miss something on upgrade? Should I have uninstalled SQL2000 first?
> >
> > I have loked throught the notes that came with the SBS Premium Upgrade and
> > connot find anything that references it.
> >
> > --
> > Kind Regards
> > John.
>
>