[SQL Server] expose server.port

[atoulme]

Component(s)

receiver/sqlserver

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

Similar to #32810 we find that multiple SQL server instances running on the same host will be commingled.

Describe the solution you'd like

the SQL server receiver should expose a server.port attribute similar to what the mongodbreceiver is doing.

Describe alternatives you've considered

No response

Additional context

No response

[github-actions]

Pinging code owners:

• receiver/sqlserver: @djaglowski @StefanKurek

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

[atoulme]

The metadata.yaml would be enhanced with

  server.address:
    description: The address of the SQL server host.
    enabled: true
    type: string
  server.port:
    description: The port of the SQL server host.
    enabled: false
    type: int