How to Change Development Database in LightSwitch
Last week I had an issue building my LightSwitch project on Windows 8 instance because it had SQL 11 express instance as the default DB instance on the computer. I then installed SQL Server 2008 R2 Express on the machine to make it build.
You may have noticed that LightSwitch doesn’t provide an intuitive way to change the instance of the Dev database. I have done the following to connect to the SQL Server 2008 R2 instance
Right click on the LS project
Right click the project and click edit
Find SqlExpressInstanceName attribute
Replace the database instance with one you want to connect to. In my case, I replaced
Right click the project and reload