Login failed for user 'DESKTOP-KRBN07G\juan_'

Question

I have an ASP.NET app, and when I launch the app from Visual Studio and try to list items from a table by accessing the corresponding route, I get this error:

SqlException: Cannot open database "appointments" requested by the login. The login failed. Login failed for user 'DESKTOP-KRBN07G\juan_'.

I use SQL SERVER MANAGEMENT STUDIO, in login I have DESKTOP-KRBN07G\juan_ with the table checked in User Mapping and db_owner checked as role. I also added a user DESKTOP-KRBN07G\juan_ to that DB.

I can connect to the DB from Visual Studio and SSMS.

I'm new in the backend and I don't know how to fix this or what should I check, I get some scripts from chatGTP attempting to get some info, I run those script in SSMS and I get this:

In my appSettings.json file I use:

"ConnectionStrings": {
    "Appointments": "Data Source=DESKTOP-KRBN07G; 
  Initial Catalog=appointments;Integrated 
  Security=True;
  Trust Server Certificate=True"
  }

A colleague tried the app on his local development environment and didn’t get the error. I’m not sure what I should check or what to do.

Answer 1

It might be that the SQL Server is set not to allow access except by Windows Authentication, I've seen this allow connections from DB tooling but not Apps etc.

If you check your logs it will be clear in there.

Steps to fix are along these lines:-

• On the Object Explorer window right click on the server name and go to Properties.
• Select the Security section.
• Under Server Authentication change the selection from Windows Authentication mode to SQL Server and Windows Authentication mode.
• Click Ok

Answer 2

Well, guys, I found the problem, it was a wrong and 'hidden' Connection String.

I created a new database with a different name, but the error in the browser after launching the app in my localhost kept pointing to the old database name.

After that, I searched for the old database name throughout the project and discovered that my colleague had added a partial class inside the DataAccess project of the ASP.NET application, which runs in development mode and contains his connection string.

I changed that, and now everything is working fine. All I knew was that the connection string should be in Program.cs or appsettings.json, and no other places.