How to build a C# application and installer that uses SQL Server LocalDB to be accesible to all users on same PC without prompt by UAC?

Question

My app runs normally under Windows Administrator account there is no problem.

Except that when run under Guest Account, it has to be run as administrator for the DB to be accessible, or else I'll get an error

Failed to update .mdf database because the database is read-only

So UAC always pops up if Guest account wants the app to work.

The purpose of the app is for everyone, but whenever a guest user runs it, an admin has to run over and enter his password into UAC -- that is going to wear out the patience of everyone, don't you think? What I need (and in my opinion, logical) is for it to run as admin automatically once installed (admin installs it anyway). Or at least, an admin need enter password on UAC only once, not every time.

Is this really not easily available?

question from:https://stackoverflow.com/questions/66060868/how-to-build-a-c-sharp-application-and-installer-that-uses-sql-server-localdb-to

Answer 1

Waitting for answers