SQL Server R2 and LightSwitch

Hi,

I am using VS 2010 with LightSwitch installed. Before installing SQL Server R2, LightSwitch worked fine. But after installing SQL Server R2 its giving error like the below one.

Error:

Error 11 An error occurred while establishing a connection to SQL Server instance '.SQLEXPRESS'.
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 – Error Locating Server/Instance Specified) C:Program Files (x86)MSBuildMicrosoftVisualStudioLightSwitchv1.0Microsoft.LightSwitch.targets 95 10 CMS

Please Help me.

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Sam Hobbs15y ago
Are you experienced with starting and stopping SQL Server? If not, then it is probably just a matter of restarting it. The upgrade probably stopped it. It is frustrating that Microsoft stops SQL Server for maintenance but then does not restart it and does not tell us that we need to.
0