ASP.NET Core MVC application with SQLLocalDB - login error

Question

question

RussellFisher asked Mar 18, '20 FayWang-MSFT edited Mar 19, '20

ASP.NET Core MVC application with SQLLocalDB - login error

VisualStudio 2017 ASP.NET Core MVC application with SQLLocalDB

WIndows update and user name change

Yesterday Windows did a forced update on my computer lasting about three and a half hours, during which time the machine was entirely unusable. When it was finished, it looks as though everything under my previous default user account was moved to a new user using the same name with &#34;.000&#34; appended to it. The new default user name is fishe_000.000. I didn&#39;t detect any adverse effects from the update until I tried to run an application I am working on that utilizes SQL LocalDb as the development data source. As a consequence of the update the application cannot open the database, possibly because it is using my previous user identity. The error message is:

SqlException: Cannot open database &#34;IdentityUsers&#34; requested by the login. The login failed. Login failed for user &#39;RUSS\fishe_000&#39;.

I&#39;m not really sure how to deal with this situation. It is a genuine hold-up for the project I am working on. Any suggested fixes would be deeply appreciated.

Thanks

not-supported

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 1 · 2020-03-19T02:13:45.153Z

FayWang-MSFT answered Mar 19, '20

Hello,

Welcome to our Microsoft Q&A platform!

The Q&A platform is currently in preview, and your question is not currently supported. Your question is about ASP. NET Core, so you can go to ASP.NET Core forum to ask it.

Thanks.

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