[dba-SQLServer] Authentication disconnects SSPI

Francisco Tapia fhtapia at gmail.com
Wed Mar 30 22:03:52 CDT 2011


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



More information about the dba-SQLServer mailing list