I'm making a medium sized application to be distributed privately to several Churches. It connects to an Azure database but it does not have any server managing the information (apart from the SQL server). The application is highly dependent on the information stored in the databases as very little data is saved client side (just the user's personal settings, product key).
But I have a dilemma. The information stored on the server is fairly confidential as it saves individuals' private information (such as demographics, personal and identifiable information), and I want to be able to connect the application to the database without the connection string being easily accessible, especially allowing all copies of the application to have raw and unrestricted access to the database. What's the best way to accomplish this? We currently don't have the resources to run a local server 24/7.
Are there any online solutions out there?