Database shows up in Visual Studio but not SSMS

Asked Jun 15 '18 at 13:23

Active Jun 15 '18 at 13:23

Viewed 266 times

I'm running the sample code I downloaded from GitHub for the project here: https://learn.microsoft.com/en-us/aspnet/core/security/authentication/identity?view=aspnetcore-2.1&tabs=visual-studio%2Caspnetcore2x

So, in Visual Studio, I can see the aspnet-IdentityDemo DB created in the object explorer, but when I go to SSMS and refresh things, I don't see it. How come it isn't showing up in SSMS?

asked Jun 15 '18 at 13:23

Amanda_Panda

1,156
4
26
68

Did you connect to the Server and then checked if the database was present? – Abhishek Jun 15 '18 at 13:25
1

most likely using localdb version which is not going to be found in ssms. https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/sql-server-2016-express-localdb?view=sql-server-2017 – Joe Audette Jun 15 '18 at 13:34
1

https://stackoverflow.com/questions/12534454/how-to-connect-to-localdb – Joe Audette Jun 15 '18 at 13:35
Thanks I’ll give it a try when I get home! – Amanda_Panda Jun 15 '18 at 14:11

Database shows up in Visual Studio but not SSMS

0 Answers0