ASP.NET MVC Code First Entity Framework MS SQL Connection String multiple areas
I have developed a an ASP.NET MVC code first application. I have gotten it to deploy using web deploy publishing from visual studio 2017. The sections that are not connected to the database run well. The pages that need to access the DB do not run and I get a SQL Connection Error.
SqlException (0x80131904): A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible.
Which leads me to believe it is a connection string issue. I have been trying multitudes of variations of connection strings I have found online, for almost a week, with no success. Also, it is split into multiple areas within the applications, locally that doesn't matter but I'm not sure if that has any impact during deployment.
ASP.NET MVC, Entity Framework, MS SQL, Multiple areas.
I am in dire need of a working connection string example.