Export SQL Server to MDF

The best way to do so is by using SQL Script and not by any other methods.

To do so, simply go to the sql tools: "tasks" -> "generate script" -> remember to set the option for data export to be true.

SQL Server Connection

http://www.visual-paradigm.com/support/articles/solve-sql-server-connection-problem.jsp

Ensure that inside SQL Server configuration, under SQL Network Configuration, that TCP port settings has been set. The default port is 1433.