Re: How to convert the SQL Developer Edition to SQL Standard Editi

From: Kam (Kam_at_discussions.microsoft.com)
Date: 01/12/05 

Date: Tue, 11 Jan 2005 19:03:02 -0800

But the SQL Server STD Edition already installed for a long time.
I am unaware I am using the desktop edition.

I think i make this mistake when I try to install the sharepoint portal
server on that machine.

"Andrew J. Kelly" wrote:

> If you run the setup for the Std Edition on that machine it should guide you
> through an upgrade. There should be no need to change where any of the
> drivers point since the server will be the same as long as you upgrade the
> existing instance and don't add a new one.
>
> --
> Andrew J. Kelly SQL MVP
>
>
> "Kam" <Kam@discussions.microsoft.com> wrote in message
> news:91043082-8466-4D3E-A4C6-F91B88634D9F@microsoft.com...
> > Yes, you are right.
> >
> > When I install other microsoft product, I install the Desktop engine by
> > mistake.
> > Now all my Replication Database, SQL Analysis services are using the
> > Desktop
> > Engine.
> >
> > What is the best way to move to the standard edition? I also need to
> > update
> > the ODBC Driver to make it point to the Standard Edition. (How?)
> >
> > "Andrew J. Kelly" wrote:
> >
> >> It sounds like you have a DB that was created with MSDE or possably the
> >> SBS
> >> edition of SQL Server. What does @@VERSION show?
> >>
> >>
> >> --
> >> Andrew J. Kelly SQL MVP
> >>
> >>
> >> "Kam" <Kam@discussions.microsoft.com> wrote in message
> >> news:44915EA7-BB76-4764-B013-F8CBCB128D35@microsoft.com...
> >> > Andrew,
> >> > If possible, can you explain to me why I experience an error when I
> >> > manually
> >> > increase the file size.
> >> >
> >> > under Database properties->Data Files,
> >> > Change the space allocated from 2012 to 5000.
> >> > Then an error come up "Error 1827: CREATE/ALTER DATABASE failed because
> >> > the
> >> > resulting cumulative database size would exceed your licensed limit of
> >> > 2048
> >> > MB per database"
> >> >
> >> > the version that I installed is SQL Developer Edition 2000, on W2K.
> >> > with mutiple server instant, with analysis services running.
> >> >
> >> >
> >> >
> >> > "Andrew J. Kelly" wrote:
> >> >
> >> >> The developer edition does not have any restrictions like that as far
> >> >> as
> >> >> I
> >> >> know. It is essentially the same as the Enterprise Edition. It
> >> >> sounds
> >> >> like
> >> >> you have MSDE or the DeskTop Edition installed. To upgrade to Std
> >> >> Edition
> >> >> you can not avoid rerunning setup for SQL Server to get to Std
> >> >> edition.
> >> >> The
> >> >> process is not bad though and this should guide you through it:
> >> >>
> >> >> http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q325023
> >> >>
> >> >>
> >> >> But the I would ensure you have good backups of all your user and
> >> >> system
> >> >> db's before attempting anything. These may help:
> >> >>
> >> >> http://www.support.microsoft.com/?id=314546 Moving DB's between
> >> >> Servers
> >> >> http://www.support.microsoft.com/?id=224071 Moving SQL Server
> >> >> Databases
> >> >> to a New Location with Detach/Attach
> >> >> http://support.microsoft.com/?id=221465 Using WITH MOVE in
> >> >> a
> >> >> Restore
> >> >> http://www.support.microsoft.com/?id=246133 How To Transfer Logins
> >> >> and
> >> >> Passwords Between SQL Servers
> >> >> http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs
> >> >> after a
> >> >> Restore
> >> >> http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins
> >> >> to
> >> >> users
> >> >> http://www.support.microsoft.com/?id=168001 User Logon and/or
> >> >> Permission
> >> >> Errors After Restoring Dump
> >> >> http://www.support.microsoft.com/?id=240872 How to Resolve
> >> >> Permission
> >> >> Issues When a Database Is Moved Between SQL Servers
> >> >> http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=599
> >> >> Restoring a .mdf
> >> >> http://www.support.microsoft.com/?id=307775 Disaster Recovery
> >> >> Articles
> >> >> for SQL Server
> >> >>
> >> >>
> >> >>
> >> >> --
> >> >> Andrew J. Kelly SQL MVP
> >> >>
> >> >>
> >> >> "Kam" <Kam@discussions.microsoft.com> wrote in message
> >> >> news:9EA92B28-59BB-4B68-8502-F80288B8F143@microsoft.com...
> >> >> >I am reaching the db limit in Developer Edition 2000.
> >> >> > So I would like to convert it to SQL Standard Edition 2000 with no
> >> >> > change
> >> >> > of
> >> >> > my existing setting. I don't want to re-install and I want to keep
> >> >> > the
> >> >> > server
> >> >> > name, DTS, Analysis services, and mulitple instant of SQL server.
> >> >> >
> >> >> > Is there any way to overcome the DB limit in Developer Edition 2000
> >> >> > or
> >> >> > change it to Standard Edition without uninstall the Developer
> >> >> > edition,
> >> >> > then
> >> >> > install the standard edition?
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>
>

Relevant Pages

  • RE: How do I get back to base SQL server on my SBS 2003 server?
    ... After you uninstall SQL 2005, the instance which you upgraded will not go ... Uninstall and then reinstall ISA server. ... Uninstall and then reinstall the Monitoring component. ... Tools to Maintenance, change Monitoring component to Install, and then ...
    (microsoft.public.windows.server.sbs)
  • RE: How do I get back to base SQL server on my SBS 2003 server?
    ... What's the error message you see when installing SQL? ... the easier way is to restore the server from recent backup. ... Screen shot of the error when you install SQL 2005 Workgroup edition. ... <The server-based applications that were running fine are: McAFee EPO, ...
    (microsoft.public.windows.server.sbs)
  • Re: SBS 2003 and Sql Server ~ Client Install
    ... I've found the client tools and have now ... A word mail merge document could access a SQL database via ... We want to install to gain an understanding. ... Once we've managed to install the SQL Server Client we can start to ...
    (microsoft.public.backoffice.smallbiz2000)
  • 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: Any help here???
    ... SQL 200 Server is not local - it's on separate server all by itself. ... trust me - all that's been done here was to install SP2 or upgrade of XP from ... I've completed the install of Visual Studio.NET like I've ...
    (microsoft.public.dotnet.framework.aspnet)