Closed. This question is not reproducible or was caused by typos . It is not currently accepting answers.

This question was caused by a typo or a problem that can no longer be reproduced. While similar questions may be on-topic here, this one was resolved in a way less likely to help future readers.

Closed 12 days ago.
Improve this question

I have a C# application in which I use EntityFramework. In my App.config file I got a Connection String, which contains server, database, User ID password and so forth. But when I run my application it ignores the User ID and uses Integrated Security, which I have set to False in the connectionstring.

So why is it that my application keeps using Integrated security? I can change User ID to anything and the application stil uses integrated security.

Connection string:

<add name="dbConString" connectionString="Server=dbServerName;Database=databaseName;User ID=sqlUserName; Password=sqlUserPassword; Integrated Security=false; TrustServerCertificate=True;Integrated Security=SSPI;" providerName="System.Data.SqlClient" />

Code from my db context class:

protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
{
    base.OnConfiguring(optionsBuilder);
    if (!optionsBuilder.IsConfigured)
    {
        optionsBuilder.UseSqlServer(ConfigurationManager.ConnectionStrings["dbConString"].ToString());
    }
}