Lanpak in use without client being open 1

[WalterHeisenberg]

Hello,

I am trying to do a dataload to test databse but get an error that Accpac needs exclusive access. When I look at lanpak users, it says there is an open connection to the database in question. The user logged however is an admin (which limits the possible people to 2) and neither of us have the client open. Furthermore, if I check the SQL activity monitor there are no SQL connections to the database. Does anyone know how to free up a lanpak license when it is showing in use in error?

We're running Accpac 5.6 PU2 on SQL server 2008 r2.

 

[WalterHeisenberg]

Just worth noting, I took the SQL database offline and brought it up back online to ensure all connections were dropped as well as confirm there were no processes open via SQL activity monitor.

 

[Jay Converse]

Delete ..\SITE\SEMAPHOR.BIN and LANPAK.BIN

 

[WalterHeisenberg]

Thanks Tuba. I am guessing I would need all users out of all companies in order to do this?

 

[Jay Converse]

Of course.

 

[WalterHeisenberg]

Just to share final results, I ended up not having to delete either file. Attempted to do so but got a file lock error. Checked the open files and sure enough there was a lock on SEMAPHOR.bin. Fixing the lock fixed the logged in users and now I can do the database load. Thanks Tuba for pointing me in the right direction.