Error SQL in appsettings.json string
I can't connect my project to the SQL Server Local instance. Even after configuring the connection string in appsettings.json, it doesn't work when running the dotnet ef database update command.
I've tried various methods:
- Using Windows credentials gives an error saying it’s not supported.
- Using the default sa credentials also fails.
Error:
PS $dotnet ef database update
Build started...
Build succeeded.
fail: Microsoft.EntityFrameworkCore.Database.Connection[20004]
An error occurred using the connection to database '' on server 'DESKTOP-2222222'.
An error occurred using the connection to database '' on server 'DESKTOP-2222222'.
info: Microsoft.EntityFrameworkCore.Infrastructure[10404]
I've tried various methods:
- Using Windows credentials gives an error saying it’s not supported.
- Using the default sa credentials also fails.
Error:
PS $dotnet ef database update
Build started...
Build succeeded.
fail: Microsoft.EntityFrameworkCore.Database.Connection[20004]
An error occurred using the connection to database '' on server 'DESKTOP-2222222'.
An error occurred using the connection to database '' on server 'DESKTOP-2222222'.
info: Microsoft.EntityFrameworkCore.Infrastructure[10404]
