SQL 2005 and SIMS FMS Finance

[thom]

We have just done the SIMS August release update and migrated the DB to the full SQL 2005. After a few glitches it seems to be OK.

 

I was under the impression that the FMS modules would stop using sybase/sqlanywhere and also move to SQL 2005 but when I try to run SOLUS it says that the finance user I login as has'nt got the correct level of priveleges. Does anybody know of a default sysman userpassword that I could use?

 

I phoned up the helpdesk and they said there was definately no Finance update to do with the 2005 migration so not to worry.

 

However, when I run the finance modules on the client they throw up an error but then allow everything to carry on as normal.

I also found this http://www.capitasolus.co.uk/ReleaseNotes/FMS/FMS691_Installation_and_Migration_Guide.pdf and that implies that there is an update?!? I'm confused :?

 

The reason I am concerned is mainly because I will have to install FMS on 2 new PCs and the last upgrade disc we got was in May.

 

Can anybody clear my head?

[Jeremy69]

FMS as from this month has moved to SQL2005. You can run versions up to 6.85 on the old MySQL and continue to do so even after taking the rest of Sims to SQL2005. There is a migration process to take FMS to 6.91 which is the first one that works with SQL2005. The upgrade and migration process is separate to changing sims.net to SQL2005. There is a migration document available from Supportnet to help with this process.

Amazing that your help desk could not be of more help.

[steve]

I had this problem, you need to make sure the SIMS.net update has been run on the PC's before using FMS.

 

You can migrate FMS to SQL 2005, but there's no rush yet.