locked
An error occurred while establishing a connection to SQL Server instance '(LocalDB)\v11.0' RRS feed

  • Question

  • When LightSwitch opened yesterday I saw a message about an update, after I applied it, I now get this error:

    An error occurred while establishing a connection to SQL Server instance '(LocalDB)\v11.0'.
    Login failed for user '{Computer Name}\{User Name}'. C:\Program Files\MSBuild\Microsoft\VisualStudio\LightSwitch\v2.0\Microsoft.LightSwitch.targets 174 10 Application1

    I did a repair and reboot and that did not fix the problem. I am now about to reinstall LightSwitch again for the second time (last time I got the template cannot be loaded error).


    The Visual Studio LightSwitch Marketplace

    http://LightSwitchHelpWebsite.com

    Saturday, April 21, 2012 7:57 PM

Answers

  • Matt on the LightSwitch team got me running again:


    1) Delete the directory at:

    C:\Users\{your user name}\AppData\Local\Microsoft\Microsoft SQL Server Local DB\Instances\v11.0

    Note: replace "{your user name}" with the name you logged in with.


    2) On your Windows start Menu type in CMD and press enter. When the Command Window comes up type:

    cd "C:\Program Files\Microsoft SQL Server\110\Tools\Binn"

    then:

    sqllocaldb.exe delete v11.0

    It will say:

    LocalDB instance "v11.0" deleted.

    Then open a LightSwitch project and run it and it should then work


    The Visual Studio LightSwitch Marketplace

    http://LightSwitchHelpWebsite.com


    Monday, April 23, 2012 8:30 PM

All replies