Opening the SQL "database" with the given login is not possible when utilizing Windows authentication without a username and password.

Arivazhagan A 0

Machine A and Machine B are the two machines I own. My Java-based application server is on machine A, while my SQL server is on machine B. Both computers are logged in as the same domain user, Administrator, and are part of the 'TEST' domain. Machine B has SQL server installed, and it is logged in to services.msc as domain user. I want to convert the database on my application server to SQL with Windows authentication without having to provide the login and password up front. I have migrated my DB into SQL and created new database in SQL. However, a lack of permission prevented the database from opening upon server launch, and the following exception was encountered.

com.microsoft.sqlserver.jdbc.SQLServerException: Cannot open database "dbname" requested by the login. The login failed

The domain username has been added to SQL Server Security ->login, and the user has been mapped to the database. Despite having DBOwner, public, and administrative permissions provided, the problem persisted. Please, someone assist me in solving this. TIA.

my connection string - jdbc:sqlserver://MachineB:1433;databaseName=DBName;Domain=TEST;integratedSecurity=true;ssl=request

Erland Sommarskog 109.2K Reputation points MVP

2024-07-03T12:02:22.9466667+00:00

Both computers are logged in as the same domain user, Administrator, and are part of the 'TEST' domain

Hm, computers don't log in to the domain, do they?

Under what credentials does the application user run?

And you are sure that you have spelled the database name correctly? And it is not in single-user mode or similar?
LucyChenMSFT-4874 4,015 Reputation points

2024-07-11T01:58:30.15+00:00

Hi @Arivazhagan A ,

We haven't heard any response from you yet.

Is this issue solved now? If you have any questions, please feel free to share with us.

May I humbly suggest that you accept Answer if they helped. It may help others who see the thread in seek of help.

Your action would be helpful to other users who encounter the same issue and read this thread. :)

Thanks for your understanding. Wish you have a nice day!

Best regards,

Lucy Chen
LucyChenMSFT-4874 4,015 Reputation points

2024-07-22T06:24:04.7266667+00:00

Hi @Arivazhagan A ,

I hope the answers below is helpful. If you find any of them useful, please remember to mark them as the accepted answer. If you need any additional information, please feel free to let us know.

Your action would be helpful to other users who encounter the same issue and read this thread. Thank you for your understanding! :)

Best regards,

Lucy Chen
LucyChenMSFT-4874 4,015 Reputation points

2024-08-02T05:59:28.53+00:00

Hi @Arivazhagan A ,

Could you please tell us if there is any new progress on this issue?

We are still very concerned about your issue!

In addition, I don't want to nag you, but maybe our answers are helpful. May I humbly suggest that please accept Answer if they helped.

Your action would be helpful to other users who encounter the same issue and read this thread.

The links and methods we provide will also help them resolve their issue or follow up this issue with us together!

Thanks for your understanding. Your encouragement and recognition are the driving force for our progress!

Best regards,

Lucy Chen

1 answer

LucyChenMSFT-4874 4,015 Reputation points

2024-07-04T03:25:09.7433333+00:00

Hi @Arivazhagan A ,

Thank you for your reaching out and welcome to Microsoft Q&A!

In addition to check out Erland's comment, please refer to this official document, hope this can help you well!

Feel free to share your issue here if you have any concerns!

Best regards,

Lucy Chen

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

https://docs.microsoft.com/en-us/answers/support/email-notifications
Please sign in to rate this answer.
LucyChenMSFT-4874 4,015 Reputation points

2024-07-15T06:02:24.3333333+00:00

Hi @Arivazhagan A ,

We haven't heard any response from you yet.

Is this issue solved now? If you have any questions, please feel free to share with us.

May I humbly suggest that you accept Answer if they helped. It may help others who see the thread in seek of help.

Your action would be helpful to other users who encounter the same issue and read this thread. :)

Thanks for your understanding. Wish you have a nice day!

Best regards,

Lucy Chen

LucyChenMSFT-4874 4,015 Reputation points

2024-07-23T02:25:25.1166667+00:00

Hi @Arivazhagan A ,

I hope the answers below is helpful. If you find any of them useful, please remember to mark them as the accepted answer. If you need any additional information, please feel free to let us know.

Your action would be helpful to other users who encounter the same issue and read this thread. Thank you for your understanding! :)

Best regards,

Lucy Chen
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Opening the SQL "database" with the given login is not possible when utilizing Windows authentication without a username and password.

1 answer

Your answer