Active Directory How-To pages

Active Directory Auditing Tool

Audit your Windows servers, file clusters, Netapp filers, failover clusters to protect your data
and maintain file integrity.

Get Your Free Trial Free, fully functional 30-day trial
Active Directory Auditing Tool

The Who, Where and When information is very important for an administrator to have complete knowledge of all activities that occur on their Active Directory. This helps them identify any desired / undesired activity happening. ADAudit Plus assists an administrator with this information in the form of reports. In real-time, ensure critical resources in the network like the Domain Controllers are audited, monitored and reported with the entire information on AD objects - Users, Groups, GPO, Computer, OU, DNS, AD Schema and Configuration changes with 200+ detailed event specific GUI reports and email alerts.

Audit your Windows servers, file clusters, Netapp filers, failover clusters to protect your data
and maintain file integrity.

Account Management » Active Directory How-To pages

How to test SQL server connection?

To enter Transact-SQL statements, system procedures, and script files at the command prompt, use the sqlcmd Utility. You can enter it in Query Editor in SQLCMD mode, in a Windows script file or in an operating system (Cmd.exe) job.

Start the sqlcmd utility and connect to a default instance of SQL Server

  1. Go to the command prompt window (Run→cmd)
  2. Enter sqlcmd and press enter.
  3. You now have a trusted connection to the default instance of SQL Server that is running on your computer.
    1→ is the sqlcmd prompt that specifies the line number. Each time you press ENTER, the number increases by one.
  4. To end the sqlcmd session, type EXIT at the sqlcmd prompt.

Start the sqlcmd utility and connect to a named instance of SQL Server

  1. Open a Command Prompt window, and type :
    sqlcmd -SmyServer\instanceName.
  2. Replace myServer\instanceName with the name of the computer and the instance of SQL Server that you want to connect to. Press ENTER.
  3. The sqlcmd prompt (1→) indicates that you are connected to the specified instance of SQL Server.>