sqlserver' adapter issue, for new fluentd service. on windows server 2022. (fluent-package-5.1.0-x64.msi 24.74M)

[ext-hussainsyed]

@pjjw @fesplugas @pjjw
we are facing this issue since our os upgarde from windows server 2016 to windows server 2022,
first the td-agent service disappeared, then we installed fluentd latest version which imported everything from old td-agent services,
after starting the service, we started facing this issue,
err: unexpected error error_class=ActiveRecord::AdapterNotFound error="Database configuration specifies nonexistent
'sqlserver' adapter.
Available adapters are: mysql2, postgresql, sqlite3, sqlserver, trilogy. Ensure that the adapter is spelled correctly in config/database.yml and that you've added the necessary adapter gem to your Gemfile and that it is at its latest version. If it is up to date, the adapter may need to be modified."
now to resolve this steps done:
budle install,
update the requited gem file with specifc version of adapter,
C:\opt\fluent\bin>fluent-gem install activerecord-sqlserver-adapter
Successfully installed activerecord-sqlserver-adapter-7.2.1
Parsing documentation for activerecord-sqlserver-adapter-7.2.1
Done installing documentation for activerecord-sqlserver-adapter after 0 seconds
1 gem installed

adapter is there,
abbrev (default: 0.1.1)
activemodel (7.2.1, 6.1.7.8)
activerecord (7.2.1)
activerecord-import (1.8.1)
activerecord-sqlserver-adapter (7.2.1)
activesupport (7.2.1, 6.1.7.8)

still no luck, how can we resolve this.
Br, HS