Setting connection string with username and password in ASP.Core MVC

Question

I am working on my first ASP.NET Core MVC application.What is the right way to specify the connection string in a ASP.NET Core MVC application with a sql server backend requiring sql authentication?

ArgumentException: Keyword not supported: 'userid'.\

Below is my appsettings.json file. When I run the application, it throws an error.

{
  "ApplicationInsights": {
    "InstrumentationKey": ""
  },
  "ConnectionStrings": {
      "DefaultConnection": "Server=myserver;Database=mydatabase;userid=id;password=mypwd"
  },
    "Logging": {
      "IncludeScopes": false,
      "LogLevel": {
        "Default": "Debug",
        "System": "Information",
        "Microsoft": "Information"
      }
    }
  }

Mauricio Gracia Gutierrez · Accepted Answer · 2023-07-23 21:41:22Z

105

User Id is the correct way, with space in the middle

Server=myServerAddress;Database=myDataBase;User Id=myUsername; Password=myPassword;

https://www.connectionstrings.com/sql-server/

edited Jul 23, 2023 at 21:41

Mauricio Gracia Gutierrez

11k7 gold badges81 silver badges115 bronze badges

answered Jan 12, 2017 at 23:22

Jeremy Cook

22.4k11 gold badges74 silver badges78 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Rik Sportel · Accepted Answer · 2018-10-09 12:37:34Z

51

That's because the correct keyword is User Id, as shown in the following example:

"ConnectionStrings": {
    "DefaultConnection": "Server=myServerAddress;Database=myDataBase;User Id=myUsername;password=myPassword;Trusted_Connection=False;MultipleActiveResultSets=true;"
  }

edited Oct 9, 2018 at 12:37

Rik Sportel

2,6781 gold badge17 silver badges26 bronze badges

answered Oct 9, 2018 at 11:43

Majid joghataey

1,5472 gold badges17 silver badges30 bronze badges

Comments

Dev · Accepted Answer · 2022-11-16 07:17:48Z

5

Please try this followingcode one: with latest Visual Studio 2022 it works

"ConnectionStrings": "Server=ServerAddress;Database=DatabaseName;User Id=User;password=Password;Trusted_Connection=SSPI;Encrypt=false;TrustServerCertificate=true;MultipleActiveResultSets=true;"

answered Nov 16, 2022 at 7:17

Dev

1,83017 silver badges36 bronze badges

Comments

Mickaël Derriey · Accepted Answer · 2017-01-12 23:22:52Z

4

Can you try User ID instead of userid?

Note the main difference is in the space between user and id, the case doesn't matter

answered Jan 12, 2017 at 23:22

Mickaël Derriey

13.8k1 gold badge56 silver badges60 bronze badges

Comments

Miguel Linares · Accepted Answer · 2020-08-12 16:54:23Z

2

Try this:

"ConnectionStrings": {
    "MvcMovieContext": "Server=localhost\\NOMINSTANCE;Database=NomBD;Trusted_Connection=True;MultipleActiveResultSets=true;User ID=sa;Password=password1;Integrated Security=False"
}

answered Aug 12, 2020 at 16:54

Miguel Linares

291 bronze badge

Comments

RainyTears · Accepted Answer · 2022-12-06 15:53:39Z

2

Please write bellow code in dbcontext file

 protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
        {
            if (!optionsBuilder.IsConfigured)
            {
                optionsBuilder.UseSqlServer(
                    @"Server =.; Database = MyDb; User id=uid; Password=pwd; Trusted_Connection = True; MultipleActiveResultSets = true"
                );
            }
        }

answered Dec 6, 2022 at 15:53

RainyTears

1991 silver badge5 bronze badges

Comments

alexander.polomodov · Accepted Answer · 2017-10-13 10:07:22Z

-3

By setting Integrated security = false in your connection string in web.config file then this error will be solved

edited Oct 13, 2017 at 10:07

alexander.polomodov

5,54414 gold badges44 silver badges48 bronze badges

answered Oct 13, 2017 at 9:36

Vinod kumar

332 bronze badges

1 Comment

JJ Ward Apr 26 at 20:55

No, the issue was that the connection string attribute key is "User Id" (with a space), not "UserId"

Collectives™ on Stack Overflow

Setting connection string with username and password in ASP.Core MVC

7 Answers 7

Comments

Comments

Comments

Comments

Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

7 Answers 7

Comments

Comments

Comments

Comments

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related