Error when trying to update database in .NET Core

Question

I am trying to update a database in .NET Core using the command

dotnet ef database update

but I am getting the following error

Error Number:18456,State:1,Class:14
Login failed for user ''.

I can log in in my SQL Server with this User ID and password so I don´t think the problem is in my connection string

Context

   public class CommanderContext : DbContext
    {
        public CommanderContext(DbContextOptions<CommanderContext> opt) : base(opt)
        {

        }
        public DbSet<Command> Commands { get; set; }
    }
}

appsettings.cs

{
  "Logging": {
    "LogLevel": {
      "Default": "Information",
      "Microsoft": "Warning",
      "Microsoft.Hosting.Lifetime": "Information"
    }
  },
  "AllowedHosts": "*",
  "ConnectionStrings": {
    "CommanderConnection": "Server=localhost;Initial Catalog=CommanderDB,User ID=CommanderApi;Password=*****;"
  }
}

Startup.cs


        public void ConfigureServices(IServiceCollection services)
        {
            services.AddRazorPages();
            services.AddDbContext<CommanderContext>(opt => opt.UseSqlServer(Configuration.GetConnectionString("CommanderConnection")));
            services.AddControllers();
            services.AddScoped<ICommanderRepo, MockCommanderRepo>();


        }

I also leave a print of my SQL Server

Is this a new or an existing database? Are remote connections allowed? Did this user ID/password work when you first scaffolded the database, if you're using Code-First approach? — CoolBots
– CoolBots, Commented Oct 13, 2020 at 21:24
The SSMS screenshot is not helpful at all, as it only shows existence of the SQL Login, not the rights — CoolBots
– CoolBots, Commented Oct 13, 2020 at 21:27
The clue is in the error message Login failed for user and your statement "I don´t think the problem is in my connection string" - the update statement may not be seeing the connection string or the string has errors. — Peter Smith
– Peter Smith, Commented Oct 13, 2020 at 21:27

Glynn Hurrell · Accepted Answer · 2020-10-13 22:20:20Z

3

Your issue is that you've got a comma in the connection string just before User Id.

This needs to be a semicolon:

 "CommanderConnection": "Server=localhost;Initial Catalog=CommanderDB;User ID=CommanderApi;Password=*****;"

edited Oct 13, 2020 at 22:20

answered Oct 13, 2020 at 22:01

Glynn Hurrell

6526 silver badges11 bronze badges

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

Collectives™ on Stack Overflow

Error when trying to update database in .NET Core

Context

appsettings.cs

Startup.cs

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

Context

appsettings.cs

Startup.cs

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related