SQL broken after promoted to DC

Hi There,

I was to visit one of our branch offices today to implement an AD infrastructure in there small office. They have 10 users and 1 server and the whole network (inc the server) was setup in a workgroup rather than a domain.

The server is a 2008 R2 Foundation server and it was setup as a workgroup (not a member server of a domain).

Once I completed the DCPROMO to their newly created domain cotroller and migrated there local profiles to the domain they then told me that SQL databse is also running on the server which was the DB for one of their applications which now dont work! i didnt know this till after they told me.

I cant expand the databases in SQL Server 2008 R2 management studio i get access denied.

the clients are also getting bind errors and authentication issues not allowing them to connect to the application.

Please can anyone help to advise how we can resolve this issue now the local SQL database is not working after the server has been promoted to a DC?


LVL 11
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.

not totally clear why...

can you post actual error messages...

however could it be that the userid now have new SID values as a result of your change...

in which case there userid/logins will need to be re-added/enabled within the sql server instances/databases....

BertlingAuthor Commented:
Looks like the "new" AD users that were previously local users on the newly promoted DC had the same SID so I was able to login as a user with permission on the database and replace the owner objects and create new permissions for the relevant Active Directory objects. All is working again.

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
BertlingAuthor Commented:
Solved it myself
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.