2 added 3 characters in body
source | link

Why is it that sqlexpress runs on .\sqlexpress while mssqlserver just runs on .\?

When you would have installed express edition you would have chosen named instance and by default it takes name sqlexpress so whilehence when installing, named instance is installed. When you connect to named instance it is always like hostname\instance name. Now for other installation you would have installed default instance for which you just need to provide hostname to connect.

Why is it that sqlexpress runs on .\sqlexpress while mssqlserver just runs on .\?

When you would have installed express edition you would have chosen named instance and by default it takes name sqlexpress so while installing named instance is installed. When you connect to named instance it is always like hostname\instance name. Now for other installation you would have installed default instance for which you just need to provide hostname to connect.

Why is it that sqlexpress runs on .\sqlexpress while mssqlserver just runs on .\?

When you would have installed express edition you would have chosen named instance and by default it takes name sqlexpress hence when installing, named instance is installed. When you connect to named instance it is always like hostname\instance name. Now for other installation you would have installed default instance for which you just need to provide hostname to connect.

1
source | link

Why is it that sqlexpress runs on .\sqlexpress while mssqlserver just runs on .\?

When you would have installed express edition you would have chosen named instance and by default it takes name sqlexpress so while installing named instance is installed. When you connect to named instance it is always like hostname\instance name. Now for other installation you would have installed default instance for which you just need to provide hostname to connect.