[sims] FMS client connection failure

[Quatermass]

I've just successfully installed FMS on several new workstations, but on my own one it cannot connect. Looks like the act of running the client (i.e. bringing up the FMS logon box) causes the Server value under HKCU\Software\ODBC\ODBC.INI\SIMS_FMS_DATABASE to be truncated to just the server name (rather than the correct value of servername\sql2008). So logging on then fails. If I set it manually in the registry, running FMS again truncates it again! Any ideas folks?

[british_government]

I had something similar happening with win7, this happened with us because the fms client didn't have access to read the ss_fms_companies.ini properly. Running as administrator was an instant solution. Although not sure if it will work for you as the client has registry access I assume it is elevated already?

[Quatermass]

It is a Win7 client but we don't have that file anywhere - I seem to remember it was a relic of either an FMS migration or sites with multiple FMS databases? Anyway I'm on as an admin so not sure what's going on...

[british_government]

Yeah we have multiple databases so that is why, could be worth right click and run as administrator just to test, UAC can do funny things....

[matt40k]

Check in c:\users\\appdata\Local\VirtualStore

[Quatermass]

@matt40k : SOLVED! Nice one. There was an older, incorrect copy of FMSCONNECT.INI lurking in there. A nice W7 gotcha which I may feed back to our LEA...

[british_government]

Well worth knowing thanks