I has and old web application begin with windows 2000 and SQL 200. Then Windows 2003 and SQL 2005. In the 2 scenarios I change in this string the data source (server name and the password and then work fine.
Application("ConnectionString") = "Provider=SQLOLEDB;Data Source=Server1;Initial Catalog=EvaluacionesDatabase;User ID=sa;Password=xxxxxxxxx ;";
Application("Header") = ""
Now we have windows 2012R2 server and SQL server 2014. I try first change the data source and password but didn't work. Then try various strings changes but didn't work.
Did Everyone know the correct string for SQL2014??