SQL not trusted
    No edit summary
    (Updated Edited template to July 12, 2025.)
     
    (12 intermediate revisions by 4 users not shown)
    Line 1: Line 1:
    A connection was successfully established with the server, but then an error occurred during the login process.  
    <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.  
    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)


    Server=xxxx;Database=xxxx;Trusted_Connection=true;
    Other things that may come into play:
     
    Integrated Security=True; Encrypt=True; TrustServerCertificate=True;
    Add the TrustServerCertificate=True
    SQL connection 4.x has changed its default setting: '''Encrypt=True''' from '''Encrypt=False'''


    Server=xxxx;Database=xxxx;Trusted_Connection=true;TrustServerCertificate=True
    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
    [[Category:MDriven Server]]
    {{Edited|July|12|2025}}

    Latest revision as of 06:01, 20 January 2025

    This page was created by Hans.karlsen@mdriven.net on 2022-03-30. Last edited by Edgar on 2025-01-20.

    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

    Retrieved from "https://learn.mdriven.net/index.php?title=Documentation:SQL_not_trusted&oldid=25426"

    © MDRIVEN . All Rights Reserved

    API Docs
    MDriven World | Portal | Blog | YouTube | StackOverflow | Facebook

    © MDRIVEN . All Rights Reserved