Solved

logon error message

Posted on 2011-09-19
6
127 Views
Last Modified: 2012-12-16
windows 2003 server (NOT a DC) it's a SQL box.  When logging in using domain creditials get the following message:

"Windows cannot connect to the domain either because the domain controller is down or otherwise unavailable, or because your computer account was not found. Please try again later. If this message continues to appear contact your System Administrator for assistance."

I goto log in with Domain credentials, I get the error message.  Can log in with local creditials and accessed shared resources from remote systems.
0
Comment
Question by:smiffman
  • 2
  • 2
6 Comments
 
LVL 6

Expert Comment

by:JRaster
ID: 36563890
Is the server still show up under the domain controller active directory users and computers?

If you can ping the domain controller from your sql server, and the domain controller can ping your SQL server, then I would do this:
Make sure you have the local administrator username and password.
Change the SQL server back to a workgroup.
Reboot.
On the domain controller, delete the computer from active directory users and computers.
On the SQL server, rejoin the domain under the same name as before.  

0
 

Author Comment

by:smiffman
ID: 36563963
Is there any potential for corruption or inability to reconnect to the domain after taking it out?
0
 
LVL 6

Expert Comment

by:JRaster
ID: 36563997
I think you already have corruption, thats why your having issues.  

One the domain controllers, can you browse to the sql machine doing this in the run line:
\\sqlservername\c$

?
0
 

Accepted Solution

by:
smiffman earned 0 total points
ID: 36564653
The person demoted the DC and promoted it which seem to solve the issue.  I appreciate your time and information, will keep it for next time.

Thank you.
0
 
LVL 26

Expert Comment

by:Pber
ID: 38695545
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0

Join & Write a Comment

JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
Restoring deleted objects in Active Directory has been a standard feature in Active Directory for many years, yet some admins may not know what is available.
Viewers will learn how the fundamental information of how to create a table.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now