November 3, 2009 at 7:12 am
I just took a job as a SQL DBA at a very large enterprise. Things are NOT done here like I am used to!
The way they have me deploy changes to live production SQL servers is to develop and test my changes on live production SQL servers. Yes, that's really how its done.
And I know what will happen soon: I will deploy something that will break or destroy something (it is inevitable!), and then I will get blamed for not knowing what I'm doing. It feels like I am playing Russian Roulette on a daily basis. Not good for the 'ol stress level!
So here is my fix: I have now gotten them to give me FIVE clunker old computers, good enough to install Windows Server 2003 and SQL Server 2000 or 2005. So I can set up my own little test lab in my cubicle. This way I can at least build a reasonable facsimile of the production environments (yes, some are even clusters, etc), backup and restore databases to my test environment, and do *some* development and testing on them in my lab, before deploying to a production server.
So I have downloaded the 6-month trial versions of Win Server and SQL Server. I will NOT (and cannot) connect these computers to the network, and therefore not to the internet either. I have to download on one computer, burn files to disk, then move that disk to the Lab computers (sneakernet!). This will be a fully self-contained lab, the computers will only talk to each other via a hub. That's it.
So my question is: What licensing, if any, do I need to be fully, totally, legitimately legal and in compliance with Microsoft? (Yes, you would think I could just ask my Microsoft Rep that question. But I have no idea who that person might be or how I would get in touch, or anything.)
Perhaps I could just install my 6-month demo versions of everything? Then I think I will have to activate over the phone, right? But then will I have to activate all TEN licenses separately? (5 Win Server 2003 and 5 SQL 2000 or 2005??) Or does only Windows Server require activation and not SQL? (I'm used to working on real versions!) Do my TWO downloads allow 5 activations each?? Or do I have to do 10 downloads?? If I install today, would I need to re-install 6 months from now? Or is that even permitted -- do I just get one 6-month period then I have to have them pay for some sort of "Lab license"?? Or is there a license that actually allows this Test Lab type scenario, and does not require re-installs, or new demo licenses every 6 months or whatever??
It seems like the possibilities are endless. Does anyone know?
Thank you very much for your help!
November 6, 2009 at 1:54 pm
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 🙂
November 6, 2009 at 2:03 pm
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.
November 6, 2009 at 2:31 pm
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).
November 6, 2009 at 2:50 pm
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
November 6, 2009 at 3:16 pm
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?
November 6, 2009 at 3:27 pm
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
November 6, 2009 at 3:30 pm
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.
January 8, 2010 at 10:07 pm
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
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply