Login Failed when trying to use SQL database to store wpf data

Question

question

uzairakhalwaya-2700 asked May 1, '22 AmeliaGu-msft commented May 5, '22

Login Failed when trying to use SQL database to store wpf data

System.Data.SqlClient.SqlException: 'Cannot open database "StockSystemdb." requested by the login. The login failed.
Login failed for user 'MicrosoftAccount\MyEmail'.'

Any fix?

sql-server-general azure-sql-database windows-11 windows-wpf

· 2

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Reza-Ameri · May 01 at 12:59 PM

Did you observe the same behavior when you used Windows 10?
Are you able to login with the same credential in the SQL Management Studio?

0 ·

AmeliaGu-msft · May 05 at 06:04 AM

Hi uzairakhalwaya-2700,

How are things going? Were the answers helpful?
Please feel free to let us know if you have any other question. If the post in the thread is helpful, you could kindly accept it as answer.

Best Regards,
Amelia

0 ·

Answer 1 · 2022-05-01T15:23:39.853Z

ErlandSommarskog answered May 1, '22

Well, you would need to add MicrosoftAccount\MyEmail as a user in the database StockSytsemDb.

It could have helped if you had included what troubleshooting you have performed, and some information why you don't expect to get this error.

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Answer 2 · 2022-05-02T06:12:51.637Z

AmeliaGu-msft answered May 2, '22

Hi uzairakhalwaya-2700,

Welcome to Microsoft Q&A.
Could you please try to use user 'MicrosoftAccount\MyEmail' to connect to SQL Server database and see if there are any detailed error message?
And what the connection string are you using?
Please make sure user 'MicrosoftAccount\MyEmail' exists under database->security->users.

Best Regards,
Amelia

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.

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

question