Error: 17806, Severity: 20, State: 2

We installed SQL Server 2005 Std Ed and MSProject application uses the instance..

Getting following Eorr Message

SSPI handshake failed with error code 0x80090311 while establishing a connection with integrated security; the connection has been closed. [CLIENT: <named pipe>]

Appreciate your help to fix this

Thanks

Arul

This is an SSIS forum. Try here for Project - http://www.microsoft.com/office/community/en-us/default.mspx

|||Hi,

1.) Mention the servername in FQDN format or use ip address. This may be due to Named pipes
2.) Try changing the protocols, its better to use TCP/IP port. Try connect using servername,portnumber

Error: 17803, Severity: 20, State: 17

I have an application connected to a machine running MSSQL Server 2000 SP3a
Std Edition. Machine is 2.8GHZ, Windows Server 2000. This application runs
extensive query periodically. Over a period of time, I notice through Task
Manager the sqlservr.exe memory usage has grow to ~1.6GB. When this happen,
the application experience slowdown and eventually hang out.
SQL ERRORLog show
2005-04-22 07:16:36.45 spid1 LazyWriter: warning, no free buffers found.
2005-04-22 07:16:36.45 spid1 Buffer Distribution: Stolen=159182 Free=0
Procedures=22931
Inram=0 Dirty=24545 Kept=0
I/O=0, Latched=2022, Other=0
2005-04-22 07:16:36.45 spid1 Buffer Counts: Commited=208680
Target=208680 Hashed=26567
InternalReservation=2130 ExternalReservation=57 Min Free=512
2005-04-22 07:16:36.45 spid1 Procedure Cache: TotalProcs=3969
TotalPages=22931 InUsePages=22931
2005-04-22 07:16:36.45 spid1 Dynamic Memory Manager: Stolen=182112 OS
Reserved=2544
OS Committed=2487
OS In Use=2468
Query Plan=166599 Optimizer=3
General=14803
Utilities=7 Connection=2910
2005-04-22 07:16:36.45 spid1 Global Memory Objects: Resource=11637
Locks=147
SQLCache=1236 Replication=2
LockBytes=2 ServerGlobal=43
Xact=1862
2005-04-22 07:16:36.45 spid1 Query Memory Manager: Grants=1 Waiting=0
Maximum=13450 Available=13392
2005-04-22 07:16:36.70 server Error: 17803, Severity: 20, State: 17
2005-04-22 07:16:36.70 server Insufficient memory available..
I'm currently using SQL Server 2000 Driver for JDBC (with
SelectMethod=Cursor). From SQL Profiler, I do see alot of sp_cursorfetch
calls that don't have a corresponding sp_cursorclose.
Help is greatly appreaciated here!SQL ran out of free buffers (Free=0). You should probably apply the latest
SQL Server hotfix and update JDBC drivers to prevent problems such as 818095
and 837957. In addition, there are changes in the latest SQL hotfixes which
allow Lazy Writer to run more aggressively when it detects a low number of
free buffers.
If the problems persist engage MS product support and have them check your
server for additional leaks.
Adrian
"SS" <SS@.discussions.microsoft.com> wrote in message
news:884EB064-D4C5-4454-A8B4-A151EBC0ED11@.microsoft.com...
>I have an application connected to a machine running MSSQL Server 2000 SP3a
> Std Edition. Machine is 2.8GHZ, Windows Server 2000. This application runs
> extensive query periodically. Over a period of time, I notice through Task
> Manager the sqlservr.exe memory usage has grow to ~1.6GB. When this
> happen,
> the application experience slowdown and eventually hang out.
> SQL ERRORLog show
> 2005-04-22 07:16:36.45 spid1 LazyWriter: warning, no free buffers
> found.
> 2005-04-22 07:16:36.45 spid1 Buffer Distribution: Stolen=159182
> Free=0
> Procedures=22931
> Inram=0 Dirty=24545 Kept=0
> I/O=0, Latched=2022, Other=0
> 2005-04-22 07:16:36.45 spid1 Buffer Counts: Commited=208680
> Target=208680 Hashed=26567
> InternalReservation=2130 ExternalReservation=57 Min Free=512
> 2005-04-22 07:16:36.45 spid1 Procedure Cache: TotalProcs=3969
> TotalPages=22931 InUsePages=22931
> 2005-04-22 07:16:36.45 spid1 Dynamic Memory Manager: Stolen=182112 OS
> Reserved=2544
> OS Committed=2487
> OS In Use=2468
> Query Plan=166599 Optimizer=3
> General=14803
> Utilities=7 Connection=2910
> 2005-04-22 07:16:36.45 spid1 Global Memory Objects: Resource=11637
> Locks=147
> SQLCache=1236 Replication=2
> LockBytes=2 ServerGlobal=43
> Xact=1862
> 2005-04-22 07:16:36.45 spid1 Query Memory Manager: Grants=1 Waiting=0
> Maximum=13450 Available=13392
> 2005-04-22 07:16:36.70 server Error: 17803, Severity: 20, State: 17
> 2005-04-22 07:16:36.70 server Insufficient memory available..
> I'm currently using SQL Server 2000 Driver for JDBC (with
> SelectMethod=Cursor). From SQL Profiler, I do see alot of sp_cursorfetch
> calls that don't have a corresponding sp_cursorclose.
> Help is greatly appreaciated here!
>

