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

I assume Cribl is not using the cert, but the database server is using a self signed cert on its side. Did you check that?

outside of Cribl

I dont think other connections are using a secure method to connect to the SQL server. I will have to do some more testing to be sure though.

Are you using a connection string in your database connection setting Cribl? Can you share that page?

That error is always due to a client encountering a server cert it doesn't trust. A client doesn't have to have its own cert in order to make an encrypted connection (eg your web browser doesn't need its own certificate to use https with any website). Having its own certificate only provides authentication for clients. We would need to see your connection string to troubleshoot further.

Are you using a hostname or an ip for the connection?

IP

I can post connection string

Just for a test, can you edit your hosts file in the event it isn't in DNS and give it a name that matches your cert host name?

obviously IP is different

You could try adding ;TrustServerCertificate=True

Thats obviously a dirty fix

so add a HOSTS entry for that IP, mapping it to name? yeah that line is worth a shot as well.So when creating the database collector, what is the proper format for the query? I pop in a normal SQL query and it does not like that

Same!

You're now in Microsoft country, I'm out

LOL

oh well, guess i will give up on database collectors.

<@U02MJ3E1B2P&gt; did you get windows auth working in your lab or was the conclusion that it's not yet supported ?

<@U02B3KG124C&gt; any guidance here?

Just checking for the obvious, did you add single quotes around your connection string?

I don't think it allows saving if they string is invalid.

the docs dont show that i need to do that

Yeah I just pulled it up :slightly_smiling_face:

Just made an assumption since we require that in so many places lol

ASSume :slightly_smiling_face: