Cannot open database requested by the login - "Error Number:4060,State:1,Class:11"

Question

Cannot open database requested by the login - "Error Number:4060,State:1,Class:11"

Juan Jose Herrera 0

I have an ASP.NET app, and when I launch the app 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_'.

The database exists, and so do all the tables. I can connect to the database from SSMS and the 'Server Explorer' view in Visual Studio. I am using the connection string provided by the Server Explorer in Visual Studio. I also did a clean installation of Windows, Visual Studio, SQL Server, and SSMS. Currently, I have only one DB server and one database.
sql server win

My VS and connection string:
VS win

And finally the error:

error win

Please help me; this error is driving me mad. If you need any extra info, please let me know.

EDIT 1: I forgot to mention that I disabled my Windows firewall.

MikeyQiaoMSFT-0444 3,310 Reputation points

2024-09-18T10:05:57.8833333+00:00

Hi，Juan Jose Herrera

I'm glad to hear that you've found a solution to the problem.

I would like to suggest that you 'accept' the answer in the Thread. Doing so will conclude this Thread, increase its relevance, and better assist friends who have similar problems.

We will appreciate everything you have done. ^_^

2 answers

Your answer

MikeyQiaoMSFT-0444 3,310 Reputation points

2024-09-18T10:05:57.8833333+00:00

Hi，Juan Jose Herrera

I'm glad to hear that you've found a solution to the problem.

I would like to suggest that you 'accept' the answer in the Thread. Doing so will conclude this Thread, increase its relevance, and better assist friends who have similar problems.

We will appreciate everything you have done. ^_^

Answer 1

Juan Jose Herrera 0

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.

Thank you all for your time..¡

Juan Jose Herrera 0 Reputation points

2024-09-14T21:46:40.2766667+00:00

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.

Thank you @Erland Sommarskog and @MikeyQiaoMSFT-0444 for your time and your guidance..¡
Juan Jose Herrera 0 Reputation points

2024-09-14T22:04:32.9466667+00:00

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.

Thank you @Erland Sommarskog and @MikeyQiaoMSFT-0444 for your time..¡
Juan Jose Herrera 0 Reputation points

2024-09-14T22:06:55.7566667+00:00

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.

Thank you @Erland Sommarskog and @MikeyQiaoMSFT-0444 for your time..¡

Answer 2

Bruce (SqlWork.com) 84,061

you need to give the user "DESKTOP-KRBN07G\juan_" access to the database. I assume you are running VS as admin, which gives you back door access.

Juan Jose Herrera 0 Reputation points

2024-09-13T21:47:35.2633333+00:00

Thanks for answering. I didn't take that into account, but I just tried it and, sadly, I get the same error.
Erland Sommarskog 134.1K Reputation points MVP Volunteer Moderator

2024-09-13T21:52:05.26+00:00
So you did not do in the right way.

CREATE LOGIN "DESKTOP-KRBN07G\juan_" FROM WINDOWS USE appointments CREATE USER "DESKTOP-KRBN07G\juan_"

Then you also need to grant the user the permissions needed to run the application. But with the above commands you will get a different error.
Juan Jose Herrera 0 Reputation points

2024-09-14T02:58:41.5133333+00:00

When I run that script, I get two errors: the first says that a login name 'DESKTOP-KRBN07G\juan_' already exists, and the second says that a user is already associated with that login name, which is 'dbo'.

I found out by using:

SELECT CURRENT *USER;
GO

that in both SSMS and VS, the user connecting to the database is 'dbo'. I deleted the database, created it again, and I* thought I successfully set 'DESKTOP-KRBN07G\juan' as the owner (check the picture). Then I ran the previous script again, hoping to see 'DESKTOP-KRBN07G\juan_', but that wasn't the case—it returned 'dbo' again. The app still fails and throws the same error of course.

Why VS connect as 'dbo' and not as 'DESKTOP-KRBN07G\juan_'?
MikeyQiaoMSFT-0444 3,310 Reputation points

2024-09-14T06:20:16.0133333+00:00

The actions are being executed in the context of 'dbo' because the current user has 'dbo' level permissions. This is similar to the effect of 'SELECT CURRENT_USER'; it doesn't mean you didn't log in as 'DESKTOP-KRBN07G\juan_', it's just that your operations in the database are executed in the context of 'dbo'. If you want to see the actual login name, you should use 'SELECT SYSTEM_USER' or 'SELECT ORIGINAL_LOGIN()', which will return the Windows username you used to log in to SQL Server, rather than the user context at the database level.
Erland Sommarskog 134.1K Reputation points MVP Volunteer Moderator

2024-09-14T09:11:31.53+00:00
If you are the owner of the database, or you are in the server role sysadmin, you username in the database is always dbo. And as dbo, you always have permission to connect to the database. (But the connection will fail if the database is in single-user mode, and there is already a connection to it. However, that does not seem to be the case.)

In one of your screenshots it looks funny, since you actually have a database user DESKTOP-KRBN07G\juan in parallel with dbo. It also seems funny, since it has a default schema of db_owner, rather than the usual dbo.

If you open a command line prompt and type:

sqlcmd -d appointments

What happens?

Anyway, I'm starting to lean towards that there is an issue in your source code, like an invisible character has sneaked into the database name in the connection string. So delete that line and re-type it to see what happens.

Also, I see that you are running an old build of SQL 2022 without any cumulative updates. You should download and install the most recent Cumulative Update to get access to many bug fixes and enhancements. You seem to have some GDRs installed. You may have to uninstall these to apply the CU.
Juan Jose Herrera 0 Reputation points

2024-09-14T21:48:51.12+00:00

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.

Thank you @Erland Sommarskog and @MikeyQiaoMSFT-0444 for your time and guidance..¡
Juan Jose Herrera 0 Reputation points

2024-09-14T21:57:00.2733333+00:00

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.

Thank you @Erland Sommarskog and @ MikeyQiaoMSFT-0444 for your time..¡
Juan Jose Herrera 0 Reputation points

2024-09-14T21:58:51.83+00:00

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.

Thank you @Erland Sommarskog and @MikeyQiaoMSFT-0444 for your time..¡
Juan Jose Herrera 0 Reputation points

2024-09-14T21:59:59.8366667+00:00

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.

Thank you guys for your time..¡

Share via

Cannot open database requested by the login - "Error Number:4060,State:1,Class:11"

2 answers

Your answer