Error, when alter table

Hi,
on a SQL Server 200 installed on a Win2003 Std. Server, we get an error in a
ny Databse when trying to 'alter table'
The error says something like 'Cursor not vaild' or in German 'Ungueltiger C
ursorstatus'
Any ideas?
Thanks in advanceDid you try running an explicit ALTER TABLE statement in Query Analyzer,
instead of making changes using Enterprise Manager?
http://www.aspfaq.com/2515
http://www.aspfaq.com/
(Reverse address to reply.)
"DOKOM@.community.nospam" <DOKOM@.community.nospam@.discussions.microsoft.com>
wrote in message news:A51F71F0-A5DD-43B9-B849-B3B26759C929@.microsoft.com...
> Hi,
> on a SQL Server 200 installed on a Win2003 Std. Server, we get an error in
any Databse when trying to 'alter table'
> The error says something like 'Cursor not vaild' or in German 'Ungueltiger
Cursorstatus'
> Any ideas?
> Thanks in advance|||Hi again,
your suggestions work fine with the QueryAnalyzer. But beside that, we are f
acing the problem, that some asp-Scripts do not work when performing a 'rs.U
pdate'
They show error: (80040e23) 'Cursor operation conflict'
The Scripts worked fine before.
"Aaron [SQL Server MVP]" wrote:

> Did you try running an explicit ALTER TABLE statement in Query Analyzer,
> instead of making changes using Enterprise Manager?
> http://www.aspfaq.com/2515
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>
> "DOKOM@.community.nospam" <DOKOM@.community.nospam@.discussions.microsoft.com
> wrote in message news:A51F71F0-A5DD-43B9-B849-B3B26759C929@.microsoft.com..
.
> any Databse when trying to 'alter table'
> Cursorstatus'
>
>|||> some asp-Scripts do not work when performing a 'rs.Update'
Call a stored procedure or use an UPDATE statement to perform an update.
Don't use a heavy, lock-intensive recordset object...
http://www.aspfaq.com/2191
http://www.aspfaq.com/
(Reverse address to reply.)|||That might be true, but the Scripts workes on our 'old' Server.
The only thing we want is the scripts running in the 'new' environment.
We will not change everything because of some bad SQL-Patches.
If it is the only chance I'd prefer installing a new instance of the SQL-Ser
ver without the above mentioned Patch.
"Aaron [SQL Server MVP]" wrote:

> Call a stored procedure or use an UPDATE statement to perform an update.
> Don't use a heavy, lock-intensive recordset object...
> http://www.aspfaq.com/2191
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>|||That might be true, but the Scripts workes on our 'old' Server.
The only thing we want is the scripts running in the 'new' environment.
We will not change everything because of some bad SQL-Patches.
If it is the only chance I'd prefer installing a new instance of the SQL-Ser
ver without the above mentioned Patch.
"Aaron [SQL Server MVP]" wrote:

> Call a stored procedure or use an UPDATE statement to perform an update.
> Don't use a heavy, lock-intensive recordset object...
> http://www.aspfaq.com/2191
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>|||> If it is the only chance I'd prefer installing a new instance of the
SQL-Server without the above mentioned Patch.
Did you actually read the whole article I referenced? Here it is again,
just in case:
http://www.aspfaq.com/2515
http://www.aspfaq.com/
(Reverse address to reply.)

Error, when alter table

