Yep, completely scrap all of what your doing there. FMS does still requires the SQL 2005 Native Client! It just needs installing.
However, when I go to run FMS it returns the error 'fms create user dsn failed', now I've researched on here and found I should add the database driver for native client for FMS.
I typed odbcad32 into the run box and added the FMS database. This brought up the dialogue for 2008R2 native client so not sure it will work, as the other posts suggest it needs 2005 (hope this is not true by now).
I've got to this point, but don't know how to proceed and what it's actually asking me for?