This forum is closed. Thank you for your contributions.

Sign in

Microsoft.com

Microsoft

Remove From My Forums

Can't get lightswitch to connect to SQL server

Question
0

Sign in to vote

I'm trying out the beta of lightswitch, and I can't get it to connect to the Northwind database through SQL Server.When I add datasource | database | Microsoft SQL Server it seems I have to enter something in the server name box but the dropdown is empty.

I've never used SQL server before, so I don't know whether that's installed correctly or whether it's a lightswitch problem. Where should I ask for help troubleshooting this?

Wednesday, September 8, 2010 11:02 PM

Answers

2

Sign in to vote
Browsing for servers is not enabled. If it is a default instance you just type a . (dot) in the server box. That should do. If your computer name is "mycomp" you may try mycomp/.

If your server is a named instance you should try mycomp/myserver instance name

for example on my Hodentek3 computer I have SQL Express, this is what I enter:

HODENTEK3\SQLEXPRESS
mysorian
- Marked as answer by Ed Price - MSFTMicrosoft employee Tuesday, April 24, 2012 3:08 PM
Monday, September 27, 2010 9:51 PM
1

Sign in to vote
Hello,

Thank you for your post! I would suggest posting your question in one of the LightSwitch Developer Center > Visual Studio LightSwitch Forums > Visual Studio LightSwitch - General (Beta1) located here:

http://social.msdn.microsoft.com/Forums/en-US/lightswitchgeneral/threads

Hope this helps you.

Have a great day!

Thanks!
Dinesh
Tier 2 Application Support
Server and Tools Online Operations Team
- Proposed as answer by Dinesh Kattameda Thursday, September 9, 2010 4:49 AM
- Marked as answer by Ed Price - MSFTMicrosoft employee Tuesday, April 24, 2012 3:08 PM
Thursday, September 9, 2010 4:49 AM
1

Sign in to vote
Here is a complete example. This one connects to SQL Azure, but you can connect to SQLExpress 2008 or other databases.

http://hodentekmsss.blogspot.com/2010/08/hook-up-with-sql-azure-using-microsoft.html

mysorian
- Marked as answer by Ed Price - MSFTMicrosoft employee Tuesday, April 24, 2012 3:08 PM
Saturday, October 9, 2010 1:11 PM

All replies

1

Sign in to vote
Hello,

Thank you for your post! I would suggest posting your question in one of the LightSwitch Developer Center > Visual Studio LightSwitch Forums > Visual Studio LightSwitch - General (Beta1) located here:

http://social.msdn.microsoft.com/Forums/en-US/lightswitchgeneral/threads

Hope this helps you.

Have a great day!

Thanks!
Dinesh
Tier 2 Application Support
Server and Tools Online Operations Team
- Proposed as answer by Dinesh Kattameda Thursday, September 9, 2010 4:49 AM
- Marked as answer by Ed Price - MSFTMicrosoft employee Tuesday, April 24, 2012 3:08 PM
Thursday, September 9, 2010 4:49 AM
2

Sign in to vote
Browsing for servers is not enabled. If it is a default instance you just type a . (dot) in the server box. That should do. If your computer name is "mycomp" you may try mycomp/.

If your server is a named instance you should try mycomp/myserver instance name

for example on my Hodentek3 computer I have SQL Express, this is what I enter:

HODENTEK3\SQLEXPRESS
mysorian
- Marked as answer by Ed Price - MSFTMicrosoft employee Tuesday, April 24, 2012 3:08 PM
Monday, September 27, 2010 9:51 PM
1

Sign in to vote
Here is a complete example. This one connects to SQL Azure, but you can connect to SQLExpress 2008 or other databases.

http://hodentekmsss.blogspot.com/2010/08/hook-up-with-sql-azure-using-microsoft.html

mysorian
- Marked as answer by Ed Price - MSFTMicrosoft employee Tuesday, April 24, 2012 3:08 PM
Saturday, October 9, 2010 1:11 PM