Hi,
on a SQL Server 200 installed on a Win2003 Std. Server, we get an error in any Databse when trying to 'alter table'
The error says something like 'Cursor not vaild' or in German 'Ungueltiger Cursorstatus'
Any ideas?
Thanks in advanceDid you try running an explicit ALTER TABLE statement in Query Analyzer,
instead of making changes using Enterprise Manager?
http://www.aspfaq.com/2515
--
http://www.aspfaq.com/
(Reverse address to reply.)
"DOKOM@.community.nospam" <DOKOM@.community.nospam@.discussions.microsoft.com>
wrote in message news:A51F71F0-A5DD-43B9-B849-B3B26759C929@.microsoft.com...
> Hi,
> on a SQL Server 200 installed on a Win2003 Std. Server, we get an error in
any Databse when trying to 'alter table'
> The error says something like 'Cursor not vaild' or in German 'Ungueltiger
Cursorstatus'
> Any ideas?
> Thanks in advance|||> some asp-Scripts do not work when performing a 'rs.Update'
Call a stored procedure or use an UPDATE statement to perform an update.
Don't use a heavy, lock-intensive recordset object...
http://www.aspfaq.com/2191
--
http://www.aspfaq.com/
(Reverse address to reply.)|||> If it is the only chance I'd prefer installing a new instance of the
SQL-Server without the above mentioned Patch.
Did you actually read the whole article I referenced? Here it is again,
just in case:
http://www.aspfaq.com/2515
--
http://www.aspfaq.com/
(Reverse address to reply.)

Error, when alter table

Hi,
on a SQL Server 200 installed on a Win2003 Std. Server, we get an error in any Databse when trying to 'alter table'
The error says something like 'Cursor not vaild' or in German 'Ungueltiger Cursorstatus'
Any ideas?
Thanks in advance
Did you try running an explicit ALTER TABLE statement in Query Analyzer,
instead of making changes using Enterprise Manager?
http://www.aspfaq.com/2515
http://www.aspfaq.com/
(Reverse address to reply.)
"DOKOM@.community.nospam" <DOKOM@.community.nospam@.discussions.microsoft.com>
wrote in message news:A51F71F0-A5DD-43B9-B849-B3B26759C929@.microsoft.com...
> Hi,
> on a SQL Server 200 installed on a Win2003 Std. Server, we get an error in
any Databse when trying to 'alter table'
> The error says something like 'Cursor not vaild' or in German 'Ungueltiger
Cursorstatus'
> Any ideas?
> Thanks in advance
|||Hi again,
your suggestions work fine with the QueryAnalyzer. But beside that, we are facing the problem, that some asp-Scripts do not work when performing a 'rs.Update'
They show error: (80040e23) 'Cursor operation conflict'
The Scripts worked fine before.
"Aaron [SQL Server MVP]" wrote:

> Did you try running an explicit ALTER TABLE statement in Query Analyzer,
> instead of making changes using Enterprise Manager?
> http://www.aspfaq.com/2515
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>
> "DOKOM@.community.nospam" <DOKOM@.community.nospam@.discussions.microsoft.com>
> wrote in message news:A51F71F0-A5DD-43B9-B849-B3B26759C929@.microsoft.com...
> any Databse when trying to 'alter table'
> Cursorstatus'
>
>
|||> some asp-Scripts do not work when performing a 'rs.Update'
Call a stored procedure or use an UPDATE statement to perform an update.
Don't use a heavy, lock-intensive recordset object...
http://www.aspfaq.com/2191
http://www.aspfaq.com/
(Reverse address to reply.)
|||That might be true, but the Scripts workes on our 'old' Server.
The only thing we want is the scripts running in the 'new' environment.
We will not change everything because of some bad SQL-Patches.
If it is the only chance I'd prefer installing a new instance of the SQL-Server without the above mentioned Patch.
"Aaron [SQL Server MVP]" wrote:

> Call a stored procedure or use an UPDATE statement to perform an update.
> Don't use a heavy, lock-intensive recordset object...
> http://www.aspfaq.com/2191
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>
|||That might be true, but the Scripts workes on our 'old' Server.
The only thing we want is the scripts running in the 'new' environment.
We will not change everything because of some bad SQL-Patches.
If it is the only chance I'd prefer installing a new instance of the SQL-Server without the above mentioned Patch.
"Aaron [SQL Server MVP]" wrote:

> Call a stored procedure or use an UPDATE statement to perform an update.
> Don't use a heavy, lock-intensive recordset object...
> http://www.aspfaq.com/2191
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>
|||> If it is the only chance I'd prefer installing a new instance of the
SQL-Server without the above mentioned Patch.
Did you actually read the whole article I referenced? Here it is again,
just in case:
http://www.aspfaq.com/2515
http://www.aspfaq.com/
(Reverse address to reply.)