for Otel Collector, `receiver/sqlserver`:
Pls make sure to Use MSSQL V: 2022, I was using MSSQL Server Version 2019.
Pls Use SQLSERVER, instead of SQLEXPRESS Edition.
Pls provide MSSQL User Privileges as below:
GRANT VIEW SERVER PERFORMANCE STATE TO <USERNAME>
For reference check this Github Issue: https://github.com/open-telemetry/opentelemetry-collector-contrib/issues/40937