Hope someone can help?
I'm not an SQL (or SIMS) expert in any way, only a basic understanding but I've got a SIMS/FMS problem at a school and the SQL 'Expert' is off sick.
We have tried CAPITA but I believe they said it's an SQL problem and so not part of their support.
When a User tries to log on to SIMs or FMS they get a timeout query and they can't log in. once the time is increased they can then log in.
However, once they're in, for no apparent reason they get logged out and then can't log back in again.
If we restart the server and restart the services, everything is fine again for about an hour and then the same things happen again.
Hope that makes sense?
Any pointers anyone can give are gratefully accepted.
Thanks