[dba-SQLServer] Authentication disconnects SSPI

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
>