Sqlserver receiver should allow default instances on Windows

[MikkelPorse]

Component(s)

receiver/sqlserver

Is your feature request related to a problem? Please describe.

If you run a default installation of SQL Server (ie. no named instance) - you're limited to the non-performance counter version of the receiver

Describe the solution you'd like

I'd like to be able to specify only computer_name and not instance_name and have the receiver get performance counters from Windows

Describe alternatives you've considered

I could just use the performance counter receiver, but I'd need to specify which by hand - a ready-built sqlserver receiver is more handy :)

Additional context

related to this PR #31915

[github-actions]

Pinging code owners:

• receiver/sqlserver: @djaglowski @StefanKurek

See Adding Labels via Comments if you do not have permissions to add labels yourself.

[github-actions]

This issue has been inactive for 60 days. It will be closed in 60 days if there is no activity. To ping code owners by adding a component label, see Adding Labels via Comments, or if you are unsure of which component this issue relates to, please ping @open-telemetry/collector-contrib-triagers. If this issue is still relevant, please ping the code owners or leave a comment explaining why it is still relevant. Otherwise, please close it.

Pinging code owners:

• receiver/sqlserver: @StefanKurek

See Adding Labels via Comments if you do not have permissions to add labels yourself.