Microsoft SQL Server Password

Elastic Stack Elastic Agent
,
1

Hello,

We are trying to utilize the Microsoft SQL Server integration in Fleet but having an issue when specifying the password which contains special characters such as }, ?, @ etc. but getting a parsing error:

could not open connection: testing connection: parse "sqlserver://user:12}3?456/789@23123@localhost:14331": invalid port ":12}3" after host

when we try letters only password we are getting:

could not open connection: testing connection: Login error: mssql: Login failed for user 'user'.

which is expected.

How do we escape the special characters in passwords? We've tried double quotes but it makes no difference.

When using the same password with JDBC plugin in Logstash it works fine.

Thank you

1 Like
2

You can use URL encoding for passing passwords with special characters.

3

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.