Base solution for your next web application
Open Closed

inquire about ASP.NET Zero Database Migrations #6714


User avatar
0
palco.ps created

hi i want to ask about the database migration i choose the second option to migrate the database (Entity Framework Migration Command) when i write the command (Update-Database) this error appear
"CREATE DATABASE permission denied in database 'master'" i am using Microsot SQL server can you help me??


1 Answer(s)
  • User Avatar
    0
    maliming created
    Support Team

    This seems to be a problem with sql server.

    Please make sure

    1. You have appropriate authentication mode enabled.
    2. You can connect to database using userid/password or windows auth.
    3. Whichever mode you connect has permission to create database.

    Or you can try it with ef core cli: https://docs.microsoft.com/en-us/ef/core/miscellaneous/cli/dotnet#dotnet-ef-database-update