hutchings_18

Hi simpsonj, Thanks for your reply. However, I found the cause of my problem. The Discover database needs the COMPUTER ACCOUNT of the server that runs the Discover Services AND IIS. For me, this is done by 2 different servers SERVER1 runs the Discover Services and SERVER2 runs IIS so that we can access Discover via a XBAP webpage. I opened SQL Management Studio and checked the Security\Users folder with the Discover database... DOMAIN\SERVER1$ was there, but DOMAIN\SERVER2$ was not. After running this command, it allows me to login: echo Granting Web Service rights in both databases... "%DISCOVER_SERVICES_DIR%\Discover.SqlUserManager.Console" /operation=GrantAppPoolRights /AccountName="DOMAIN\SERVER2$" /Server="%SERVER_NAME%" /DiscoverDatabase="%DISCOVER_DATABASE_NAME%" Replace %Discover_Services_DIR$ with the installation location of the Discover Services, e.g. C:\Program Files (x86)\SIMS\Discover Services Replace %Server_Name% with the servername\instancename of the Discover database, e.g. Server1\SQL2008 Replace %Discover_Database_Name% with the discover database name, e.g. Discover Hope this helps? Thanks, Peter

Hi simpsonj, What do you mean by "unlink the affected user from Active Directory"? I have schools running Discover no problem, but my SIMS Training accounts won't log in, and give me the "catalog" error you've mentioned. I've got a SimsTraining01 database and a corresponding DiscoverTraining01 database. There are 17 of these pairs altogether. Capita are asking me to reinstall Discover, but I'm reluctant to as the schools live databases are running fine. Cheers, Hutch

Hi Matt, Thanks for your info. Would you be able to suggest the best route for me to take with this? Each concurrent user access the same FMSSQL directory, and in doing so, this is where all the DEL files are created. Do you think each user needs their own FMSSQL folder when they launch FMS? Or do you think my pdoxusers file is not correctly configured for access by the users? Thanks, Peter

Apologies for digging this old thread up, but I've just set up a SIMS/FMS training room in our Local Authority where the Finance.exe is shared out via Citrix and each user logs into a different database. Each user tries to access the same part of the FMS application, for example, "Establishment Details", but all get the del#.mb sharing violation error. If they keep trying they eventually load Establishment Details once they get a higher numbered del.mb file (which are stored in C:\Program Files\SIMS\FMSSQL) on the XenApp server. I've tried configuring each user to have their own LOCKDIR in their own folder, but it didn't fix it. I've also tried pointing everyone to the same LOCKDIR, but again, no joy. All users have read/write/modify access. Any ideas??