Locating what version of SQL Server Acctivate is using.

Some users may have multiple versions of Microsoft SQL Server installed on their server computer, making it somewhat difficult to determine which version of SQL Server Acctivate is using. Acctivate allows users to easily find the version of Microsoft SQL Server Acctivate is utilizing.

This article covers:

• Locating the SQL Server Version in Acctivate

• Interpreting the Microsoft SQL Version

Locating the SQL Server Version in Acctivate

1. Log into Acctivate on any workstation computer.
2. In Acctivate, expand the Help menu, then select View Usage Metrics.
3. Scroll to the bottom of the Usage Metrics window until you reach the row with SQL in the Group column.
4. The Value column will display the Microsoft SQL Server information. Hover over the Value to display the entire version of Microsoft SQL Server.

On mouse hover:

Interpreting the Microsoft SQL Version

• Version - The first line indicates the version of SQL Server. In this example, it's Microsoft SQL Server 2014. The number following, 12.0.2000.8 is the build number. There may be different service packs, or builds, for the version.
• Architecture - Some versions of SQL Server are available as 32-bit and 64-bit while currently supported versions are only available in 64-bit.Following the build number, you will see either X86 or X64 in parenthesis
  
  • X86 indicates a 32-bit instance
  • X64 indicates a 64-bit instance
• Edition - Each SQL version is available in different editions. Acctivate distributes the Express edition, which is the free Edition. Microsoft SQL Standard Edition is also common, however it requires a license. In the screenshot example, the line "Express Edition" identifies the edition.