Change from Enterprise Edition to Developer Edition

We want to install SQL Server 2005 Developer on a server that has SQL Server
2000 Enterprise edition and we are getting an error of you can't upgrade from
Enterprise to Developer. The server is not supporting production and has
never supported production; it is strictly for development activities. Is
there a way we can do that?
Thanks,
Joseph
You can uninstall Enterprise and install Developer. It will not delete any
user dbs but you should have proper backups of all dbs and scripts or a plan
to recreate logins etc if needed.
Andrew J. Kelly SQL MVP
Solid Quality Mentors
"SQLGuru_not" <SQLGurunot@.discussions.microsoft.com> wrote in message
news:0E3E5B6A-27ED-46B2-AA2E-F4E31363E859@.microsoft.com...
> We want to install SQL Server 2005 Developer on a server that has SQL
> Server
> 2000 Enterprise edition and we are getting an error of you can't upgrade
> from
> Enterprise to Developer. The server is not supporting production and has
> never supported production; it is strictly for development activities. Is
> there a way we can do that?
> Thanks,
> Joseph
|||Thanks Andrew. I wanted to avoid uninstalling 2000 because I've never been
able to uninstall it cleanly. Also wanted to see how the upgrade in-place
works for 2005. I want to know if there's a way I can downgrade the
Enterprise to Developer and then upgrade.
Joseph
"Andrew J. Kelly" wrote:

> You can uninstall Enterprise and install Developer. It will not delete any
> user dbs but you should have proper backups of all dbs and scripts or a plan
> to recreate logins etc if needed.
> --
> Andrew J. Kelly SQL MVP
> Solid Quality Mentors
>
> "SQLGuru_not" <SQLGurunot@.discussions.microsoft.com> wrote in message
> news:0E3E5B6A-27ED-46B2-AA2E-F4E31363E859@.microsoft.com...
>
|||Not that I know of. I am pretty sure it will require you to uninstall EE.
Andrew J. Kelly SQL MVP
Solid Quality Mentors
"SQLGuru_not" <SQLGurunot@.discussions.microsoft.com> wrote in message
news:D5495DB1-1592-4339-85EA-3536AA8A81BA@.microsoft.com...[vbcol=seagreen]
> Thanks Andrew. I wanted to avoid uninstalling 2000 because I've never
> been
> able to uninstall it cleanly. Also wanted to see how the upgrade in-place
> works for 2005. I want to know if there's a way I can downgrade the
> Enterprise to Developer and then upgrade.
> Joseph
> "Andrew J. Kelly" wrote:
|||There is no such a path is available because one of the edition is for
production\business purposes and the other one is for totally different
purpose which is development\test.
Here' s a list of available upgrade paths:
http://technet.microsoft.com/en-us/library/ms143393.aspx
Ekrem ?nsoy
"SQLGuru_not" <SQLGurunot@.discussions.microsoft.com> wrote in message
news:D5495DB1-1592-4339-85EA-3536AA8A81BA@.microsoft.com...[vbcol=seagreen]
> Thanks Andrew. I wanted to avoid uninstalling 2000 because I've never
> been
> able to uninstall it cleanly. Also wanted to see how the upgrade in-place
> works for 2005. I want to know if there's a way I can downgrade the
> Enterprise to Developer and then upgrade.
> Joseph
> "Andrew J. Kelly" wrote:

Change from Enterprise Edition to Developer Edition

We want to install SQL Server 2005 Developer on a server that has SQL Server
2000 Enterprise edition and we are getting an error of you can't upgrade fro
m
Enterprise to Developer. The server is not supporting production and has
never supported production; it is strictly for development activities. Is
there a way we can do that?
Thanks,
JosephYou can uninstall Enterprise and install Developer. It will not delete any
user dbs but you should have proper backups of all dbs and scripts or a plan
to recreate logins etc if needed.
Andrew J. Kelly SQL MVP
Solid Quality Mentors
"SQLGuru_not" <SQLGurunot@.discussions.microsoft.com> wrote in message
news:0E3E5B6A-27ED-46B2-AA2E-F4E31363E859@.microsoft.com...
> We want to install SQL Server 2005 Developer on a server that has SQL
> Server
> 2000 Enterprise edition and we are getting an error of you can't upgrade
> from
> Enterprise to Developer. The server is not supporting production and has
> never supported production; it is strictly for development activities. Is
> there a way we can do that?
> Thanks,
> Joseph|||Thanks Andrew. I wanted to avoid uninstalling 2000 because I've never been
able to uninstall it cleanly. Also wanted to see how the upgrade in-place
works for 2005. I want to know if there's a way I can downgrade the
Enterprise to Developer and then upgrade.
Joseph
"Andrew J. Kelly" wrote:

