CODEWITHSUNDEEP
.netentity-frameworkdatabase-connectionconnection-string
blair260
blair260

Reputation: 309

Entity Framework Authentication Provider - Update Default Connection

I've moved my .mdf to the production sql server database but when I update my "defaultconnection" connection string the authentication provider throws an error. My connection string is <add name="DefaultConnection" connectionString="Data Source=(LocalDb)\v11.0;Initial Catalog=aspnet-MvcApplication1-20181218212041;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|\aspnet-MvcApplication1-20181218212041.mdf" providerName="System.Data.SqlClient" />

This has to be an easy fix. Can someone let me know what needs to be here now that I have moved the production database to my production sql. This is NOT SQLExpress. Thanks!

Upvotes: 1

Views: 68

Answers (1)

TanvirArjel
TanvirArjel

Reputation: 32059

Then your ConnectionString should be as like as follows:

<add name="DefaultConnection" connectionString="Data Source= YourServerName\YourSqlServerInstanceName;Initial Catalog=YourDatabaseName;Integrated Security=False;User Id=YourUsername;
Password=YourPassword; providerName="System.Data.SqlClient" />

Upvotes: 1

Related Questions