none
How do you access data in a SQL Availability Group enabled database without putting a password in connection string? RRS feed

  • Question

  • Hi,

    How do you access data in a SQL Availability Group enabled database without putting a password in connection string?

    ?

    Thanks.

    Wednesday, December 4, 2019 5:01 PM

Answers

  • You need to add Integrated Security=true or Integrated Security=SSPI into your connection string in place of using username and password.
    • Marked as answer by xyz2012 Friday, December 6, 2019 5:42 PM
    Wednesday, December 4, 2019 9:04 PM

All replies

  • You need to add Integrated Security=true or Integrated Security=SSPI into your connection string in place of using username and password.
    • Marked as answer by xyz2012 Friday, December 6, 2019 5:42 PM
    Wednesday, December 4, 2019 9:04 PM
  • Hi xyz2012,

    When clients connect to a SQL Server instance,no password required if use Windows authentication.

    But the clients and SQL Server need to be in same computer or in a domain.

    If the conditions are met,you could connect to databae without putting a password, like Israel Haylamicheal said,need to add Integrated Security=true or Integrated Security=SSPI into your connection string.

    Best regards,
    Cris


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Thursday, December 5, 2019 9:53 AM
  • Thanks!
    Friday, December 6, 2019 5:42 PM