Fix the problem connecting to SQL Server
There seems to be a known problem connecting to an SQL server. I have experienced it myself. I see forum messages with similar problems. Please resolve this error. Thank you.
There is no issue per comments below.
Irfan Shaikh commented
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….
Thanks Tom, I'm going to close this then so you can have your votes back.
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,
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?
-Beth Massi, LightSwitch Team
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
Hi there, can you be more specific on what error you are running into?