Installed edition

Question

Installed edition

as_1234

SSCrazy

Points: 2864
More actions
September 11, 2017 at 10:41 am

#323496

All,
We have a license for Standard. I installed the developer edition thinking that it was the same install so I could use it. However I think it might be wrong? I might need to reinstall with the SQL Standard developer ISO?
Thanks

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

Phil Parkin SSC Guru Points: 246970 More actions · Answer 1

as1981 - Monday, September 11, 2017 10:41 AM
All,
We have a license for Standard. I installed the developer edition thinking that it was the same install so I could use it. However I think it might be wrong? I might need to reinstall with the SQL Standard developer ISO?
Thanks

I think that you will have to do that, yes.

The absence of evidence is not evidence of absence.
Martin Rees

You can lead a horse to water, but a pencil must be lead.
Stan Laurel

alexander.huberti SSC-Addicted Points: 461 More actions · Answer 2

You can make an Edition Upgrade (see https://docs.microsoft.com/en-us/sql/database-engine/install-windows/supported-version-and-edition-upgrades) instead of reinstall. Developer Edition is same like Enterprise Edition and shouldn't be used in a productive environment.

Phil Parkin SSC Guru Points: 246970 More actions · Answer 3

alexander.huberti - Monday, September 11, 2017 12:53 PM
You can make an Edition Upgrade (see https://docs.microsoft.com/en-us/sql/database-engine/install-windows/supported-version-and-edition-upgrades) instead of reinstall. Developer Edition is same like Enterprise Edition and shouldn't be used in a productive environment.

^^Do this. It's way faster than a reinstall.

The absence of evidence is not evidence of absence.
Martin Rees

You can lead a horse to water, but a pencil must be lead.
Stan Laurel

as_1234 SSCrazy Points: 2864 More actions · Answer 4

Both,

Thanks for your replies.

I had a look at the upgrade advisor but it requests a product key which we haven't been given so I was thinking that we should have been given a Standard Edition install? I was basing that on the info here https://docs.microsoft.com/en-us/sql/database-engine/install-windows/install-sql-server :

Get the installation media

The download location for SQL Server depends on the edition:+

SQL Server Enterprise, Standard, and Express Editions are licensed for production use. For Enterprise and Standard Editions, contact your software vendor for the installation media.

Thanks

as_1234 SSCrazy Points: 2864 More actions · Answer 5

All,

We did need installation media from the reseller. Thanks for everyone's help.

Now I've hit a second problem. I have an Availability setup across two servers. I reinstalled one using the new media. If I try and add it to the availability group it fails to join. I saw that Basic Availability Groups won't allow replicas to be added to existing AG's. Did this restrict get removed like a lot of Enterprise only features in SP1?

I also tried removing the availability group and adding both replicas at the same time. It refuses with 'the specified command is invalid because the always on availability group join availability group is not supported on this edition of SQL server'. I'm creating a new group so the error message is incorrect and there is actually another issue?

Is it perhaps because the primary replica is still on Enterprise at the moment? I was trying to reinstall one and then the other to save restoring all the databases.

Thanks

Phil Parkin SSC Guru Points: 246970 More actions · Answer 6

as1981 - Tuesday, September 12, 2017 8:44 AM
All,
We did need installation media from the reseller. Thanks for everyone's help.
Now I've hit a second problem. I have an Availability setup across two servers. I reinstalled one using the new media. If I try and add it to the availability group it fails to join. I saw that Basic Availability Groups won't allow replicas to be added to existing AG's. Did this restrict get removed like a lot of Enterprise only features in SP1?
I also tried removing the availability group and adding both replicas at the same time. It refuses with 'the specified command is invalid because the always on availability group join availability group is not supported on this edition of SQL server'. I'm creating a new group so the error message is incorrect and there is actually another issue?
Is it perhaps because the primary replica is still on Enterprise at the moment? I was trying to reinstall one and then the other to save restoring all the databases.
Thanks

Max of one database per AG on Standard Edition. Could this be the problem?

The absence of evidence is not evidence of absence.
Martin Rees

You can lead a horse to water, but a pencil must be lead.
Stan Laurel

as_1234 SSCrazy Points: 2864 More actions · Answer 7

Hello,

Thanks for your help. I only added one database and readable secondary is set to no.

Thanks

as_1234 SSCrazy Points: 2864 More actions · Answer 8

All,

I changed both servers to Standard and it worked. It doesn't like, through SSMS at least, mixing developer and standard.

Thanks