replaced http://i1178.photobucket.com/ with https://i1178.photobucket.com/

Source Link

edited Mar 10, 2017 at 9:42

1

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?

screenshot http://i1178.photobucket.com/albums/x374/K29000/questionfinal_zps3bcfdc7c.png

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?

screenshot http://i1178.photobucket.com/albums/x374/K29000/questionfinal_zps3bcfdc7c.png

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?

screenshot

edited body; edited title

Source Link

edited Nov 21, 2014 at 6:16

marc_s

9k
6
45
52

SQL server expressServer Express: difference between connecting to localhost and localhost\sqlexpress

I am new to SQL serverServer and am following some tutorials.

I have not yet created any databases. In SQL server management studioServer 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?

screenshot http://i1178.photobucket.com/albums/x374/K29000/questionfinal_zps3bcfdc7c.png

SQL server express: difference between connecting to localhost and localhost\sqlexpress

I am new to SQL server and am following some tutorials.

I have not yet created any databases. In SQL server management studio 2012 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?

screenshot http://i1178.photobucket.com/albums/x374/K29000/questionfinal_zps3bcfdc7c.png

SQL Server Express: difference between connecting to localhost and localhost\sqlexpress

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?

screenshot http://i1178.photobucket.com/albums/x374/K29000/questionfinal_zps3bcfdc7c.png

Formated question and changed the title

Source Link

edited Nov 20, 2014 at 13:08

k29

175
1
6

SQL server express: difference between logging into default instanceconnecting to localhost and named instancelocalhost\sqlexpress

I am new to SQL server and am following some tutorials.

I have not yet created any databases. In SQL server management studio 2012 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?

screenshot http://i1178.photobucket.com/albums/x374/K29000/questionfinal_zps3bcfdc7c.png

SQL server express: difference between logging into default instance and named instance

I am new to SQL server and am following some tutorials.

I have not yet created any databases. In SQL server management studio 2012 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?

SQL server express: difference between connecting to localhost and localhost\sqlexpress

I am new to SQL server and am following some tutorials.

I have not yet created any databases. In SQL server management studio 2012 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?

screenshot http://i1178.photobucket.com/albums/x374/K29000/questionfinal_zps3bcfdc7c.png