Subscribe to RSS feed  Follow @jackvamvas - Twitter

*Use the Comments section for questions Links


SQL Server DBA Jobs

How to list Domain Controllers in a Domain with nltest

20 July,2016 by Tom Collins

Question:How can I list the Domain Controllers for a domain?  There have been some Domain Controller issues and trusted authority login failures - and I'm using Troubleshooting Error: 18452, Severity: 14, State: 1 (SQL Server DBA).

 The Domain Controller team would like to see a list of Domain Controllers available from a server.I’m using Windows 2008 R2 Enterprise Server

Answer: The nltest command line tool  is useful for Domain Controller information. It arrives as part of Windows 2008 . The tool allows the operator to complete a number of tests such as trust status and domain controller replication status. Nltest will also allow you to list Domain Controllers for a domain.

This is an example to list all the available domain controllers within a domain. In the example I’m calling the domain ‘MYDOMAIN’. Replace with your domain name



Read More

SQL Server – How to Ask for support and troubleshoot problems

SQL Server - SSPI handshake failed with error code 0x80090304 ...

Author: Tom Collins (


Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Your comment could not be posted. Error type:
Your comment has been posted. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.


Post a comment on How to list Domain Controllers in a Domain with nltest | SQL Server Performance Tuning | SQL Server DBA:Everything | FAQ | Contact|Copyright & Disclaimer