Re: How to convert the SQL Developer Edition to SQL Standard Editi
From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 01/12/05
- Next message: Jan: "SQL server configuration backup"
- Previous message: BJ: "Re: How can I add the SQL Server Agent??"
- In reply to: Kam: "Re: How to convert the SQL Developer Edition to SQL Standard Editi"
- Next in thread: Kam: "Re: How to convert the SQL Developer Edition to SQL Standard Editi"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 12 Jan 2005 08:54:54 -0500
So you have both Std edition and Desktop both on the same machine? If so
then at least one of them has to be a named instance and the other is most
likely a default instance. The one you installed first is probably the
default instance. There is quite a bit of information in booksonline under
"named instance" that should help you out.
-- Andrew J. Kelly SQL MVP "Kam" <Kam@discussions.microsoft.com> wrote in message news:7B5624D3-64E5-4B2E-91F2-70026050F485@microsoft.com... > 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? >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >>
- Next message: Jan: "SQL server configuration backup"
- Previous message: BJ: "Re: How can I add the SQL Server Agent??"
- In reply to: Kam: "Re: How to convert the SQL Developer Edition to SQL Standard Editi"
- Next in thread: Kam: "Re: How to convert the SQL Developer Edition to SQL Standard Editi"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
