I am new to SQL Server and am following some tutorials.
I have not yet created any databases. In SQL Server 2012 Management Studio I click on "connect" -> "Database Engine". I noticed that, using the server name field, I can type
localhost and then connect or
localhost\sqlexpress and it also connects successfully.
I don't understand what the difference is, and practically what the impact would be to using one over the other. Could somebody please provide an explanation?
In the image below you can see I am connected to both at the same time. One has databases and one does not. What is the difference between these two instances? Why does one have the databases I created and the other does not?