6 comments

Add a comment…

Sign in

prestine

Your email address

Check!

invalid email

(thinking…)

Reset

or sign in with

• 
• 

UserVoice password

Forgot password?

Create a password

Your name

I agree to the terms of service

Signed in as (Sign out)

Close

Close

Post comment Submitting...

• Irfan Shaikh commented  ·  February 17, 2012 6:00 a.m.  ·  Flag as inappropriateFlag as inappropriate  ·  Delete

  LightSwitch requires User Instance=True in the connection string of SQL Server while developing application. There are many reasons when developers wont able to connect to the local SQL Server (Express) using user Instance=True. Also I guess LightSwitch developers need admin rights to connect to the SQL server user Instance. Most of the organizations provide developer account which is not local admin. Connecting to the SQL server User Instance is often problematic….

• Beth Massi commented  ·  November 30, 2011 12:53 p.m.  ·  Flag as inappropriateFlag as inappropriate  ·  Delete

  Thanks Tom, I'm going to close this then so you can have your votes back.

• Tom commented  ·  November 29, 2011 10:57 a.m.  ·  Flag as inappropriateFlag as inappropriate  ·  Delete

  Hi Beth,

  When LS starts, the splash screen says "Connect to a Database". Since I come from WinForms development, I entered the name of the network SQL server. Being a beginner with LS, I did not know that it needed a local DB too.

  I am not asking for any changes. This feedback originally came from my not understanding that LS needed a local DB.

  Thanks for your help,
  Tom

• Beth Massi commented  ·  November 29, 2011 9:44 a.m.  ·  Flag as inappropriateFlag as inappropriate  ·  Delete

  Hi Tom,

  You can connect to network servers as external datasources. However, in order to design new tables in a database, the development environment needs to use a local SQL express database. You can deploy this to any version of SQL server to run it though. Are you asking for the ability to for the development environment to connect to a network server while you are building the application? Can you explain why you would need this?

  Thanks!
  -Beth Massi, LightSwitch Team

• Tom commented  ·  November 26, 2011 4:37 a.m.  ·  Flag as inappropriateFlag as inappropriate  ·  Delete

  The problem: I am used to WinForms development. I assumed you could connect to a network SQL Server. Turns out that LS needs a local SQL DB or it will not work. I do not see any information why it needs a local SQL DB. Thank you

• Beth Massi commented  ·  November 22, 2011 9:55 a.m.  ·  Flag as inappropriateFlag as inappropriate  ·  Delete

  Hi there, can you be more specific on what error you are running into?

  Thanks,
  -Beth