SQL not trusted
m ((username removed) (log details removed): Moving to Documentation namespace) |
Hans Karlsen (talk | contribs) No edit summary |
||
(4 intermediate revisions by 2 users not shown) | |||
Line 1: | Line 1: | ||
<message>Write the content here to display this box</message> | |||
A connection was successfully established with the server, but an error occurred during the login process. | A connection was successfully established with the server, but an error occurred during the login process. | ||
Server=xxxx;Database=xxxx;Trusted_Connection=true; | Server=xxxx;Database=xxxx;Trusted_Connection=true; | ||
Add the TrustServerCertificate=True | Add the TrustServerCertificate=True | ||
Server=xxxx;Database=xxxx;Trusted_Connection=true;TrustServerCertificate=True | Server=xxxx;Database=xxxx;Trusted_Connection=true;TrustServerCertificate=True | ||
(please note that Trusted_Connection=true in the example is a part of user/login settings for MS integrated security. Do not add that if you use SQL server login) | |||
Other things that may come into play: | Other things that may come into play: | ||
Integrated Security=True; Encrypt=True; TrustServerCertificate=True; | Integrated Security=True; Encrypt=True; TrustServerCertificate=True; | ||
SQL connection 4.x has changed its default setting: '''Encrypt=True''' from '''Encrypt=False''' | SQL connection 4.x has changed its default setting: '''Encrypt=True''' from '''Encrypt=False''' | ||
This format was tested 2024 and should work for most development scenarios: | |||
Server=<ServerName>;Database=<dbName>;Integrated Security=True;TrustServerCertificate=True | |||
For search: The certificate chain was issued by an authority that is not trusted | For search: The certificate chain was issued by an authority that is not trusted | ||
[[Category:MDriven Server]] | [[Category:MDriven Server]] | ||
{{Edited|July|12|2024}} |
Latest revision as of 15:30, 2 September 2024
A connection was successfully established with the server, but an error occurred during the login process.
Server=xxxx;Database=xxxx;Trusted_Connection=true;
Add the TrustServerCertificate=True
Server=xxxx;Database=xxxx;Trusted_Connection=true;TrustServerCertificate=True
(please note that Trusted_Connection=true in the example is a part of user/login settings for MS integrated security. Do not add that if you use SQL server login)
Other things that may come into play:
Integrated Security=True; Encrypt=True; TrustServerCertificate=True;
SQL connection 4.x has changed its default setting: Encrypt=True from Encrypt=False
This format was tested 2024 and should work for most development scenarios:
Server=<ServerName>;Database=<dbName>;Integrated Security=True;TrustServerCertificate=True
For search: The certificate chain was issued by an authority that is not trusted
This page was edited 18 days ago on 09/02/2024. What links here