Jean-Paul natola
jnatola at hotmail.com
Tue Apr 5 08:59:21 CDT 2011
I updated the NIC drivers on teh SQL and the DC and ping times are back to <1ms, and there have been no disconnectst since, however, i still do get the occassional S_Princicpal_unknown , any idea how to address that? Jean-Paul Natola > From: jnatola at hotmail.com > To: dba-sqlserver at databaseadvisors.com > Date: Thu, 31 Mar 2011 01:03:05 -0400 > Subject: Re: [dba-SQLServer] Authentication disconnects SSPI > > > 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 > > > > _______________________________________________ > dba-SQLServer mailing list > dba-SQLServer at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver > http://www.databaseadvisors.com >