Database in ASP_Data cannot be opened after attached in SQL Server Management Studio

Vote count:

0

I have the standard MVC template project in VS 2013. The database is automatically created for Identity management and it has the form aspnet-appname-20150216024853 and is located in the App_Data folder.

I wanted to add more data rows to this database so I attached the mdf and ldf files in SSMS to access the database. After I have done this, my MVC web app cannot open the database anymore. It says:

Cannot open database "aspnet-appname-20150216024853" requested by the login. The login failed. Login failed for user 'MOZART\user'.

MOZART is my computer name.

Does the error mean the credentials are incorrect? How does attaching a database using the files affect security?

asked 48 secs ago

Old Geezer

1,088

Database in ASP_Data cannot be opened after attached in SQL Server Management Studio