How to find the host address of the Microsoft SQL Server 2012 Express?

me specifically for the Microsoft SQL Server 2012 Express , downloaded put, there is nothing complicated, but I do not understand how to know its address, the program must specify:
The value of "database service" must be in the form host\копия_имени_sql server


where to look? And if sql server will for example not on the same PC and another network or the Internet
if I throw the port and get the ip of the computer on which is sql server..

p.s. is win 10
March 23rd 20 at 18:51
2 answers
March 23rd 20 at 18:53
Solution
if on the same: 127.0.0.1
if on the other - see for cmd-> ipconfig on it.
March 23rd 20 at 18:55
Solution
The value of "database service" must be in the form host\копия_имени_sql server will be ...
When you install SQL and specify. That is, in the settings will point to [ComputerName]\[Instancename].
More detail in the answers.

how to know the instance name if forgotten?
5cf52e96b1cd6684223633.pngIt is set when start the service:
"C:\Program Files\Microsoft SQL Server\MSSQL14.TSK\MSSQL\Binn\sqlservr.exe" -sMSSQLSERVER
and how to know the instance name if forgotten? There by default stood MSSQLEXPRESS toli toli SQLEXPRESS , I tried this way and in another not work using Oculus rift .

The test did was to create a udl file specified in the server name is the name of your PC , the login password from the database and picked up , but this software does not want(( - claudie45 commented on March 23rd 20 at 18:58

Find more questions by tags SQL Server