Get Cluster size for all disks and volumes on a Windows machine using PowerShell and WMI Get-WmiObject -Query “SELECT Label, Blocksize, Name FROM Win32_Volume WHERE FileSystem=’NTFS’” -ComputerName ‘.’ | Select-Object Label, Blocksize, Name See below an example of output:
Monthly Archives: July 2014
List the SQL connection authentication method. NTLM vs Kerberos
Run the following query to find out if the connections to SQL server are using NTLM or Kerberos:
SQL Server Configuration Manager – Cannot connect to WMI provider – Invalid class [0x80041010]
Error 1 Cannot connect to WMI provider. You do not have permission or the server is unreachable. Note that you can only manage SQL Server 2005 and later servers with SQL Server Configuration Manager. Invalid namespace [0x8004100e] Error 2 SQL Server Configuration Manager – Cannot connect to WMI provider – Invalid class [0x80041010] To work […]