View Single Post
 
Old November 15th, 2013, 04:50 PM
David Hall David Hall is offline
Registered User
Points: 5, Level: 1
Points: 5, Level: 1 Points: 5, Level: 1 Points: 5, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Nov 2013
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Chapter 4: Can't connect to SQLEXPRESS

Newer versions of LightSwitch do not use .\SQLEXPRESS. I'm using LightSwitch in Visual Studio 2013, but I think this applies to 2012 as well.

In order to connect to the Aquarium database in chapter 4, I used the following command instead of the one provided on page 79:

sqlcmd -S "(localdb)\v11.0" -i "<folder>\CreateAquarium.sql"

For example, if your folder is in C:\Temp, use

sqlcmd -S "(localdb)\v11.0" -i "C:\Temp\CreateAquarium.sql"

Then, on page 81, instead of .\SQLEXPRESS the server name should be:

(localdb)\v11.0