asked on

Server 2008 R2 DC and SQL 2005 Express

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.

Thanks

Jim Poole

ASKER

Practice-SQL-10-1-14-9-51am.PNG
File-Cabinet-10-1-14-3-15pm.PNG

Seth Simmons

if that is the only DC then you don't want to demote unless you build another one first then transfer everything

remove sql first before doing that but definitely get another system running as a DC; demoting it as-is will delete the domain and all user and computer accounts

Jim Poole

ASKER

Thanks Seth,

I agree but I was looking at holding off on purchasing another system just yet. That being said, is it still OK to first remove sql, demote the DC, recreate all users and printers (I know - a little time consuming), then reinstall SQL and the associated sql software?
I would prefer to purchase a separate system for the SQL software and just move it to that system.

Thanks

ASKER CERTIFIED SOLUTION

Seth Simmons

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Jim Poole

ASKER

Thank You for your quick responses. I talked it over with the accounting software company (Thomson Reuters) and, like you, they agree to purchase a new server to run the SQL required programs (not as a DC) and eventually leave the original server as the DC. Once the DC needs replacing (in a few years) then purchase a lower end server to do just that - DC.

Thanks Again Seth

Jim