ASP.NET MVC deployment problems with connection string

Question

I have just deployed one mvc application, but it seems that it can't establish proper connection to the database. So during development I was connecting to the database with the following connection string(using windows authentication):

<connectionStrings>
<add name="PicknickDBEntities"     
connectionString="metadata=res://*/Model.csdl|res://*/Model.ssdl|res://*/Model.msl;provider=System.Data.SqlClient;
provider connection string=&quot;
data source=**-**-**\SQLEXPRESS;
initial catalog=PicknickDB;
integrated security=True;
MultipleActiveResultSets=True;
App=EntityFramework&quot;" 
providerName="System.Data.EntityClient" />

Now my app will go on a machine (with installed SQL Server 2008) with the name VB-app which uses SQL authentication with usrnm and passin order to connect to the database. Any ideas what should I change in my connection string to accommodate the new properties?

podiluska · Accepted Answer · 2013-08-20 10:39:44Z

1

Replace

integrated security = true

with

User Id=usrnm;
Password=passin;

answered Aug 20, 2013 at 10:39

podiluska

51.6k7 gold badges102 silver badges105 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Wosh Over a year ago

can I have integratedSecurity = false followed by user name and password?

podiluska Over a year ago

@Andrez If you like, yes.

matthijsb · Accepted Answer · 2013-08-20 10:40:42Z

Remove integrated security=True;

and add

User Id=myUsername; Password=myPassword;

where you change myUsername and myPassoword to the right username & password

It will look like this:

<connectionStrings>
<add name="PicknickDBEntities"     
connectionString="metadata=res://*/Model.csdl|res://*/Model.ssdl|res://*/Model.msl;provider=System.Data.SqlClient;
provider connection string=&quot;
data source=**-**-**\SQLEXPRESS;
initial catalog=PicknickDB;
User Id=myUsername;
Password=myPassword;
MultipleActiveResultSets=True;
App=EntityFramework&quot;" 
providerName="System.Data.EntityClient" />

Collectives™ on Stack Overflow

ASP.NET MVC deployment problems with connection string

2 Answers 2

2 Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Related