public void TestSqlConnection(DataBaseServer server) { string str = @"data source={servername};initial catalog={dabasename};Integrated Security=false; User ID={userid}; Password={password};"; str = str.Replace("{servername}", server.Machine.MachineName); str = str.Replace("{dabasename}", server.DataBaseName); AccessAccount acc = new AccessAccount(); if (server.DBAccount == null) { bGomlaDBreportEntities db = new bGomlaDBreportEntities(); acc = db.AccessAccounts.FirstOrDefault(x => x.AccountID == server.DataBaseAccountID); } else { acc = server.DBAccount; } str = str.Replace("{userid}", acc.AccountName); str = str.Replace("{password}", acc.AccountPassword); SqlConnection con = new SqlConnection(str); try { con.Open(); } catch (Exception e) { addError(e.Message); } }