• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 495
  • Last Modified:

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?

thanks,

mike
0
Bertling
Asked:
Bertling
  • 2
2 Solutions
 
LowfatspreadCommented:
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....

0
 
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.
0
 
BertlingAuthor Commented:
Solved it myself
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now