[dba-SQLServer] Authentication disconnects SSPI

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
> 
 		 	   		  


More information about the dba-SQLServer mailing list