[SIMS]Connecting an old FMS database

[jwonnacott]

I've just been asked to resurrect our old FMS database (We stopped using FMS in 2011) to track down some mystery or other.

I've fired up the old VM the server used to run on and attached the last backup of FMS.mdf (using dbattach as I recall it does something "special" with users), I can see all the tables etc..

I've fired up an old XP VM with the FMS programme on it and it's pointing to the server.

No-one can remember their old username or password so I've reset the FMS_sysman password using SQL server Management studio.

I'm getting " Invalid User ID/Password or Database Name" when I try to logon to FMS.

 

Any ideas?

 

Thanks,

James

Edited September 28, 2015 by jwonnacott