Jean-Paul natola
jnatola at hotmail.com
Thu Mar 31 00:03:05 CDT 2011
its ok to the sql, it will occassionaly hit 700+ to the domain controller I ran netmon on the DC and did find auth issues kerberos krb_error kdc_err_s_principal_unknown 7 PS: everything is on one LAN single forest single domain Jean-Paul Natola > Date: Wed, 30 Mar 2011 20:03:52 -0700 > From: fhtapia at gmail.com > To: dba-sqlserver at databaseadvisors.com > Subject: Re: [dba-SQLServer] Authentication disconnects SSPI > > do you have a network admin to assist in troubleshooting? > > If not, try running a ping -t to the SQL server's ip, we may even need > to help rule out switches that are in between. > > Try using a machine that is on the same switch to help narrow down problems. > > On 3/30/11, Jean-Paul natola <jnatola at hotmail.com> wrote: > > > > > > all of them do, i wonder if its the DC or the SQL server > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > Jean-Paul Natola > > > > > > > > > > > > > >> From: fhtapia at gmail.com > >> Date: Wed, 30 Mar 2011 12:51:33 -0700 > >> To: dba-sqlserver at databaseadvisors.com > >> Subject: Re: [dba-SQLServer] Authentication disconnects SSPI > >> > >> I wouldn't think so it depends on if there is a problem with the > >> authentication certificate for that device as it is part of the 802.1x > >> security protocol, Do any of your other computers or users suffer from > >> the > >> same problem? > >> > >> > >> -Francisco > >> http://bit.ly/sqlthis | Tsql and More... > >> http://db.tt/JeXURAx | DropBox (get 2.2 gb of free online storage) > >> > >> > >> > >> > >> On Wed, Mar 30, 2011 at 11:00 AM, Jean-Paul natola > >> <jnatola at hotmail.com>wrote: > >> > >> > > >> > I dont know if this has something to do with it, but I noticed on teh > >> > NIC > >> > that the Enable IEEE auth is checked, could that be causing these > >> > random > >> > errors? > >> > > >> > > >> > > From: jnatola at hotmail.com > >> > > To: dba-sqlserver at databaseadvisors.com > >> > > Date: Wed, 30 Mar 2011 13:48:36 -0400 > >> > > Subject: [dba-SQLServer] Authentication disconnects SSPI > >> > > > >> > > > >> > > Hi all, > >> > > > >> > > Im running into an issue with users that ARE CURRENTLY connected to > >> > > SQL > >> > DB's . they are working when suddenly they get disconnected and have to > >> > to > >> > close ms access (front end) and re-open. > >> > > > >> > > the logs are showing 17806 (SSPI 80090311) and 18452 user not > >> > > associated > >> > with trusted SQL connection. > >> > > > >> > > This happens to random users at random time while they have been > >> > > working > >> > for hours > >> > > > >> > > any thoughts/suggestions/ would be apprecited > >> > > > >> > > > >> > > TIA > >> > > > >> > > J > >> > > > >> > > > >> > > > >> > > > >> > > _______________________________________________ > >> > > dba-SQLServer mailing list > >> > > dba-SQLServer at databaseadvisors.com > >> > > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver > >> > > http://www.databaseadvisors.com > >> > > > >> > > >> > _______________________________________________ > >> > dba-SQLServer mailing list > >> > dba-SQLServer at databaseadvisors.com > >> > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver > >> > http://www.databaseadvisors.com > >> > > >> > > >> _______________________________________________ > >> dba-SQLServer mailing list > >> dba-SQLServer at databaseadvisors.com > >> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver > >> http://www.databaseadvisors.com > >> > > > > _______________________________________________ > > dba-SQLServer mailing list > > dba-SQLServer at databaseadvisors.com > > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver > > http://www.databaseadvisors.com > > > > > > -- > Sent from my mobile device > > -Francisco > http://bit.ly/sqlthis | Tsql and More... > http://db.tt/JeXURAx | Drop Box, it's like a usb drive that's available > everywhere... > _______________________________________________ > dba-SQLServer mailing list > dba-SQLServer at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver > http://www.databaseadvisors.com >