SQL + Win Server Licensing in a TEST ONLY lab environment??

Question

SQL + Win Server Licensing in a TEST ONLY lab environment??

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

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

torpkev SSCarpal Tunnel Points: 4819 More actions · Answer 1

i can't answer the whole post. but if you're building clusters, remember you'll need a domain controller setup..

i recently built a sql cluster for practice but couldn't join the network and had to build a domain controller just to get mscs working.

also, see if you can get some copies of SQL Developer installed.. you can get those fairly cheap. Heres some info on Developer edition

http://www.microsoft.com/sqlserver/2005/en/us/developer.aspx

--------------------------

I long for a job where my databases dont have any pesky users accessing them 🙂

Ian Scarlett SSC-Insane Points: 23197 More actions · Answer 2

See if your company will swing for an MSDN subscription.

That will entitle you (and only you) to install and use as many copies of the software included in your subscription and on as many computers as you need (there are different subscription levels giving you more/less software), as long as it is solely for development and/or testing.

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 3

Ian Scarlett (11/6/2009)
See if your company will swing for an MSDN subscription.
That will entitle you (and only you) to install and use as many copies of the software included in your subscription and on as many computers as you need (there are different subscription levels giving you more/less software), as long as it is solely for development and/or testing.

I thought there was a limit of 10 systems (computers).

GSquared SSC Guru Points: 260824 More actions · Answer 4

Company MSDN subscription or get your own TechNet subscription. Either one will allow you to do what you're doing.

If they won't go for that, then get them to get copies of Dev Edition of SQL, and they'll have to pay for Windows licenses. Dev Edition is just like Enterprise/Trial in terms of features, but unlike the trial version, it doesn't expire.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

Ian Scarlett SSC-Insane Points: 23197 More actions · Answer 5

Lynn Pettis (11/6/2009)
I thought there was a limit of 10 systems (computers).

I don't think there is, Lynn... this is from the MSDN site

MSDN subscriptions are licensed on a per-user basis. One person can use the software to design, develop, test, or demonstrate his or her programs on any number of devices. Each person who uses the software this way needs a license

Are you perhaps thinking of the Direct Access subscription, which, for some software, allows only 10 installations?

Ian Scarlett SSC-Insane Points: 23197 More actions · Answer 6

GSquared (11/6/2009)
Company MSDN subscription or get your own TechNet subscription. Either one will allow you to do what you're doing.

I don't think Technet will allow the OP to do what he/she wants, as it specifically excludes testing.

This is the link to the UK page comparing MSDN and Technet Plus... I doubt the US rules will be any different.

https://msdn.microsoft.com/en-gb/subscriptions/dd362338.aspx

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 7

Ian Scarlett (11/6/2009)
Lynn Pettis (11/6/2009)
I thought there was a limit of 10 systems (computers).
I don't think there is, Lynn... this is from the MSDN site
MSDN subscriptions are licensed on a per-user basis. One person can use the software to design, develop, test, or demonstrate his or her programs on any number of devices. Each person who uses the software this way needs a license
Are you perhaps thinking of the Direct Access subscription, which, for some software, allows only 10 installations?

Could be. It has been a quite a while (5 years or more) since I looked into it. But for some reason the 10 system limit is just stuck in my head.

Ryan D. SSCommitted Points: 1595 More actions · Answer 8

Hi torpkev,

What kind of lab setup did you create? I'm trying to the same thing at home for my personal testing.

I'm currently using VMware workstation 7. I have a windows 2k3 R2 and windows 2k8 as my base machines. Did you find it necessary to create a Primary Domain Controller and Active directory? Basically I want to create a 2005 and 2008 sql environment of my personal test such as creating dashboard reports for collecting SQL metrics and auditing information.

Thanks,

Ryan