none
connect string reading password from config file or database RRS feed

  • Question

  • I have a connect string to connect to MS SQL server which using UserID and Password.

    Because we need change password once a while that I need update my source code and rebuild and publish every time I change password. I just wanted to know if it is password to read from config file or any text file or database to update the connection string

    The connection string like following

    <add name="MyApp.My.MySettings.MyAppConnectionString" connectionString="Data Source=MyServer;Initial Catalog=MyDatabase;User ID=MyUser;Password=MyPassword"
                providerName="System.Data.SqlClient" /> 

    I use Visual Studio 2012 Express Desktop and .NetFramwork 4.0

    Your help and information is great appreciated,

    Regards,

    Sourises,

    Friday, October 27, 2017 1:36 PM

Answers

  • Hi Sourise,

    Thank you for your confirmation.

    Please redirect to this appropriate forum: https://forums.asp.net/ and start a new thread, you will get a better support for your questions, thank you for your understanding.

    If you have any other issues about VS IDE in the future, please feel free to let us know.

    Have a nice day.

    Best regards,

    Sara


    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

    • Marked as answer by sourises Tuesday, January 16, 2018 7:01 PM
    Thursday, November 2, 2017 6:04 AM

All replies

  • Hi Sourises,

    Welcome to the MSDN forum.

    Refer to your description, your issue is a development issue. What’s your project type like ASP.NET or WPF, Windows Forms or others? Since our forum is to discuss the VS IDE and we need to help you find the appropriate forum, then you will get a better support, thank you for your understanding.

    Meanwhile, I found a doc: Connection Strings and Configuration Files and hope it helpful for your question :)

    Best regards,

    Sara


    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


    Monday, October 30, 2017 6:14 AM
  • ASP.Net

    Regards,

    Sourise,

    Wednesday, November 1, 2017 7:48 PM
  • Hi Sourise,

    Thank you for your confirmation.

    Please redirect to this appropriate forum: https://forums.asp.net/ and start a new thread, you will get a better support for your questions, thank you for your understanding.

    If you have any other issues about VS IDE in the future, please feel free to let us know.

    Have a nice day.

    Best regards,

    Sara


    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

    • Marked as answer by sourises Tuesday, January 16, 2018 7:01 PM
    Thursday, November 2, 2017 6:04 AM