New answers tagged windows
In a .NET Environment Lucene .NET MSSQL also has text search Full-Text Search
I would not use a database for this, but rather a full-text indexing engine. While database engines may include full-text indexing capabilities, they are generally less efficient than dedicated engines. This is also true for NoSQL databases. You may want to look at the following projects: Elastic Search (based on Lucene) Apache Solr (based on Lucene) ...
The best approach is to store these in an encrypted section of your config file, the key to encrypt this should be stored in Windows protected storage for the user it runs as (ie no-one else, not even another admin can then access it). This assumes you need to store and use these credentials to pass on to access the DB, if you are simply running the service ...
Top 50 recent answers are included