> You can uninstall Enterprise and install Developer. It will not delete any
> user dbs but you should have proper backups of all dbs and scripts or a pl
an
> to recreate logins etc if needed.
> --
> Andrew J. Kelly SQL MVP
> Solid Quality Mentors
>
> "SQLGuru_not" <SQLGurunot@.discussions.microsoft.com> wrote in message
> news:0E3E5B6A-27ED-46B2-AA2E-F4E31363E859@.microsoft.com...
>|||Not that I know of. I am pretty sure it will require you to uninstall EE.
Andrew J. Kelly SQL MVP
Solid Quality Mentors
"SQLGuru_not" <SQLGurunot@.discussions.microsoft.com> wrote in message
news:D5495DB1-1592-4339-85EA-3536AA8A81BA@.microsoft.com...[vbcol=seagreen]
> Thanks Andrew. I wanted to avoid uninstalling 2000 because I've never
> been
> able to uninstall it cleanly. Also wanted to see how the upgrade in-place
> works for 2005. I want to know if there's a way I can downgrade the
> Enterprise to Developer and then upgrade.
> Joseph
> "Andrew J. Kelly" wrote:
>|||There is no such a path is available because one of the edition is for
production\business purposes and the other one is for totally different
purpose which is development\test.
Here' s a list of available upgrade paths:
http://technet.microsoft.com/en-us/...y/ms143393.aspx
Ekrem ?nsoy
"SQLGuru_not" <SQLGurunot@.discussions.microsoft.com> wrote in message
news:D5495DB1-1592-4339-85EA-3536AA8A81BA@.microsoft.com...[vbcol=seagreen]
> Thanks Andrew. I wanted to avoid uninstalling 2000 because I've never
> been
> able to uninstall it cleanly. Also wanted to see how the upgrade in-place
> works for 2005. I want to know if there's a way I can downgrade the
> Enterprise to Developer and then upgrade.
> Joseph
> "Andrew J. Kelly" wrote:
>sql

Change from Enterprise Edition to Developer Edition

