Have been busy installing an internal version of Team Foundation Server 2012, hosted on Windows Server 2012 using Forefront Threat Management Gateway 2010 to perform SSL operations and helping to ensure I don’t need to put my TFS server directly on the Internet.
As usual there were a couple of gotchas with this configuration so if there’s any interest in this configuration, I’ll find some time to write up my notes…
If I had one pound sterling for every Team Foundation Server install I’ve performed in my life I’d be a rich man by now. Back in late 2004/early 2005 when a number of us were playing with the alpha TFS 2005 bits, all the components had to be installed on a separate machines and if you made the slightest mistake it was a rebuild job from the bare metal – of course Virtualisation technologies like snapshotting weren’t mainstream in those days and installation was a pain!
Fast forward 8 years and here we are; .NET Framework is properly integrated as a system component in the OS, Virtualisation and snapshotting is the norm, disks have got much faster, TFS installs in minutes (not hours) and automatically configures IIS and all the prerequisites it needs, which makes life amazingly easy.
Grant Holliday wrote this article that I still refer to when I need to build a TFS2010 virtual machine from scratch so when I came to installing a brand new Windows 8 Server with SQL Server 2012 and TFS “11″ in a Virtual Machine I had to do a little bit of thinking for myself.
Assuming you want to create a Default instance of SQL Server 2012 complete with Analysis Services and SQL Server Reporting Services (SSRS) as if you had accepted all the defaults:
- start with a completely blank Windows 8 Server image with no roles or features added
- mount the disk in your favourite manner (i.e. mount the .iso image on your host machine from the menu on your guest VM, or use Virtual CloneDrive to mount the .iso file locally)
- at a new administrator command prompt, replace the highlighted bits with a valid user who you wish to have full access to everything!) and paste the whole thing:
d:\setup.exe /QS /ACTION="Install" /ENU /UpdateEnabled /FEATURES=SQLENGINE,FULLTEXT,AS,RS,SSMS,ADV_SSMS /UpdateSource="MU" /INDICATEPROGRESS="True" /X86="False" /INSTALLSHAREDDIR="C:\Program Files\Microsoft SQL Server" /INSTALLSHAREDWOWDIR="C:\Program Files (x86)\Microsoft SQL Server" /INSTANCENAME="MSSQLSERVER" /INSTANCEID="MSSQLSERVER" /SQMREPORTING="False" /RSINSTALLMODE="DefaultNativeMode" /ERRORREPORTING="False" /INSTANCEDIR="C:\Program Files\Microsoft SQL Server" /AGTSVCACCOUNT="NT Service\SQLSERVERAGENT" /AGTSVCSTARTUPTYPE="Manual" /ASSVCACCOUNT="NT Service\MSSQLServerOLAPService" /ASSVCSTARTUPTYPE="Automatic" /ASCOLLATION="Latin1_General_CI_AS" /ASDATADIR="C:\Program Files\Microsoft SQL Server\MSAS11.MSSQLSERVER\OLAP\Data" /ASLOGDIR="C:\Program Files\Microsoft SQL Server\MSAS11.MSSQLSERVER\OLAP\Log" /ASBACKUPDIR="C:\Program Files\Microsoft SQL Server\MSAS11.MSSQLSERVER\OLAP\Backup" /ASTEMPDIR="C:\Program Files\Microsoft SQL Server\MSAS11.MSSQLSERVER\OLAP\Temp" /ASCONFIGDIR="C:\Program Files\Microsoft SQL Server\MSAS11.MSSQLSERVER\OLAP\Config" /ASPROVIDERMSOLAP="1" /ASSYSADMINACCOUNTS="VS11BETA\Administrator" /ASSERVERMODE="MULTIDIMENSIONAL" /SQLSVCSTARTUPTYPE="Automatic" /FILESTREAMLEVEL="0" /SQLCOLLATION="Latin1_General_CI_AS" /SQLSVCACCOUNT="NT Service\MSSQLSERVER" /SQLSYSADMINACCOUNTS="VS11BETA\Administrator" /TCPENABLED="1" /NPENABLED="0" /BROWSERSVCSTARTUPTYPE="Disabled" /RSSVCACCOUNT="NT Service\ReportServer" /RSSVCSTARTUPTYPE="Automatic" /FTSVCACCOUNT="NT Service\MSSQLFDLauncher" /IAcceptSQLServerLicenseTerms
Installation will progress for a while but when finished you have all the components required to do the TFS 11 install immediately afterwards.
Has been a long time since I posted on here (sign of the times I think, most of my updates are relegated to 140 characters these days). I’ve been very busy in the UK, India and other countries helping a very large company get a hold of their deployment engineering practices as part of an ALM overhaul.
It’s nearly November and RippleRock are sponsoring the ALM Summit in Redmond. If you are and you’re from the UK, drop me a note in the comments – we might even organise a mini UK ALM User Group over a beer whilst we are out there…
The inaugural meeting of the UK ALM User Group was held on Thursday 11th February at Microsoft’s Cardinal Place offices near Victoria in London.
The session was deliberately left with an open agenda, and after we had made our introductions we shared many anecdotes from our collective experiences with ALM, the discussion on the day mainly focusing around people and process rather than the tools.
As the majority of people in the meeting were practitioners using Microsoft ALM tooling – there was widespread support for bringing in presenters on non-Microsoft ALM tools to ensure that the group kept abreast of the latest developments.
Some of the wider questions about the group included:
– What is the vehicle for the UK ALM User Group message?
– Should the UK ALM User Group have a “voice”?
– How do we spread the word about ALM and ‘make it stick’.
Lessons learned were that we need to prioritise the topics and also timebox them! Hopefully in future sessions this will be easier to achieve.
It was agreed that each member of the group should try and post a session topic to the User Group website (http://ukalmug.ning.com/forum/topics/discussion-topics-for-uk-alm). The most popular session topics will be determined and we can then find presenters for them.
There was also broad support for having the UK ALM User Group more regularly than the initially proposed (quarterly). More details on this will follow soon. If anyone can recommend a bar or other venue in London with presentation facilities then please let me know.
Drinks, socialising and continuation of some of the discussions were then had at a local bar…
Thanks to Microsoft for providing the venue and for the enthusiastic attendees some of whom had travelled from out of London to come to the meeting. Hope to see all of you and more at the next meeting.
Please remember to tag anything related to the user group on twitter with #ukalmug. There is also a list of members on twitter at @ukalmug/members
This post is to announce the UK ALM User Group that I have created. This has been a personal objective of mine for some time and I have decided that now is as good a time as any to actually make it happen!
The UK ALM User Group is for practitioners of Application Lifecycle Management (ALM) and Software Development Lifecycle (SDLC) in the UK to get together and discuss and share ideas, tools and techniques, as well as to socialise somewhere other than Agile and Software Development conferences!
Initially we plan to meet quarterly, the first dates are already lined up for February and May. Membership is free and we have some venues in mind in London to visit to start off with – not to say that if there is enough interest those of us in the south will travel to other UK locations too!
ALM Practitioners and enthusiasts from all technical disciplines are welcome – we’re an agnostic bunch!
To sign up, visit: http://almug.org and join in the discussion – especially welcome are presenters for our first meeting planned for February 11th 2010.
Hope to see some of you there!