I have created a backup of a SQL database in SQL 2014 and want to use this backup to restore it to a different machine that also runs SQL 2014, hence no version issues. However, I keep receiving an error that the system cannot find the .mdf file.
Once I have selected the backup file I receive the check mark that the database is ready to be restored but as soon as I click Ok the error appears.
Error message below; the provided link to MSFT does not contain any information.

> 
> TITLE: Microsoft SQL Server Management Studio Restore of database
>  'BEWEBAPP' failed.
>  (Microsoft.SqlServer.Management.RelationalEngineTasks) ADDITIONAL
>  INFORMATION: System.Data.SqlClient.SqlError: Directory lookup for the
>  file "C:\Program Files\Microsoft SQL
>  Server\MSSQL12.SQLEXPRESS\MSSQL\DATA\BEWEBAPP.mdf" failed with the
>  operating system error 3(The system cannot find the path specified.).
>  (Microsoft.SqlServer.SmoExtended) For help, click:
>  <http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=12.0.2000.8+((SQL14_RTM).140220-1752)&LinkId=20476>
> 
> 
> 

Does this means that a backup can only be restored to the machine it was taken from??
Frankly, I do not understand why restoring a database has to be so difficult.

Any solution for this problem are well appreciated.