Anothername Posted October 11, 2019 Posted October 11, 2019 Hi All, Is there a way to find the SIMS FMS database location from within SIMS FMS? The connect ini file has it listed, but on searching I can't find the database name it mentioned. Thanks.
FishCustard Posted October 11, 2019 Posted October 11, 2019 The connect.ini lists the server and the database - what DBs are shown on the server? Just the SIMS one?
Esteban_Child_of_the_Sun Posted October 11, 2019 Posted October 11, 2019 you want to look in the fmsconnect.ini fr the FMS details, the connect.ini only hold the SIMS details.
Anothername Posted October 11, 2019 Author Posted October 11, 2019 Our SIMS/FMS was moved over to a virtual server as we have moved over to Bromcom. We still use FMS for finance and have access to our old SIMs but are needing to install an data extraction API for FMS. The connect ini settings I can find are from like 2016 but they don't appear to work with inflo. I'm trying now with the IP address of the virtual SIMS server rather than servers name to see if that works. Still can't find the fms database. Not sure if it might have been installed on a local machine. No one here has a SA account and there are so many old versions of SIMS/FMS in the SIMS folder that it's hard to unpick.
Atomic_Zombie Posted October 11, 2019 Posted October 11, 2019 The file you are looking for is FMSConnect.ini . Connect.ini is only for SIMS . the default database name is FMSSQL , that may help you find the DB. also look in the DATA folder of your SQL installation (eg C:\Program Files\Microsoft SQL Server\MSSQL11.SIMS2012\MSSQL\DATA)
PotNoodleTech Posted October 11, 2019 Posted October 11, 2019 Yes as above if you look at a client and open the FMSConnect.ini you will see the server name / database instance listed.
Anothername Posted October 11, 2019 Author Posted October 11, 2019 I have searched for the FMSConnect ini on the virtual server, but only seem to find old fms ini files, which point to a database called 'academy'. Searching on the virtual server for the academy database yields no results neither does searching for a data base called FMSSql. I can only think it must still be hosted on a local computer. I'll have a look at the FMSConnect.ini on the client.
Anothername Posted November 5, 2019 Author Posted November 5, 2019 I did find the database and it was hosted on a virtual server, but had to rdp into the server rather than the SIMS folder that was being shared from the server.
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now