connection Translation into dataAdapter

I use a dataSet, in which I have 3 DataTableAdapter. I would like to update the content in the db through a single transaction. the first time it runs and then throws me an exception

    internal static LottoTableAdapter LottoTA = new LottoTableAdapter();
    internal static QuotazioniVinciteTableAdapter QuotazioniVinciteTA = new QuotazioniVinciteTableAdapter();
    internal static LottoPalleTableAdapter LottoPalleTA = new LottoPalleTableAdapter();
    internal static string connectionDb = Properties.Resources.MyConnectionString.Replace("|DataDirectory|", System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase)).Replace("file:\\", "");
    internal static LottoDs _DsLotto = new LottoDs();
 private static void UpdateDb()
        {
            try
            {
                using (SqlConnection myConnection = new SqlConnection(connectionDb))
                {
                    myConnection.Open();

                    LottoTA.Connection = myConnection;
                    LottoPalleTA.Connection = myConnection;
                    QuotazioniVinciteTA.Connection = myConnection;

                    using (SqlTransaction Tr = myConnection.BeginTransaction("UpTran"))
                    {
                        LottoTA.Update(_DsLotto);
                        LottoPalleTA.Update(_DsLotto);
                        QuotazioniVinciteTA.Update(_DsLotto);
                        Tr.Commit();

                    }
                    LottoTA.Fill(_DsLotto.Lotto);
                    LottoPalleTA.Fill(_DsLotto.LottoPalle);
                    QuotazioniVinciteTA.Fill(_DsLotto.QuotazioniVincite);
                    myConnection.Close();
                }
                _DsLotto.Lotto.AcceptChanges();//in questa maniera non aggiorno più quelle nuove
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.ToString());
            }
        }

exception: {"A connection was successfully established with the server, but then an error occurred during the login process. (provider: Named Pipes Provider, error: 0 - Nessun altro processo all'altra estremità della pipe.)"}

enter image description here