Breaking News: Grepper is joining You.com. Read the official announcement!

scaffold-dbcontext login failed for user

Sparkie answered on September 3, 2021 Popularity 6/10 Helpfulness 4/10

answer scaffold-dbcontext login failed for user

scaffold-dbcontext login failed for user

Comment

When I use the PMC in Visual Studio and try to Scaffold-DbContext with 
Scaffold-DbContext “Data Source=localhost;Database=Library;Integrated Security=True” Microsoft.EntityFrameworkCore.SqlServer -OutputDir Models
I get error login failed.
The correct way to go about it is to get the connection string for the database from View->Sql Server Object Explorer and go to the Properties of the Database. Use the connection string from there
So in this specific case the correct PMC command was:
Scaffold-DbContext “Data Source=(localdb)\MSSQLLocalDB;Initial Catalog=Library;Integrated Security=True;Connect Timeout=30;Encrypt=False;TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False” Microsoft.EntityFrameworkCore.SqlServer -OutputDir Models

Popularity 6/10 Helpfulness 4/10 Language whatever

Source: www.syncfusion.com

Tags: whatever

Link to this answer
Share Copy Link