What version of Powershell is required for SQL Server discovery?

The requirement for using PowerShell for SQL Server discovery in ServiceNow Discovery is rooted in the specific features and capabilities that each version of PowerShell offers. For SQL Server discovery, PowerShell version 2 is necessary because it includes the basic cmdlets and functions needed to interact with the SQL Server environment and perform the required tasks, such as retrieving system information and accessing databases.

PowerShell version 2 introduced significant improvements over its predecessors, providing useful features for managing both SQL Server instances and Windows environments. In the context of ServiceNow Discovery, having the appropriate version is crucial, as it ensures compatibility with the scripts and commands used to facilitate the discovery process.

The other versions do not apply to this specific context as they may introduce features or functionalities not relevant or necessary for SQL Server discovery within the fixed parameters set by ServiceNow. Therefore, understanding the importance of PowerShell version 2 in relation to SQL Server discovery provides clarity on why it is the correct answer for this question.