We want to install SQL Server 2005 Developer on a server that has SQL Server
2000 Enterprise edition and we are getting an error of you can't upgrade from
Enterprise to Developer. The server is not supporting production and has
never supported production; it is strictly for development activities. Is
there a way we can do that?
Thanks,
JosephYou can uninstall Enterprise and install Developer. It will not delete any
user dbs but you should have proper backups of all dbs and scripts or a plan
to recreate logins etc if needed.
--
Andrew J. Kelly SQL MVP
Solid Quality Mentors
"SQLGuru_not" <SQLGurunot@.discussions.microsoft.com> wrote in message
news:0E3E5B6A-27ED-46B2-AA2E-F4E31363E859@.microsoft.com...
> We want to install SQL Server 2005 Developer on a server that has SQL
> Server
> 2000 Enterprise edition and we are getting an error of you can't upgrade
> from
> Enterprise to Developer. The server is not supporting production and has
> never supported production; it is strictly for development activities. Is
> there a way we can do that?
> Thanks,
> Joseph|||Thanks Andrew. I wanted to avoid uninstalling 2000 because I've never been
able to uninstall it cleanly. Also wanted to see how the upgrade in-place
works for 2005. I want to know if there's a way I can downgrade the
Enterprise to Developer and then upgrade.
Joseph
"Andrew J. Kelly" wrote:
> You can uninstall Enterprise and install Developer. It will not delete any
> user dbs but you should have proper backups of all dbs and scripts or a plan
> to recreate logins etc if needed.
> --
> Andrew J. Kelly SQL MVP
> Solid Quality Mentors
>
> "SQLGuru_not" <SQLGurunot@.discussions.microsoft.com> wrote in message
> news:0E3E5B6A-27ED-46B2-AA2E-F4E31363E859@.microsoft.com...
> > We want to install SQL Server 2005 Developer on a server that has SQL
> > Server
> > 2000 Enterprise edition and we are getting an error of you can't upgrade
> > from
> > Enterprise to Developer. The server is not supporting production and has
> > never supported production; it is strictly for development activities. Is
> > there a way we can do that?
> >
> > Thanks,
> >
> > Joseph
>|||Not that I know of. I am pretty sure it will require you to uninstall EE.
--
Andrew J. Kelly SQL MVP
Solid Quality Mentors
"SQLGuru_not" <SQLGurunot@.discussions.microsoft.com> wrote in message
news:D5495DB1-1592-4339-85EA-3536AA8A81BA@.microsoft.com...
> Thanks Andrew. I wanted to avoid uninstalling 2000 because I've never
> been
> able to uninstall it cleanly. Also wanted to see how the upgrade in-place
> works for 2005. I want to know if there's a way I can downgrade the
> Enterprise to Developer and then upgrade.
> Joseph
> "Andrew J. Kelly" wrote:
>> You can uninstall Enterprise and install Developer. It will not delete
>> any
>> user dbs but you should have proper backups of all dbs and scripts or a
>> plan
>> to recreate logins etc if needed.
>> --
>> Andrew J. Kelly SQL MVP
>> Solid Quality Mentors
>>
>> "SQLGuru_not" <SQLGurunot@.discussions.microsoft.com> wrote in message
>> news:0E3E5B6A-27ED-46B2-AA2E-F4E31363E859@.microsoft.com...
>> > We want to install SQL Server 2005 Developer on a server that has SQL
>> > Server
>> > 2000 Enterprise edition and we are getting an error of you can't
>> > upgrade
>> > from
>> > Enterprise to Developer. The server is not supporting production and
>> > has
>> > never supported production; it is strictly for development activities.
>> > Is
>> > there a way we can do that?
>> >
>> > Thanks,
>> >
>> > Joseph
>>|||There is no such a path is available because one of the edition is for
production\business purposes and the other one is for totally different
purpose which is development\test.
Here' s a list of available upgrade paths:
http://technet.microsoft.com/en-us/library/ms143393.aspx
--
Ekrem Ã?nsoy
"SQLGuru_not" <SQLGurunot@.discussions.microsoft.com> wrote in message
news:D5495DB1-1592-4339-85EA-3536AA8A81BA@.microsoft.com...
> Thanks Andrew. I wanted to avoid uninstalling 2000 because I've never
> been
> able to uninstall it cleanly. Also wanted to see how the upgrade in-place
> works for 2005. I want to know if there's a way I can downgrade the
> Enterprise to Developer and then upgrade.
> Joseph
> "Andrew J. Kelly" wrote:
>> You can uninstall Enterprise and install Developer. It will not delete
>> any
>> user dbs but you should have proper backups of all dbs and scripts or a
>> plan
>> to recreate logins etc if needed.
>> --
>> Andrew J. Kelly SQL MVP
>> Solid Quality Mentors
>>
>> "SQLGuru_not" <SQLGurunot@.discussions.microsoft.com> wrote in message
>> news:0E3E5B6A-27ED-46B2-AA2E-F4E31363E859@.microsoft.com...
>> > We want to install SQL Server 2005 Developer on a server that has SQL
>> > Server
>> > 2000 Enterprise edition and we are getting an error of you can't
>> > upgrade
>> > from
>> > Enterprise to Developer. The server is not supporting production and
>> > has
>> > never supported production; it is strictly for development activities.
>> > Is
>> > there a way we can do that?
>> >
>> > Thanks,
>> >
>> > Joseph
>>

Change Edition of existing isntance?

I have a named instance of SQL Server 2005 Developer Edition. I want to install VS Team System Foundation Server on the same box, but this needs a default instance of Standard or Enterprise edition. I installed the Standard version alongside the existing Developer instance but now I can't start SSIS and without it VSTS Foundation Server won't install.

I have tried to uninstall SSIS and reisntall it from both the Standard Edition and Developer edition media, but it makes no difference, the service still won't start.

Could the SSIS failure be due to having different editions on the same box? If so, is it possible to change the edition of the Developer instance to Standard (or to change them both to Enterprise edition) without having to uninstall and start all over again. The developer instance is used by several team members, so I don't want to have to uninstall it if I can help.

Any ideas anyone?

No. I should not be something like that as different SQL Server 2005 SKUs(Editions) can be installed side by side successfully provided that they have unique instance names. What kind of processor architecture of your machine? If you install 32-bit and 64-bit SQL Server 2005 on an x64 machines side by side, which is also supported, then it is possible that only one version of SSIS works at one time.|||Both isntances are 32-bit. Only differnece is that named instance is Developer Edition and default instance is Standard Edition
|||

