CMIS won't run as user account, runs fine under Admin account
Over the summer, we have rebuilt the network at a partner school. They use CMIS Facility.
Since the rebuild we have noticed users are struggling to run CMIS Facility in the context of their own user accounts. If I log on to a PC as the domain administrator and start Facility, the application starts fine and I can use it. If the user logged on to the PC as themselves, despite having the same mapped drive letter to the Facility share on the server, and the same permissions on that share as the administrator (I was testing, I know this is not a good idea long-term), the application struggles to start - often flashing up an ODBC connection timeout error message. They can click through this and the application starts, but they can't do simple stuff like backup the database. The backup operation fails with an "unspecified error".
I know this will be related to permissions but I am at a loss to explain where. File and share permissions are - as best I can see - correct (aside from when I slackened them off to eliminate them), the SQL setup is - as best I can see - correct, but still a normal PC user can not seem to run this application correctly.
Any thoughts? We installed MS SQL 2008 R2 Express Edition to run Facility in as it's a small school and only one or two staff ever need access - but I've done this before without issue even though I'm aware other schools use full-fat SQL Server. The choice of SQL Express edition was a cost-saving measure for this small school.
We used to be a Facility school ourselves before moving to SIMS, but this was four years ago and I've all but forgotten the caveats needed to get Facility to do what you want it to so I've probably missed something blindingly obvious - hoping someone can point me in the direction of just what
Thanks in advance!