Database connection unsuccessful: Failed to connect - What certificate is it using?

where do earliest and latest go

that field is a js expression field (blue vertical bar) so the backticks are necessary

and earliest and latest come from the values i put when running the collector, right?

``SELECT * FROM "database"."dbo"."table" where <fieldname> > ${earliest} and <fieldname> < ${latest}``

yes

cool thanks

i am guessing all our complex MS SQL queries (lots of joins and such) is not going to work since the docs mention SELECT is all that is supported?

well, a JOIN is part of a SELECT statement, JOINs aren't their own. The intent there in the docs is to not try using a DELETE or INSERT.

ah ok

i will try out one of our complex queries in a few

yeah the crazy complex one we have def fails. select, trim, case, if then else, etc

joins

i may have missed something in the query, testing it again

Hi <@UJYBKAR2Q&gt;, Ryan from Product here, I'm catching up on this string and interested to hear about your use case. Would you have some time to chat to Tomer and I? We are interested to discuss how you are trying to connect to your SQL server instance

yeah I wont have time to get into the weeds today but maybe setup some time next week?

Great, I'll ping you individually

<@U012ZP93EER&gt; My testing has been with Azure, which worked as expected. Here is the ADO formatADO Format:```Server=tcp:<server>,1433;Initial Catalog=<database>;Persist Security Info=False;User ID=<username>;Password={your_password};Encrypt=True;TrustServerCertificate=False;Authentication="Active Directory Password";```