C
C#2mo ago
Moonlit

✅ Website doesn't trust SSL Provider (MSSQL Database)

So I get this error
Microsoft.Data.SqlClient.SqlException (0x80131904): A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted.)
Microsoft.Data.SqlClient.SqlException (0x80131904): A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted.)
But to be quite honest... I'm new to MSSQL and I don't understand where it's getting the SSL from or how I get my website to trust it? They are both hosted from the same machine
2 Replies
Jimmacle
Jimmacle2mo ago
if they're on the same machine just add Trust Server Certificate=True; to your connection string it's not a security issue in that configuration
Moonlit
MoonlitOP2mo ago
Much appreciated 🙂 Thanks
Want results from more Discord servers?
Add your server