'System.Data.SqlClient.SqlException: Login failed for user' error on asp.net core 1 db first

Question

I'm following this guide building a new core version of my current mvc 5 website. I have an existing sql database hosted on azure and I want to build the project database first. I followed the instructions but on the "reverse engineer you model" part I keep getting an error:

System.AggregateException: One or more errors occurred. (Login failed for user 'removed'.) ---> System.Data.SqlClient.SqlException: Login failed for user 'removed'.

The username and password are correct and working on the current project. This is the connection string:

Scaffold-DbContext "Server=tcp:removed.database.windows.net,1433;
  Data Source=removed.database.windows.net;Initial Catalog=removedCatalog;
  Persist Security Info=False;User ID=removedId@removed;Password=removedPass;
  Pooling=False;MultipleActiveResultSets=False;Encrypt=True;
  TrustServerCertificate=False;Connection Timeout=30;"
   Microsoft.EntityFrameworkCore.SqlServer

Any insight to what am I missing here?

This link could help: stackoverflow.com/questions/3674160/… Two things to check are that the server name/IP in the connection string must exactly match the server name/IP in the certificate (@Moriarty) and @Vort3x made a point about servers with default certificates changing when they are restarted. — John D
– John D, Commented May 28, 2016 at 4:30
Things is, I can connect to it via VS Server Explorer with the same credentials. Also, the local version of the online site connects to the db with this exact connection string. So I believe it's something with the import proccess, not the string or the server. — Shiran Dror
– Shiran Dror, Commented May 28, 2016 at 4:38
Did this error occur when running "Scaffold-DbContext" command or somewhere else? I just tried that command and it works on my side. — forester123
– forester123, Commented May 31, 2016 at 4:27

Yovav · Accepted Answer · 2016-05-28 05:12:52Z

1

Make sure that the user exist on SQL Server, that the user is enabled, and has access (mapped) to the correct database.

answered May 28, 2016 at 5:12

Yovav

2,8272 gold badges38 silver badges57 bronze badges

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

Collectives™ on Stack Overflow

'System.Data.SqlClient.SqlException: Login failed for user' error on asp.net core 1 db first

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related