MS SQL Licences

[sh33n]

Basically what are the licensing requirements for installation of the below on a development system, not connect to the Internet:

SQL 2005 Std Edt
SQL 2005 Ent Edt
SQL 2000 Std Edt

If anyone has definite answers with any links that would be great, thanks.

 

[Daz]

An SQL server license and then required CALs.

Or an SQL Processor license for as many processors as you have per server.

 

[sh33n]

Would have want per processor Daz; but think I've got the right answer now anyhow from MS.

They assure me that we can install SQL for use in a test / demo environment under our MSDN subscriptions if all developers using the system have MSDN subs, which we do.

 

[Daz]

Right, you didn't mention MSDN

 

[Darren S]

Basically what are the licensing requirements for installation of the below on a development system, not connect to the Internet:

SQL 2005 Std Edt
SQL 2005 Ent Edt
SQL 2000 Std Edt

If anyone has definite answers with any links that would be great, thanks.

Big money if you're going per-processor. How many devs would be on the system internally? If there are loads of you, you quickly get to a break-even point where the cost of the SQL CALs surpasses the costs of the PP licence.

I don't think you can buy SQL2000 stuff anymore, but you should be able to retrograde the license to allow you to install it. We bought PP license for SQL2005 back at the tail-end of 2006. I think (though I maybe wrong here as it's a while back) - that 2x per-processor license for SQL2005 Standard worked out at around £11k.

D.

 

[sh33n]

We have the licences for the "live" boxes already mate, this was for a new development system only.

It's a mind field all this stuff, but after speaking to MS I think we're covered already

 

[Mike_182]

Development/test systems can be covered by MSDN subscription, it's just live systems that require full licences. We've just discovered we can have our active/active SQL cluster on SQL Standard 2005 as opposed to Enterprise - it's only 3-node Active clusters that apparently require Enterprise

 

[dk]

Development/test systems can be covered by MSDN subscription, it's just live systems that require full licences. We've just discovered we can have our active/active SQL cluster on SQL Standard 2005 as opposed to Enterprise - it's only 3-node Active clusters that apparently require Enterprise

thats right, sql 2005 standard allows 2 node clusters, anything more and its enterprise. this is still not the case for 2000 though, that still requires enterprise licenses for a 2 node cluster.

 

[sh33n]

Another bloody requirement that's hard to spot then ^^

Luckily we aren't running clusters.

 

[Darren S]

We have the licences for the "live" boxes already mate, this was for a new development system only.

It's a mind field all this stuff, but after speaking to MS I think we're covered already

Hehehe! Tell me about it. I really do think that Microsoft try their damned hardest to make licensing difficult.

In theory, its a piece of piss. Yet they go out of their way to make it hard.

D.

 

[Mike_182]

Development/test systems can be covered by MSDN subscription, it's just live systems that require full licences. We've just discovered we can have our active/active SQL cluster on SQL Standard 2005 as opposed to Enterprise - it's only 3-node Active clusters that apparently require Enterprise

thats right, sql 2005 standard allows 2 node clusters, anything more and its enterprise. this is still not the case for 2000 though, that still requires enterprise licenses for a 2 node cluster.

Yeah, we've currently got 4 2000 Enterprise clusters - the scary bit was paying for the upgrade to new hardware (dual quad Xeons) on 2005 Enterprise - fortunately this change in licencing model means it's not even a quarter as scary as we thought!!!

 

[sh33n]

Developer Edition includes all of the functionality of Enterprise Edition, but is licensed only for development, test, and demo use.


^

From the MS site, does any have any further info on what "demo" use means?

Ie can we use it as a demo system connect to the internet for clients to approve features / updates / etc?

 

[dk]

it means not in production, so if its being used as a porduction machine then it needs a full license, so this server for customers to approve updates, is it production, which i understand it to be people connecting to it is production, testing would be just the developer accessing the system.

 

[sh33n]

it means not in production, so if its being used as a porduction machine then it needs a full license, so this server for customers to approve updates, is it production, which i understand it to be people connecting to it is production, testing would be just the developer accessing the system.

Damn.

Our IT Director has been given a high level MS contact so I've asked him to provide definite answers for us.

Not a major issue if we can't do this, just a nice to have.

 

[@Spoonie]

DK is right, if customers are going to access it then they could be classed as 'testers', they will therefore need Developer licenses or you need to properly license the box.

Demos tend to be non-interactive.

From:

http://download.microsoft.com/downl...b-61377df9c5c2/SQLServer2005Licensingv1.1.doc

DEVELOPER EDITION
SQL Server Developer Edition is a separate product and is used for development and testing purposes only. It is licensed per developer or tester (person).

 

[funklenut]

I'd just use SQL Server Express, which is just the new MSDE, has some limitations like DB size must be less than 2GB and has some connection limit to 10 connections I think. Totally free, can even be shipped with your product..

http://www.microsoft.com/sql/editions/express/default.mspx

 

[ChrisR]

Isn't licensing fun Got Matt Ward coming down again soon DK to finish off the SAM stuff at our place, I get an ISEB course out of it as well, woohoo.

 

[dk]

Isn't licensing fun Got Matt Ward coming down again soon DK to finish off the SAM stuff at our place, I get an ISEB course out of it as well, woohoo.

lol, Matt is funny, quirky guy, ask him about his chickens!

 

[funklenut]

Sounds like you guys are complete losers if you need to get M$ involved for something so trivial, I'm a developer and pity you if you are tech guys, you wouldn't last 5 mins in my org if you were so incapable!

 

[Aluco]

Sounds like you guys are complete losers if you need to get M$ involved for something so trivial, I'm a developer and pity you if you are tech guys, you wouldn't last 5 mins in my org if you were so incapable!

Go stand in the corner.

 

[funklenut]

More like go stand in the dole queue where you belong

 

[dk]

Sounds like you guys are complete losers if you need to get M$ involved for something so trivial, I'm a developer and pity you if you are tech guys, you wouldn't last 5 mins in my org if you were so incapable!

how about you wind your neck in and maybe develop yourself a personality which doesn't put you across as a t**t.

MS licensing is a very complicated subject, there are many different licensing schemes and I am sure you don't know all of them, infact i'm willing to bet money that a new start from my company whos been there three weeks knows more about it than you do after having to go through hours of training.

Most of the time, MS don't even know all the ins and outs of the rules and need to double check on them, its not just about buying a license, depends on what scheme you're on to what rules you play by.

Now run along and do some developing on that personality of yours.

 

[ChrisR]

Isn't licensing fun Got Matt Ward coming down again soon DK to finish off the SAM stuff at our place, I get an ISEB course out of it as well, woohoo.

lol, Matt is funny, quirky guy, ask him about his chickens!

heh already heard about them when we went out for dinner last time. Was telling me all about his haunted house as well, really nice chap though.

 

[sh33n]

Sounds like you guys are complete losers if you need to get M$ involved for something so trivial, I'm a developer and pity you if you are tech guys, you wouldn't last 5 mins in my org if you were so incapable!

lol @ being a developer and using MS SQL Express; must be some really complicated stuff you're involved in.