Installing TFS 2012 on Server 2012 with SQL 2012
Join the DZone community and get the full member experience.Join For Free
i need a tfs environment to use for demos and what better time to do a full upgrade than when we get some nice prizes from microsoft. today the release candidate for both windows and for visual studio was released to the public. you can download it off the public sites or you can use you msdn account to get all of the goodies.
figure: msdn subscriber downloads
my very favourite feature of windows 8 is the ability for me to run hyper-v on the client. so all i need is a nice new “kraken” server to run.
figure: running hyper-v on my windows 8 laptop (not rc yet)
you can see my other machines there, and yes; i can run them all at once thanks to my awesome laptop provided by nwc.
figure: vm’s galore (with 3 running)
this allows me to be ready to demo in almost any situation without requiring access to the internet. the only thing i really cant demo is lab management and i don’t want to have to cart around a data centre like brian rendell does.
i configure all of my vm’s with two network adapters, public is connected to the internet and private links all of the vm’s and the host.
figure: public is wired to my internet
this allows me to connect to my vm’s with an ip address that i already know, versus having to look up the ip that some dhcp gave it.
i have three stages to this install that will allow me to have a good demo instance:
- install and configure windows server 2012
- install and configure sql server 2012
- install and configure tfs 2012
i need to know how long this stuff takes as i have 2 team foundation server 2012 installs next month. its in high demand and almost every single customer demo of visual studio 2012 i have don has resulted in a customer wanting to “go-live”. yes, its that good and that much of an improvement. one of our customers that is going live on the release candidate is a large us manufacturing company with a projected 40k users in tfs. no hints…
install and configure windows server 2012 (30 minutes)
as i want to have a demo box that is all singing and dancing i need to have server 2012. i will be on the road for the next 3 weeks doing demos and i want to blow folks away with all of the new stuff. server 2012 is not really for demo but more to frame the demos. i have 2 windows 8 vm’s for client demos, but some server side bells and whistles always go down well.
figure: currently only datacenter is available
don’t b e afraid of datacenter, it really just means that it includes all of the features, you don’t need to use them all. i will however recommend that you select the gui mode rather than the core if this is a demo box. you may only have one box running and it would suck to have to remote into another box just to manage this one. if however you will have many server boxes then the recommended would be to use core.
figure: takes just a few minutes on ssd
you will likely be familiar with the windows install and it is the same as previous versions, if a little simpler and prettier.
it takes very little time to get to a login , but remember that there are still a few things to do.
it may be a siney new server, but it does not have a name i would like nor can i connect over remote desktop. you might be wondering why i want to use rdp! well, it has to do with configuration. i get way more options and i don’t have to settle for an ugly 4×3 display. i want everything to be a nice hd 16×9 . to achieve that i need to:
enable remote desktop
by default you do not have rdp enabled. it is easy to enable.
note: if you are going to connect from a pre windows 7 computer then you will need to un-tick the “network level authentication” box.
set an ip address (no dhcp on windows 8 client)
as i do not run dhcp on my windows 8 box i need to set the ip, this is the way you want to do it anyway for demo boxes so you remember what to connect to.
figure: set a static ip for your private network
note: i cheat and don’t really remember. i put the ip in the name
- give my server a real name like “kraken”
now i can access my new server by name or by ip. i tend to use ip as the name can sometimes go awry as it often can with no active directory.
figure: sigh, nice hd 128×720 (16×9) screenshots
done – server 2012 installed and configured
install and configure sql server 2012 (30 minutes)
i will be install sql server 2012 for this box and just like 2008 you can’t just click an install button, you have to go through a bunch of menus to get there. not perfect, but they are trying to prevent the average muppet from messing up their system. i however am and exemplary muppet and can mess it up anyway. as i am in a vm, and this may not go well, my first task is to snapshot my vm. that way if i mess it up i can always try again without having to completely reinstall.
figure: snapshots can save your bacon
you have probably done an install 100 times for sql server, so i will just note the differences and any problems.
sql 2012 has been out for a couple of months so there must be at least 10 cumulative updates by now!
figure: we are installing a stand-alone instance
the installation for sql is surprisingly uneventful when i do it, but i find that customers tend to ignore the tfs requirements for sql and just install it the way they always do it.
i want to be able to choose what is installed, and i certainly don’t want everything. and, no, you can’t use sql server in power pivot for sharepoint mode as it is not currently supported. i had a nice long discussion with jeff levinson about this and you certainly don’t want to select that option. i may be scottish but jeff can turn the air blue
as i am creating a server only box i don’t really want any of the client tools for working on this box but i do want the sql management tools. i expect to only be logging onto this box to demo server configuration, not client connectivity.
i should also point out that i am a vanilla kind of guy that believes that there are only two reasons to change the defaults:
- the documentation tells me so
- long painful experience
so, here are the small changes to the default configuration that i do specify:
change default accounts for active directory ones
if you are wanting to use kerberos or you have more than one server in your environment then you need ad accounts. in this case i am leaving it alone and trusting that they guys that wrote the product kew what they were doing.
figure: if you are part of an ad environment use ad accounts
note: i cant stress this enough: never change the collation… ever…
add administrators or some other group to sql
this is a long painful experience one. many time i have seen sql become inaccessible cox and account got changed. add a group in here…
figure: add permissions to sql
figure: add permissions to analysis services
if you forgot to add permissions go back now and add them in manually. you will kick yourself if you do not.
figure: all components installed successfully
done – install and configure sql server 2012
the very last thing you would do, if everything went well is to remove the snapshot. they take up space and require extra processing and disk access to resolve. not much you understand, but enough that it make sence to clean up after yourself. the purpose of the snapshot was to get back to a stable os in sql failed. it installed just fine, so we are all good.
install and configure tfs 2012 (30 minutes)
now the money shot. i need a all singing and dancing tfs 2012 installation with reporting and sharepoint. in order for me to back out again i will perform a snapshot so that i can get back to a good state without having to rebuild.
don’t blink after you click “install now” coz you might miss the install. once it is complete you will be presented with your choice of wizards.
figure: what flavour would you like
in this case i want a single box that does everything so “standard single server” looks like the best option. in tfs 2010 this installed sql express, but it looks like they have improved the experience and i will give it a go.
the wizard will lead you through the installation process, but with standard there are only a few options anyway.
figure: enter the reporting & sharepoint account
it is a requirement of both sharepoint and reporting services that this be a separate account from the one that they are running under. i just created a local administrator account called “tfsservices” that can be used for anything.
at this point i ran into “tf400079: the amount of ram on this computer is not sufficient”. what the heck i have tones of ram…
figure: tf400079 sharepoint… ahhhhh….
tf400079 : the amount of ram on this computer is not sufficient to support sharepoint 2010 with team foundation server. you must have the following amount of ram available: 4 gb
while it is nice that it checking, i have dynamic memory enabled and this server can demand up to 20gb of ram (that’s what i can give it).
figure: should demand what it wants and windows shall provide!
i need to shutdown the vm to add more memory so lets do that now. i will try to give it 4 gb of start-up memory and se if that does it. it will still be dynamic, but the os should report as having 4 gb even if it is only using 1 gb. we will see.
figure: add startup ram to the required amount.
note: due to sharepoint installing tfs 2010 / tfs 2012 has a minimum 10gb ram requirement. this goes away with sharepoint. after a reboot we can launch the wizard again.
figure: run the admin console again
did you spot my mistake? there was another error message listed below the ram one! did you see it! well i have it now…
figure: tf400080: sharepoint 2010 can not be installed on windows 8
that would be ok if i was running windows 8, but i happen to be running server, and after a little goggling, it looks like it was working on he beta. hey-ho… lets skip that for now…
so without sharepoint everything runs smoothly.
i should point out that all problems either stem from reporting services or sharepoint.
i can install and configure sharepoint later when someone else has gone through the pain of dealing with the sharepoint team.
i love the tfs team for not letting me screw up my system because some component part has a problem.
once the checks are complete you can go ahead and run the configuration for real. now while i have had it fail at this point, that occurrence is so rare and the resulting issue so complex that i doubte that you will run into anything like that. that said there is murphys law and a very wise wizard once said “1 in a million chances happen 9 times out of 10”.
just two checks left… first to make sure that everything is healthy in the admin…
figure: tfs administration console looks happy
and second to check out the web ui.
now you cant create team projects in the ‘”on-premises” from the portal like you can in tfs preview, so we will need to wait until i have a client to create one before i can really exercise this puppy. everything does however look good with no errors…so i am calling it.
done – install and configure tfs 2012
so, no sharepoint on server 2012. can’t say i am going to miss it. i have been spending a lot of time on the team foundation service preview which does not have sharepoint. and you know what. i don’t miss it. i have figured out other less painful ways to store documents (skydrive, version control, sugarsync) that can all be made public, or close to it, which actually makes things easier.
you solve a problem with sharepoint, and now you have two problems.
good luck with your 2012 deployments, i have a bunch of production upgrades this month (none with server 2012 as well) so i will keep you posted to any issues or problems.
Opinions expressed by DZone contributors are their own.