ASP.NET MVC - impossible to change the default SQL connection string

Question

I am using latest version of VS 2022 Community edition. I created a new ASP.NET Core web app (Model-View-Controller) project. I also chose the authentication option "Individual Accounts".

The project runs fine, my problems comes when I try to change the connection string to point to a specific database that I already have on a SQL Server Express installed in the same machine.

I add a new connected service and I click on the three dots (...) to introduce the parameters for the new SQL Server connection string.

The new params are:

Data source : Microsoft SQL Server (SqlClient)
Server name: localhost\SQLEXPRESS
Authentication: Windows Authentication
Select or enter database name : XXXXX ( the drop down list is correctly populated with all databases available in the server). I just choose the one I want

I click on "Test Connection" and the test succeeded. I press OK. The resulted connection string value is

Data Source=localhost\SQLEXPRESS;Initial Catalog=abstract;Integrated Security=True

I click Next and Finish and something is shown in the windows but I cannot read it as it closes immediately.

After this, I click on Edit the same connected service and surprisingly the connection string is empty (!).

Could someone tell me what I am doing wrong?

that connected service is not the way to go. edit the projects appsettings.json file — jazb
– jazb, Commented Jan 30, 2022 at 10:48

Rahul Sharma · Accepted Answer · 2022-01-30 11:10:43Z

1

I just managed to configured the connection to my loca DB by editing the file appsettings.json

{   "ConnectionStrings": {
    "DefaultConnection": "Server=(localhost)\\\\SQLEXPRESS;Database=abstract;Trusted_Connection=True;MultipleActiveResultSets=true" },   "Logging": {
    "LogLevel": {
      "Default": "Information",
      "Microsoft.AspNetCore": "Warning"
    }   },   "AllowedHosts": "*" }

Not sure if this is the correct way to do it, but it worked

edited Jan 30, 2022 at 11:10

Rahul Sharma

8,3772 gold badges39 silver badges58 bronze badges

answered Jan 30, 2022 at 10:54

YaKs

3315 silver badges19 bronze badges

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

1 Comment

Wiktor Zychla Over a year ago

This is the correct way. Whatever Visual Studio tries to do, it ultimately only changes the appsettings.json as it's the only connection string source your application needs. You won't install VS on each server your application is to be deployed, though.

Collectives™ on Stack Overflow

ASP.NET MVC - impossible to change the default SQL connection string

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related