I created the Aquarium Database for the exercise in Chapter 4 by executing the sql script in SQL Server 2008 R2. This is running on my local machine.
I see it and all the data in SSMS.
I was able to connect to the database to create the DataSource for the project. I created the search screen. Again with no issue.
I even created a connection in server explorer.
However when I run it, I get an error: Unable To Load Date. Please Check Your Network, and try reloading again.
I thought it might be a permissions issue, so I went in and gave Public all permissions to the db. Still getting the error.
Also checked that Remote Access was enabled on the server.
Any suggestions for me to look at.

I started with a workstation with SQL Server 2008 R 2 installed on it, had similar problems. Now I built a new workstation without it, and seem to be working better. I also only installed LightSwitch as a standalone Visual Studio installation. This is the kind of development system I need as a business owner. The end may be worth it if I can get there.