For Programmers: Free Programming Magazines  


Home > Archive > ASP > November 2005 > Re: SQL Server does not exist or access denied.









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Re: SQL Server does not exist or access denied.
alorentz

2005-11-17, 6:55 pm

To clarify answer:

Connection pooling was disabled for security reasons, so you need to
add registry keys specified in article here:


path:
HKEY_LOCAL_MACHINE\System\CurrentControl
Set\services\Tcpip\Parameters


type: DWORD
name: TcpTimedWaitDelay
value: 30 (decimal)


type: DWORD
name: MaxUserPort
value: 10000 (decimal)


Ultimately is connection pooling is enabled this shouldn't happen, but
try it anyway. Check netsats from command prompt....if you see around
4000 connections in TIME_WAIT, then that is the problem.

Sponsored Links







Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive

Copyright 2008 codecomments.com