all groups > sql server new users > april 2007 >
You're in the

sql server new users

group:

SQL 2005 - Error 18059


SQL 2005 - Error 18059 Bryce Ingalls
4/24/2007 11:10:30 AM
sql server new users:
Hello--

Recently installed SQL Server 2005 Std. Ed. on Windows Server 2003 SP1.
Server is AD domain controller. Tried installing SP2 for SQL 2005--no
difference. Am seeing this error over and over:

The connection has been dropped because the principal that opened it
subsequently assumed a new security context, and then tried to reset the
connection under its impersonated security context. This scenario is not
supported. See "Impersonation Overview" in Books Online.

Error: 18059, Severity: 20, State: 1.



I was not able to find much online re: the issue. SQL newbie would
appreciate any suggestions.



Bryce

Re: SQL 2005 - Error 18059 Russell Fields
4/24/2007 3:42:15 PM
Bryce,

Is your application using an Application Role? If so, it might be a problem
with connection pooling, as described in this thread.
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=473777&SiteID=1

The original poster solved his problem by turning off connection pooling
with an application role.

RLF
[quoted text, click to view]

Re: SQL 2005 - Error 18059 Bryce Ingalls
4/26/2007 8:35:46 AM
That did it. Thanks Russell.

[quoted text, click to view]

AddThis Social Bookmark Button