Yep, this looks safe enough for me to put everyone's Social Security Number, medical history, and dental history into. |
Last Friday, I received an email. In it was a request that sent a chill down my spine:
We're teaching a class on Dentrix and need it installed in a computer lab.Images of fresh-faced students with local administrator access on computer lab PCs filled my mind. Now, this isn't the first time I've faced this - the usual solution is to set the PC to dual-boot, with the administrator image being off of the student lab domain. It's not a perfect solution, but it at least keeps the damage to a minimum and protects our student lab servers. However, this solution only works with technologically sophisticated instructors and users; the instructors that needed Dentrix are sophisticated about Electronic Health Record systems, but not so much about proper Windows booting protocol.
I needed a better way. With some trial and error, I think I found one.
The first reason Dentrix requires local administrator rights is because it places its data folders in its installation directory, which, by default, is C:\Program Files (x86)\Dentrix [1], and whatever user is running Dentrix must have sufficient access to write to these directories. So, the first step to the solution is to make it possible for standard users to write in the standard installation folder:
cd %programfiles(x86)%I also, just on the safe side, granted write access to everything else installed with Dentrix:
icacls Dentrix /grant "Users:(OI)(CI)(F)" /t
icacls "GURU LE" /grant "Users:(OI)(CI)(F)" /tNext, we need to move the installed desktop shortcuts to places accessible by everyone instead of just the profile that Dentrix was installed under:
icacls "Guru Limited Edition Server" /grant "Users:(OI)(CI)(F)" /t
icacls "Business Objects" /grant "Users:(OI)(CI)(F)" /t
move %userprofile%\Desktop\*.lnk C:\Users\Public\Desktop
move "%userprofile%\AppData\Roaming\Microsoft\Windows\Start Menu\Programs\Dentrix Learning Edition" "C:\ProgramData\Microsoft\Windows\Start Menu\Programs\"
move "%userprofile%\AppData\Roaming\Microsoft\Windows\Start Menu\Programs\GURU Limited Edition" "C:\ProgramData\Microsoft\Windows\Start Menu\Programs\Guru Limited Edition"Oh, and fix the permissions on them, too:
cd "C:\Users\Public\Desktop\"That made it possible to run Dentrix as a standard user with UAC disabled. Now it was time to get around UAC. To do that, I followed the spirit of Ghack's guide on doing just that - I installed the Microsoft Application Compatibility Toolkit, then created Application Fixes enabled RunAsInvoker for each of Dentrix's client-centered applications, while explicitly avoiding the database rebuild utilities like _Rebuild or _Rebuild2. Namely:
icacls *.lnk /reset
cd "c:\ProgramData\Microsoft\Windows\Start Menu\Programs\"
icacls * /reset
- Appt.exe - Appointment List
- Apptbook.exe - Appointment Book
- Chart.exe - Patient Chart
- Document.Center.exe - Document Center
- Document.Convert.Daemon.exe - Document Convert Daemon
- Document.UnfiledUtility.exe
- Dtx.ThreeDDataLoader.exe
- DtxLink.exe
- DtxLinkNet.exe
- DtxRx.exe - Prescription Module Wrapper
- DXPort.exe
- Dxprint.exe - Dentrix Print Module
- DXWeb.exe
- Famfile.exe - Family File
- Journal.exe - Patient Journal
- LabTrack.exe
- Ledger.exe - Ledger
- Mailer.exe - Mail Merge Utility
- Office.exe - Office Manager
- Patpict.exe - Patient Picture
- PayerId.exe
- Perio.exe - Perio Module
- PEXI.exe
- Presenter.exe - Dentrix Presenter
- query.exe - Query engine
- Questionnaire.exe - Questionnaire engine
- QuickLabels.exe - Quick Labels
- RA.exe
- SearchPayments.exe
- Snapshot.exe
- TimeClock.exe - Time Clock
- Totscr.exe
- Tpman.exe
- Trintf.exe
- TxPlanner.exe
- Wizard.exe
sdbinst "\\server\path\to\Dentrix\install\dentrix-fix.sdb"
Note that I largely aimed with a shotgun instead of a scalpel - I basically whitelisted almost every single executable in the Dentrix folder I could find that I knew wasn't a database utility and wasn't something that already ran without UAC whitelisting (e.g. AppLauncher). I also excluded eSync's executables since we don't use eSync in our lab. Also note that, since this was a classroom environment, I didn't have to deal with integrating this with Dexis, Dentrix Image, SUNI, or the other, similarly broken imaging solutions that are used in the dental field - that said, the same solution might work. I'll further note that, at least in my case, data integrity is not a high priority; since this is for a lab environment, it just needs to work well enough to get the point across, not remain stable through several Dentrix upgrades. That last point is important since the Microsoft Application Compatibility Toolkit calculates checksums for each executable you add to your database - if Dentrix upgrades a particular executable, you'll need to re-whitelist it for it to work.
The result? A Dentrix installation that let me, as a standard user, load up every Dentrix module I tried and make changes to patient records without a single UAC prompt.
If anybody is actually brave enough to try this in the field, let me know - I'm genuinely curious.
1. Note that, for the purposes of my lab, we're instructing using Dentrix G4. Dentrix G5 is theoretically 64-bit native, so it might install in C:\Program Files on 64-bit systems.
Thank you so much for taking the time to write this up.
ReplyDeleteReading this today gives me some trepidation, but also some hope and useful tips, since I'm currently tasked with a hardware refresh at a 5 user practice, moving from server 2003 / and XP workstations, to Server 2008 where the server will run AD, DNS, DHCP, and Dentrix.
ReplyDeleteThis is my first time with Dentri, and my DC is up and Dentrix is installed, the workstations joined, and Dentrix installed on those.. as admin.
Since my build out isn't at their office, I'm feeling my way along, and I have yet to log on as a domain user to see if the issues you've well documented are going to cause rapid hair loss.
What you've provided here looks like gold to me, so thanks for taking the time to share your experience!
I think this is an informative post and it is very useful and knowledgeable. therefore, I would like to thank you for the efforts you have made in writing this article. everydaylocksmiths.com
ReplyDeleteWhat about Windows 10? eSync having issues with UAC
ReplyDelete