Re: Getting SQL7 to work -> SBS2003 Standard vs Premium

From: Edmond Low (edmlow_at_hotmail.com)
Date: 05/10/04 

Date: Tue, 11 May 2004 07:37:53 +1000

Yes, we should have bought the Premium edition instead. Just happened that
we were not briefed on the version of SQL that was currently in use.

By unstalling SQL7, would it affect the logins and permissions for databases
as defined in SQL7? Would I need to set it up again after I have put in
SQL2000?

Ed.

"Steve Foster [SBS MVP]" <steve.foster@picamar.co.uk> wrote in message
news:xn0di3xts1yn01000@msnews.microsoft.com...
> Edmond Low wrote:
>
> > I have a client who is running SQL7 and they are looking to upgrade to
> > SBS2003. Most of the hardware and software pre-reqs are met, except
> > for the existing SQL7 (which doesn't work with Windows Server 2003)
> > on the server itself.
>
> Clearly you should be looking at the Premium product, since that
> includes SQL Server 2000.
>
> If you're doing an in-place upgrade, SQL Server 2000 setup will upgrade
> the SQL7 for you.
>
> A word of warning though: SQL2000 does character sets and collation
> differently than SQL7, and you are likely to run into some teething
> problems with querying and sorting if you let SQL2000 auto-upgrade SQL7
> (because you have no control over its' choices). It's all fixable
> though.
>
> It may be better to backup the databases, uninstall SQL7, and then
> restore the databases into SQL2000 after you've installed it. You get a
> bit more control over the changes that way, and you can have more than
> one go at it...
>
> --
> Steve Foster [SBS MVP]
> ---------------------------------------
> MVPs do not work for Microsoft. Please reply only to the newsgroups.

Relevant Pages

  • Re: Some basic SQL informatioon needed
    ... it is included in the SBS premium edition: ... however it sounds like you get a copy of SQL Server with SBS... ... install the Enterprise management tools from the SQL Server ...
    (microsoft.public.sqlserver.setup)
  • Re: Accessing SQL 2K from SQL 7
    ... SQL7 doesn't know about named instance. ... SQL Server MVP ...
    (microsoft.public.sqlserver.security)
  • Re: Critical SQL Update KB829358 Fails
    ... Is this SBS 2003 Std Edition or Premium Edition? ... have you upgraded your SharePoint instance (mssql$sharepoint) to full SQL ... > product for MS SQL Server Desktop Engine cannot be found. ...
    (microsoft.public.windows.server.sbs)
  • Re: Whats going on
    ... Sounds like you are using either an Eval or maybe an MSDN version of SQL.. ... which I'm pretty sure won't give you the upgrade option. ... use either the SQL Server from SBS 2003 Premium Edition or a full package ... product version of SQL Server 2000. ...
    (microsoft.public.windows.server.sbs)
  • SQL Server
    ... I think most of us with Premium edition use SQL for the ... SharePoint companyweb, did you not set your up this way? ... Does the companyweb use SQL Server? ...
    (microsoft.public.windows.server.sbs)