SQL Server wont connect after DC demotion

I demoted a 2008r2 domain controller.  Now I cannot log into SQL server.  SQL was installed on this DC because at the time because this was there only server.  Made 2 Manage software runs on this server and the database for this software is installed on SQL.  I didn't realize that this would break SQL.  Anyone know any fix for this?  I won't be back to work until Tuesday to address this, but I an trying to research this now.  Hopefully I will have a fix for this by Tuesday to get our M2M software backup and running.
Michael McGuireSystems AdministratorAsked:
Who is Participating?
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.

hilltopCommented:
I assume you can connect, but access is denied for the now nonexistent AD user.

You can start SQL server in single user mode, and add accounts or enable mixed mode authentication.
https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/start-sql-server-in-single-user-mode?view=sql-server-2017
Starting SQL Server in single-user mode enables any member of the computer's local Administrators group to connect to the instance of SQL Server as a member of the sysadmin fixed server role.

If all else fails backup your .mdf and .ldf files and uninstall then reinstall SQL server.
Michael McGuireSystems AdministratorAuthor Commented:
Sorry I guess I should mention that this is SQL Server 2008 R2.  I actually have access to the SQL now if anyone is around and knows a solution.

Hiltop, the single user mode instructions on here say they are for 2017 and above.
Michael McGuireSystems AdministratorAuthor Commented:
So I have SQL fixed.  Hilltop you were right about the nonexistent user.  I was unable to get the single user mode to run, because the SQL Service would not run.  I did a repair of SQL Server and it added back the SQL Accounts that we lost because of the DC demotion.   I the went into  Local Security Policy and add the Local Admin user and group to the log in service.  I then went into The SQL Configuration Manager and restarted the SQL Service and Agent.  I was able to logon to SQL Studio Manager now and access the databases.
Michael McGuireSystems AdministratorAuthor Commented:
See above post

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
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
Software

From novice to tech pro — start learning today.