Target Process 2.16 Installation on Windows 7 and SQL Server 2005 Express

Aug 23, 2009 by Kornelije Sajler    2 Comments    Posted under: Test Lab

TargetProcess is a proprietary agile project management tool supports Scrum, Extreme Programming (XP). From the start of August, and with version 2.15 TargetProcess have support for Kanban. A Kanaban is new switch in Software Development from Agile to Lean – also known as JIT (Just-In-Time). For more about Kanban read writings of Michael Dubakov CEO of TargetProcess and Derick Bailey on Los Techies.

The notion of existence for TargetProcess (TP) I’ve had from Steve Bohlen excellent screencast series Autumn Of Agile (never finished, though). TP is just plain simple, user-friendly, fun to work with, and TP have Community Edition for 5 users pack for free. Community Edition version is more than enough for me and for many others.

The installation of TP is quite trivial even though I have had problems with IIS 7 Application Pool user on Windows 7 RC release, but with this final version, no problem, quick and smooth, of course only if prerequisites are satisfied.

I think TP is made with Spring.NET, uses NHibernate for ORM, I think NVelocity is templeate engine, and its user friendliness entirely comes from ExtJS.

Gathering Reuquirements

First we have to download TargetProcess Community Edition. It can only be through signup, and as I remember, you have to wait for TP reply mail one or more days. In mail is a link to download TP and also licence and good thing is, once signup, you’ll get all TP updates, revisiting this mailed link.

TP requirement is a SQL Server database either 2005 or 2008 and what is good Express version are supported but for Windows 7 we have to install SQL Server 2005 SP3, older, I think are not compatibile with Windows 7.

SQL Server 2005

TP have requirement for SQL Server to use SQL Server Authentication. It is no problem if you haven’t install SQL Server, you can use Mixed mode during installation and apply password for sa user, but if you have SQL Server installed, you have to do two things, easily done with SSMS Express (and use SP3 version for Windows 7) :

1. Log on to your SQL Server SSMS Express then right-click on your server (SQLEXPRESS), choose Properties. It popup the window where you have to choose Security and on Server Authetication click radio button SQL Server and Windows Authentication, save it, and it requires to restart the server – easily done through SQL Server Configuration Manager or Administrative Tools – Services
2. Enable sa user and give him a password – In your SSMS SQLEXPRESS instance click on Security node in tree view to expand, then expand Logins. Here is the sa user, right-click on him Properties in popup window first choose Status. sa user is disabled by default so in status there is Login and we have to click radio button Enabled, and when is sa user is enabled on General in popup window you have to set password for our sa user.

Note: It is not wise to use sa user in production or over Internet, this is only for testing and local purpose. For production you could create new user and give ownership on database created for TP and used through installation.

TP have a also requirement for .NET 3.5 SP1 to be installed and IIS 7 which is not installed by default in Windows 7 but can be easily done with Turn Windows features on or of (inside Programs in Control Panel). Where you have to choose (check) Internet Information Services. It is clever to check every feature inside except FTP Server (of course you can check it if you need it). It can all be done through Web Platform Installer, but for me it is better to do it manually!

Smooth installation

Now the installation of TP should be quick and smooth, and only thing you have to enter is Database server (.\SQLEXPRESS), and password entered during installation of SQL Server or added through Security/Logins. After install, you can run TP from your local Web Server with username admin and password admin.

First thing when you’re logged inside TP is to apply your given licence, choosing Admin -> Licence. If you have serial number you will choose Automatically or Manually if you have .lic file on your disk, and in People link in upper menu change the admin account password to whatever you want. Nice thing is, at your home page is a link to generate the sample project from which you can learn a lot.

Enjoy in TargetProcess because, it is a wonderful product. If you have some questions please ask and stay Lean and Agile!

• 
  Ethan Trewhitt March 9, 2012 at 04:08

  Hello there, I think you could be able to help me. I have a MSSQL .ldf and .mdf file which I have to restore. Any ideas on how to achieve this? Many thanks
• 
  pregnancy test on period April 6, 2012 at 08:01

  I precisely had to appreciate you all over again. I’m not certain the things that I would’ve used in the absence of these creative ideas revealed by you on such industry. It actually was a real intimidating scenario in my circumstances, nevertheless understanding a new skilled form you resolved the issue forced me to leap with gladness. I am happy for your information and wish you are aware of an amazing job you were carrying out instructing people by way of a web site. I know that you have never got to know any of us.

Got anything to say? Go ahead and leave a comment!