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?