MS SQL Server Connectivity

Author

error message

WISTONSQL

2006-03-21, 1:24 pm

Sometimes when developers try to access to the SQL Server by Enterprise
manager they get an error

"A connection can not be stablished to (local)
Reason: General network error. Check you network documentation.
ConnectionWriter (WrapperWrite ()).

Please verify SQL Server is running and check your SQL Server registration
properties"

I am getting the below error from the event viewer.
I have setup the maximum number of connection to be 3200. But I keep
getting this error continuosly since 8 days ago.

Event Type: Error
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17052
Date: 3/21/2006
Time: 1:04:44 PM
User: N/A
Computer: USKFIUSRYE
SQLD1
Description:
Error: 17809, Severity: 20, State: 1
Could not connect. The maximum number of '30' configured user connections
are already connected. The system administrator can change the maximum to a
higher value using sp_configure.
Data:
0000: 91 45 00 00 14 00 00 00 E......
0008: 10 00 00 00 55 00 53 00 ....U.S.
0010: 4b 00 46 00 49 00 55 00 K.F.I.U.
0018: 53 00 52 00 59 00 45 00 S.R.Y.E.
0020: 53 00 51 00 4c 00 44 00 S.Q.L.D.
0028: 31 00 00 00 00 00 00 00 1.......

Please let me know what should I do. I have spoken to the network people to
check the Server itself to see if there is any problem with the network
itself or hardware and they said everything is fine. I keep getting the
Developers to complaint about message above "A Connection can not be stablish"

Thanks all for your help

Sue Hoegemeier

2006-03-22, 3:23 am

Did you check the run_value using sp_configure? If you
changed the setting, the service requires a restart.

-Sue

On Tue, 21 Mar 2006 10:43:56 -0800, WISTONSQL
< WISTONSQL@discussion
s.microsoft.com> wrote:

>Sometimes when developers try to access to the SQL Server by Enterprise
>manager they get an error
>
>"A connection can not be stablished to (local)
>Reason: General network error. Check you network documentation.
>ConnectionWriter (WrapperWrite ()).
>
>Please verify SQL Server is running and check your SQL Server registration
>properties"
>
>I am getting the below error from the event viewer.
>I have setup the maximum number of connection to be 3200. But I keep
>getting this error continuosly since 8 days ago.
>
>Event Type: Error
>Event Source: MSSQLSERVER
>Event Category: (2)
>Event ID: 17052
>Date: 3/21/2006
>Time: 1:04:44 PM
>User: N/A
> Computer: USKFIUSRYE
SQLD1
>Description:
>Error: 17809, Severity: 20, State: 1
>Could not connect. The maximum number of '30' configured user connections
>are already connected. The system administrator can change the maximum to a
>higher value using sp_configure.
>Data:
>0000: 91 45 00 00 14 00 00 00 ?E......
>0008: 10 00 00 00 55 00 53 00 ....U.S.
>0010: 4b 00 46 00 49 00 55 00 K.F.I.U.
>0018: 53 00 52 00 59 00 45 00 S.R.Y.E.
>0020: 53 00 51 00 4c 00 44 00 S.Q.L.D.
>0028: 31 00 00 00 00 00 00 00 1.......
>
>Please let me know what should I do. I have spoken to the network people to
>check the Server itself to see if there is any problem with the network
>itself or hardware and they said everything is fine. I keep getting the
>Developers to complaint about message above "A Connection can not be stablish"
>
>Thanks all for your help

WISTONSQL

2006-03-22, 8:24 pm

Hi Sue:

Thanks for your response,
Yes, I reboot the system couple times and still I am having the problem,
today the problem became worst. I am going to deploy SQL Server SP4 - What do
you think?

"Sue Hoegemeier" wrote:

> Did you check the run_value using sp_configure? If you
> changed the setting, the service requires a restart.
>
> -Sue
>
> On Tue, 21 Mar 2006 10:43:56 -0800, WISTONSQL
> < WISTONSQL@discussion
s.microsoft.com> wrote:
>
>
>

Sue Hoegemeier

2006-03-26, 1:23 pm

When you get the error:
Could not connect. The maximum number of '30' configured
user connections are already connected.
you really should run sp_configure to view what you actually
have set for user connections.
If you have been adjusting settings, you may want to make
sure you really have everything set back to the defaults.
The help topic: Setting Configuration Options
lists all the settings and the defaults.

-Sue

On Wed, 22 Mar 2006 16:33:27 -0800, WISTONSQL
< WISTONSQL@discussion
s.microsoft.com> wrote:
[color=darkred]
>Hi Sue:
>
>Thanks for your response,
>Yes, I reboot the system couple times and still I am having the problem,
>today the problem became worst. I am going to deploy SQL Server SP4 - What do
>you think?
>
>"Sue Hoegemeier" wrote:
>

Sponsored Links