Having two different editions (Developer and Standard) on the same box should not cause SSIS to be unable to start. Do the event logs have any messages? When you installed the second instance, did you change any of the logon service accounts?

Thanks,
Sam Lester (MSFT)

|||

Here is a lengthy thread on SSIS not starting. Can you read through it and see if it applies to your situation?

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=375216&SiteID=1

Thanks,
Sam

sql

Change Edition of existing isntance?

I have a named instance of SQL Server 2005 Developer Edition. I want to install VS Team System Foundation Server on the same box, but this needs a default instance of Standard or Enterprise edition. I installed the Standard version alongside the existing Developer instance but now I can't start SSIS and without it VSTS Foundation Server won't install.

I have tried to uninstall SSIS and reisntall it from both the Standard Edition and Developer edition media, but it makes no difference, the service still won't start.

Could the SSIS failure be due to having different editions on the same box? If so, is it possible to change the edition of the Developer instance to Standard (or to change them both to Enterprise edition) without having to uninstall and start all over again. The developer instance is used by several team members, so I don't want to have to uninstall it if I can help.

Any ideas anyone?

No. I should not be something like that as different SQL Server 2005 SKUs(Editions) can be installed side by side successfully provided that they have unique instance names. What kind of processor architecture of your machine? If you install 32-bit and 64-bit SQL Server 2005 on an x64 machines side by side, which is also supported, then it is possible that only one version of SSIS works at one time.|||Both isntances are 32-bit. Only differnece is that named instance is Developer Edition and default instance is Standard Edition|||

Having two different editions (Developer and Standard) on the same box should not cause SSIS to be unable to start. Do the event logs have any messages? When you installed the second instance, did you change any of the logon service accounts?

Thanks,
Sam Lester (MSFT)

|||

Here is a lengthy thread on SSIS not starting. Can you read through it and see if it applies to your situation?

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=375216&SiteID=1

Thanks,
Sam

CERTIFICATE PROBLEM WHILE ENABLING SSL ON SQL SERVER 2005

Hi ,

How do we install a certificate for enabling security on MS -SQL Server 2005?
I tried to install through MMC but it says no " certificate authority found " . Any
help will be highly appreciated , Thanks to you all in advance :-)

Best Regards,

Sudhansu Tiwari

You should look at this article but are you sure your problem is missing certificate authority. Can you detail the steps you are using one by one.

http://support.microsoft.com/kb/318605

|||

Sudhansu,

Please also have a look at the following blog postings:

http://blogs.msdn.com/sql_protocols/archive/2005/12/30/508311.aspx

http://blogs.msdn.com/sql_protocols/archive/2005/10/04/476705.aspx

for additional information about what type of SSL certificate SQL Server supports and how to configure SQL Server to use the SSL certificate.

HTH,

Jimmy

CE DB requires SQL Express install on client machines?

I'm working on a C# 2008 project, when i add a CE Database to it, then publish the app, the installer wants to download and install the entire SQL Server Express product on the client machines. My understanding is that I should be able to embed this database right into the app, but it defeats the purpose to have the installer download and install the entire express product (the actual project is 1 meg).

Is this expected behavior? or am I doing something wrong?

SQL Express is NOT required for SQL Compact projects. You must have a reference to a .mdf file or similar in your project that triggers this requirement.|||

I checked the prerequisite tab and sql express isnt even checked, i'll investigate further

CD-Key?

Have one Small Business Server Premium with 5 clients and im trying to install Reporting Services but it keep asking for the key, but there was no key with the program.

Im i supposed to use the key for SQL Server, or SBS?

Thanks in advance

Reporting Services is part of the SQL Server license. You should use a SQL Server product key.

CD-Key?

Have one Small Business Server Premium with 5 clients and im trying to install Reporting Services but it keep asking for the key, but there was no key with the program.

Im i supposed to use the key for SQL Server, or SBS?

Thanks in advance

Reporting Services is part of the SQL Server license. You should use a SQL Server product key.

CD Install

I would like to extract the self extracting exe files to go to a directory so I can burn a CD. I have tried burning the CD's from the temp directory but it wouldn't install properly from the CD. Is there a command line parameter to get around this? TIA

Add "/x" (no quotes) to any of the express packages (e.g. SQLEXPR.EXE /x) and you will be prompted for a directory to extract the files to.

Regards,

Mike Wachal
SQL Express team

-
Please mark your thread as Answered when you get your solution.