By datagod

2013-03-20 16:43:30 8 Comments

Do you use SQL Server Developer Edition on server-class machines in DEV and STAGING environments?

I am working on a large project where (if it passes the proof of concept stage) we will have several large geographically distributed enterprise class database servers running SQL Server 2012 Enterprise Edition.

We will have a production environment will initially have 3 servers, our Staging environment will have a minimum of 3 servers, and our Development environment will have 1 server (hosting three instances).

I was under the impression that we would only need to acquire Enterprise licences for the actual production servers, and we could get by with developer edition in our developer and staging environments because they are not "production".

Other sources have told me that we need to have an enterprise licence on all of the above mentioned machines, and that the developer edition is only meant for a single developer on their workstation.

Since developer edition has all the sexy features of Enterprise, I can't really see the value of it on a workstation class machine, especially for developing and testing the type of high availability system we are building.

If we have to fork out Enterprise licences for a dev server, that will just about kill our proof of concept stage, thus killing the project. Forcing an enterprise licence on a staging environment will make management just want to skip staging altogether.


@Greenstone Walker 2013-03-20 23:27:14

Short answer: yes.

Slightly longer answer: yes as long as you have one developer license for every person accessing the development and staging servers.

From the Licensing Quick Reference Guide:

The SQL Server 2012 Developer Edition is a full-function version of the SQL Server software—with all the features and capabilities of the Enterprise edition—licensed under the Developer Tools model, which is a “per user” model. One license is required for each person that accesses or uses the software.

When using SQL Server software for development, test or demonstration purposes, only the users are licensed and there is no need for a corresponding license for the actual server systems running SQL Server software in this case.

As long as only licensed users have access to the software, customers can install as many copies of the software on any number of servers that are used exclusively for development, test or demonstration purposes. This is significant, because it allows customers to run the software on multiple devices (for testing purposes, for example) without having to license each non-production server system

@mrdenny 2013-03-20 17:04:13

Development edition licenses can be used to install anything that isn't production, provided that everyone that connects to the server has their own development license. MSDN licenses can be used as well if everyone has an MSDN license.

@wwarren 2014-09-13 01:07:47

everyone that connects to the server has their own development license - does this mean everyone who connects using SSMS as developers/admins, or everyone who is a user of an application that is running on top of the SQL Server?

@mrdenny 2014-10-21 22:40:28

There can't be any applications running against a SQL Server instance which is running the Developer Edition. If there's an application running against it, it is in production. Developer Edition is for test/dev, nothing else. Anyone that connects to it, either as a developer or an admin needs to have a developer license (or an MSDN license).

@wwarren 2014-10-21 23:32:14

Makes sense. I suppose from the database's point of view even a test/dev version of an application is production in its eyes

@Stoinov 2015-03-06 14:45:07

This is not correct - you can run applications and what is more your users can access them under certain conditions. From the current PUR for SQL 2014: Your end users may access the software to perform acceptance tests or to provide feedback on your programs. AND In addition to the Licensed User, any person that has access to your internal network may install and use copies of the software to demonstrate use of your programs with the software.

@Reversed Engineer 2018-06-22 09:53:13

@mrdenny "There can't be any applications running against a SQL Server instance which is running the Developer Edition." - That does not make sense. How would the single developer test his database, unless he were using the applications he had made for it? Even SQL Server Management Studio would be forbidden if what you say is true, since it's an application. Basically he's have to send it raw SQL requests using TCP/IP sockets or raw machine code or something. Oh wait, even cmd.exe and HxD.exe (my favourite hex edit), are applications, so..... those would also be illegal.

Related Questions

Sponsored Content

2 Answered Questions

[SOLVED] Low PLE on NUMA node 000, high on 001

1 Answered Questions

1 Answered Questions

1 Answered Questions

[SOLVED] Oracle standby licence

1 Answered Questions

2 Answered Questions

Sponsored Content