[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

[LZiHaN]

hi, is this task still available? I’d like to give it a try, assign please

[atoulme]

@LZiHaN all yours!

[LZiHaN]

Hi @atoulme , it looks like multiple SQL Server instances on the same host can get mixed up.
Do other receivers like

• receiver/mysqlreceiver
• receiver/oracledbreceiver
• receiver/postgresqlreceiver
• receiver/rabbitmqreceiver
• receiver/haproxyreceiver
• receiver/saphanareceiver
• ...

have the same issue? Should they be updated too?

[atoulme]

I don’t know. I don’t think that’s missing for most.