[dba-SQLServer] Authentication disconnects SSPI

Francisco Tapia fhtapia at gmail.com
Wed Mar 30 14:51:33 CDT 2011


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
>
>



More information about the dba-SQLServer mailing list