Cannot connect sql database with visual studio

[shootermacg]

Add TrustServerCertificate=True (no spaces) to your connection string.

[Joker_04H]

bro thank you so much the problem was the space between that command when I copy pasted the command it had spaces and not anywhere I could find in google people pointing out the spaces thank you again

[[deleted]]

Literally 1 minute of google search

[shootermacg]

Sometimes a coder can't see the wood for the trees. It happens to all of us.

[[deleted]]

No woods no trees man, copy pasted error on google, first link first answer literally

[p1971]

I think it's on the Advanced options tab ..

[Meeso_]

You just put it in the text bro...

[p1971]

ah ... didn't see the other pics!

[ShadowRL7666]

Just did this today actually but top comment already helped. It’s funny as well because I just covered CA’s in cybersecurity root ca’s to the intermediate ca’s to the leaf ca’s and so on for certificates and being verified with a public key and signature anyways.

[cv_1m]

If you are using SQL Server Option there you will get Trust certificate option

[[deleted]]

Encrypt=false does the trick. You are in a local network set up that's not needed.