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.

Jim PooleConsultantAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jim PooleConsultantAuthor Commented:
Seth SimmonsSr. Systems AdministratorCommented:
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 PooleConsultantAuthor Commented:
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.

Seth SimmonsSr. Systems AdministratorCommented:
if you demote that and delete the domain, creating new user accounts will cause the users to have a new profile since the account SID will be different.  you would also need to join the computers again so it would be very much time consumed.

getting another system and moving sql there is fine though the current box with 32gb is way overkill for a domain controller.  4gb should be plenty just for that.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Jim PooleConsultantAuthor Commented:
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

It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Windows Server 2008

From novice to tech pro — start learning today.