ASP.NET Core MVC application with SQLLocalDB - login error

RAFish5004 1 Reputation point
2020-03-18T21:13:41.723+00:00

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 ".000" appended to it. The new default user name is fishe_000.000. I didn'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 "IdentityUsers" requested by the login. The login failed. Login failed for user 'RUSS\fishe_000'.

I'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 Monitored
Not Monitored
Tag not monitored by Microsoft.
36,246 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Fay Wang - MSFT 5,196 Reputation points
    2020-03-19T02:13:45.153+00:00

    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.

    0 comments