I'm currently hosting a database on the server
MyComputerName using SQL Server Express 2014.
I want to move the database to another computer, so I installed SQL Server Express 2014 on it but that computer only has the instance
ThatComputerName\SQLEXPRESS. When I try to connect to just
ThatComputerName it throws the error
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2)
However, I can't enable remote connections on
ThatComputerName because I can't even connect to that instance.
I don't remember what I did on the previous computer to allow me to connect both to
MyComputerName\SQLEXPRESS, how can I create that instance on the new computer? Do I have to reinstall?