We have a SQL database for our office where we store clear-text details in a memo field in Microsoft's SQL. We provide customers with a unique credential and password that permits them to log into our suuuuuper basic portal (web-page) so they can see the notes. Once in place, the local staff maintains the credentials for the customers without technical knowledge by accessing the credentials Excel spreadsheet.
The existing solution was coded and compiled to a specific SQL DB and the vendor no longer exists. We want to replace with a modern SQL DB and MS SQL for a ReadOnly retrieval that we can display in HTML in the 'static' secured by credential "portal", thereby disallowing the exposure of the entire confidential database