Add this in web.config file
<connectionStrings>
<add name="TestConnStr" connectionString="Data Source=bla.bla.global;Initial Catalog=TestDataBaseName;Persist Security Info=True;User ID=UserId;Password=Password" providerName="System.Data.SqlClient" />
</connectionStrings>
Add this code block into your dataaccess layer
using System.Data.SqlClient;
using System.Configuration;
string StrConn = ConfigurationManager.ConnectionStrings["TestConnStr"].ConnectionString;
sqlConn = new SqlConnection(StrConn);
SqlCommand comm = new SqlCommand("SP_TestStoredProc", sqlConn);
comm.CommandType = CommandType.StoredProcedure;
sqlConn.Open();
SqlDataReader rdr = comm.ExecuteReader();
while (rdr.Read())
{
}
sqlConn.close();