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 check SQL server version name using command prompt?

Step 1 -Open a command prompt window on the machine in which SQL is installed.
Go to Start → Run, type cmd, and hit enter to open the command prompt.

Step 2 -SQLCMD -S servername\instancename (where servernameb= the name of your server, and instancename is the name of the SQL instance).The prompt will change to 1→.

Step 3 -select @@version

Step 4 -At the 2→ prompt type go and hit enter.
This will return the SQL version that is running on your server. If you have multiple instances repeat the process for each instance. The servername mentioned above will be the name of the machine SQL is installed on.

If you are unsure of your instance name do the following:

Step 1 -Open a command prompt window as described above.

Step 2 -services.msc.

Step 3 -Locate the entries beginning with SQL.
There will be an entry for each instance called SQL Server (instancename). The instance name appears within the parentheses.

Explore Active Directory auditing and reporting with ADAudit Plus.

  •  
  •  
  •  
  • By clicking 'Schedule a personalized demo' you agree to processing of personal data according to the Privacy Policy.
Account Management Auditing
Active Directory Auditing
Windows Server Auditing