[dba-SQLServer] Authentication disconnects SSPI

it think it ,  but is the loss workstations to SQl, workstations to DC or SQL to DC
 

 

 

 

 

 

 

 

 

 

Jean-Paul Natola

 




> From: stuart at lexacorp.com.pg
> To: dba-sqlserver at databaseadvisors.com
> Date: Thu, 31 Mar 2011 06:10:52 +1000
> Subject: Re: [dba-SQLServer] Authentication disconnects SSPI
> 
> Sounds like a networking problem - losing their network connection temporarily.
> -- 
> Stuart 
> 
> 
> On 30 Mar 2011 at 13:48, Jean-Paul natola wrote:
> 
> > 
> > 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
>