ASP.NET Core MVC: connecting to existing database using SQL Server authentication

Question

I am new to webpage development, and trying to connect my ASP.NET Core MVC code to an existing SQL Server database, using SQL Server authentication. Right now it will only take my computer identification, which of course gets rejected by the SQL Server database. Can anyone tell me how I am supposed to do this?

Details:

Programing is done in Visual Studio 2019, with ASP.NET Core, Entity Framework. All software is up to date.
I followed this tutorial exactly: https://learn.microsoft.com/en-us/ef/core/get-started/aspnetcore/existing-db but it doesn't include SQL Server authentication.
I have my SQL Server login information, and it does allow me to manually connect using "Tools -> Connect to Database". I can see my database and navigate through it, but cannot connect to migrate the data over to my MVC files.
I did successfully complete the entire Microsoft ASP.NET MVC tutorial wherein you create a movies database and use that for an example webpage. The difficulty comes when connecting to an existing database.

Thank you guys so much for your help!

HSpeckman
– HSpeckman

2019-06-09 15:29:39 +00:00
Commented Jun 9, 2019 at 15:29 — HSpeckman
– HSpeckman, Commented Jun 9, 2019 at 15:29

marc_s · Accepted Answer · 2019-05-26 06:23:49Z

1

Depending on the Connection method you are using. In your appsettings.json, you can set the connection string like below:

For Windows authentication:

"ConnectionString": "Server=laptop-15;Database=testDatabase;Trusted_Connection=True;MultipleActiveResultSets=true"

For SQL Server authentication:

"ConnectionString": "Server=laptop-15;Database=testDatabase;User Id=user; Password=user;Trusted_Connection=True;MultipleActiveResultSets=true"

Let me know if this solves your issue. Thanks

edited May 26, 2019 at 6:23

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

answered May 26, 2019 at 2:50

Samuel Akosile

3391 gold badge2 silver badges9 bronze badges

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

Comments

SteveC · Accepted Answer · 2020-09-12 11:38:29Z

0

In addition to the very good information from Samual Akosile regarding connection strings using SQL Server auth, the simplest way afaik to wire it up uses the built-in GetConnectionString() method.

In appsettings.json add the following (with your appropriate connection string) piece of JSON

  "ConnectionStrings": {
    "SQLServerConnectionStr": "Server=Your connection string goes here;"
  }

Then in startup.cs where you configure the IServiceCollection services add the following

services.AddDbContext<YourDbContextClass>(options =>
            options.UseSqlServer(Configuration.GetConnectionString("SQLServerConnectionStr")));

answered Sep 12, 2020 at 11:38

SteveC

6,0252 gold badges14 silver badges26 bronze badges

Collectives™ on Stack Overflow

ASP.NET Core MVC: connecting to existing database using SQL Server authentication

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related