I have a server running Thompson Reuters Accounting software (used to be Creative Solutions) - Practice CS, File Cabinet, Ultra Tax etc. File Cabinet is SQL based and soon another one of their products is moving toward SQL.
I get random errors on workstations which cause the application to close - some errors are SQL related regarding a transport-level error has occurred when receiving results from the server etc.
I have a GB network with one server (2011 Dell with dual xeon processors, 32 GB RAM and 1 TB of drive space).
I've tried a variety of settings offered by TR but the randomness still appears.
I understand that you should not run SQL on a DC and wondered if these random errors are the result of MS continued patches and updates - forcing the issue of not running SQL on a DC.
That being said:
Can I uninstall SQL Express, demote the server to a basic server, reinstall SQL Express/File Cabinet - and other SQL related accounting software as they become available?
If so - what will happen to the 30 plus PC's logging into a DC that will no longer be there.