Re: "could not accept SSPI security context" - Mailing list pgsql-general

Plase don't drop the mailinglist from the thread.


On Mon, Nov 22, 2010 at 11:57, Reto Schöning <reto.schoening@gmail.com> wrote:
> Thanks for the hint. The full error message from npgsql including that
> detail row is
> Npgsql.NpgsqlException was unhandled
>   Message="FATAL: XX000: could not accept SSPI security context"
>   Source="Npgsql"
>   ErrorCode=-2147467259
>   BaseMessage="could not accept SSPI security context"
>   Code="XX000"
>   Detail="The logon attempt failed\r\n (8009030c)"
>   ErrorSql=""
>   File=".\\src\\backend\\libpq\\auth.c"
>   Hint=""
>   Line="648"
>   Position=""
>   Routine="pg_SSPI_error"
>   Severity="FATAL"
>   Where=""
>   StackTrace:
>        at Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext()
> in C:\projects\Npgsql2\src\Npgsql\NpgsqlState.cs:line 686
>        at Npgsql.NpgsqlState.IterateThroughAllResponses(IEnumerable`1 ienum)
> in C:\projects\Npgsql2\src\Npgsql\NpgsqlState.cs:line 319
>        at Npgsql.NpgsqlState.ProcessBackendResponses(NpgsqlConnector
> context) in C:\projects\Npgsql2\src\Npgsql\NpgsqlState.cs:line 314
>        at Npgsql.NpgsqlConnectedState.Startup(NpgsqlConnector context) in
> C:\projects\Npgsql2\src\Npgsql\NpgsqlConnectedState.cs:line 52
>        at Npgsql.NpgsqlConnector.Open() in
> C:\projects\Npgsql2\src\Npgsql\NpgsqlConnector.cs:line 656
>        at Npgsql.NpgsqlConnectorPool.GetPooledConnector(NpgsqlConnection
> Connection) in C:\projects\Npgsql2\src\Npgsql\NpgsqlConnectorPool.cs:line
> 423
>        at
> Npgsql.NpgsqlConnectorPool.RequestPooledConnectorInternal(NpgsqlConnection
> Connection) in C:\projects\Npgsql2\src\Npgsql\NpgsqlConnectorPool.cs:line
> 226
>        at Npgsql.NpgsqlConnectorPool.RequestPooledConnector(NpgsqlConnection
> Connection) in C:\projects\Npgsql2\src\Npgsql\NpgsqlConnectorPool.cs:line
> 178
>        at Npgsql.NpgsqlConnectorPool.RequestConnector(NpgsqlConnection
> Connection) in C:\projects\Npgsql2\src\Npgsql\NpgsqlConnectorPool.cs:line
> 158
>        at Npgsql.NpgsqlConnection.Open() in
> C:\projects\Npgsql2\src\Npgsql\NpgsqlConnection.cs:line 543
>        at NpgsqlTest.Program.Main(String[] args) in C:\Documents and
> Settings\rsc\My Documents\Visual Studio
> 2005\Projects\NpgsqlTest\NpgsqlTest\Program.cs:line 17
> I found a way to reproduce the same message in psql: when creating a local
> user with the same name as a domain user, the connection attempt when logged
> in as that user fails with the same message (rightly so, of course).
> I've posted that in the npgsql forum also, no response yet.

The details row you're looking for is in the *server* side log.

--
 Magnus Hagander
 Me: http://www.hagander.net/
 Work: http://www.redpill-linpro.com/