My solution what thanks to venkateshCST:
He told me to change my appsetting connectionstring within the web.config to be:
<add key="Award_Management2ConnectionString1" value="SERVER=(serverName);DATABASE=(DB name);UID=(userID);PASSWORD=(password)"/>
He also told me to change;
In places where I had -
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["Award_Management2ConnectionString1"].ConnectionString);
SqlConnection con = ConfigurationSettings.AppSettings["Award_Management2ConnectionString1"].ToString();
sqlconnection con=new sqlconnection(constring);
con.Open();
To -
string constring = ConfigurationManager.AppSettings["Award_Management2ConnectionString1"].ToString();
SqlConnection con = new SqlConnection(constring);
con.Open();