473,542 Members | 2,548 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

SQL 6.5 server connection problem

3 New Member
Problem description
==============
- I have 4 clients and 1 server (SQL server)
- 3 clients are Monitoring console 1 client is operation console
- Monitoring console collects some data from the control unit and
store them into the Sql server
- The operation console then retrieve this data from the sql for
reporting and statistics purposes
- I am using ODBC connection
- The problem is that the operation console is not able to connect to
Sql server
- I receive Error message: “A connection could not be established to
fileserver-(SQL server). Unable to connect. The max number of 15 configured
user connections are already connected. System administrator can configure to
a higher value with SP_Configure”
- I receive the same error message in many conditions while I am using
the EM (Enterprise Manager) GUI

Environment
========
Windows NT 4.0
SQL 6.5

Troubleshooting (we have done & Analysis)
=====
- Seems that sql server has reached the max allowable number of
connections
- It might be some opened connection those never being closed by some
application.
- This problem also appears when 7.5 installed while 6.5 is also
installed, however I don’t have 7.5 installed
- We tried to perform:
Exec sp_configure ‘user connections’, 25
Go
RECONFIGURE
Go

And then try to restart the sql server

- I was unable to execute the above steps as I was receiving time out
- Unable to stop/restart Sql server, I had to reboot to start sql
server (I was being interrupted with the error message again)
- Check sql configuration parameters from EM, I checked:
1. “conn time out” : reasonable values for Min, Max and running
2. “worker threads”: reasonable values for Min, Max and running
3. “user connections”: reasonable values for Min, Max and running
- Seems no problem with configuration parameters (the major ones
related to the symptoms we have at least)
- Also we performed restar for sql server service through the
rebooting with no impact on the problem
- We tried to truncate the log file of the database as I suspected it
causes a problem, we performed the following procedure:
Backup LOG <your database name> with truncate_only
- Try to restart your sql server, no avail
- We checked scheduled tasks, as you mentioned that this problem
started to appear three weeks ago and I noted that when I restart the sql
server or stop the clients the problem disappears but reoccurs each Sunday,
we found one scheduled task which configured to run in the exact same time (on
Sunday) however you added that restarting your server is no more effective
to temporary solve the problem as before (and this is obvious through our
trials above to restart the server)
- We tried to remove that schedule task and then restart as it might
be the cause of the problem
- I was unable to remove the scheduled task, and I received another
error message related to Sql server!!
- While we were performing the above steps, I have been interrupted
with the same error message while I am using the query analyzer
- The server looks to be in very unstable state, so I need some
recommendations to fix the problem as mentioned bove.


Further work done:

I've tried to change the user connections to 0, which means unlimited connections are going to be accepted by SQL server, I found the error message was no more active for a long period before it
reactivated again at the end but with connections user 25! Through that time
I've received the following messages

"A connection could not be established to fileserver - (DB-Library) SQL
server connection Timed out".

"SQL server connection time out. Do you wish to retry?

"ERROR 10024 (DB Library) SQL server connection time out"

Msg No 10007 Severity 5 State 0. General SQL server error.



Here some more problem clarification that it could help fixing the problem

- The working data base is marked inaccessible and cannot be edited

- The following message appears when restart the server and before login

"The application log file is full".
Sep 17 '07 #1
1 5104
k4012656
11 New Member
Problem description
==============
- I have 4 clients and 1 server (SQL server)
- 3 clients are Monitoring console 1 client is operation console
- Monitoring console collects some data from the control unit and
store them into the Sql server
- The operation console then retrieve this data from the sql for
reporting and statistics purposes
- I am using ODBC connection
- The problem is that the operation console is not able to connect to
Sql server
- I receive Error message: “A connection could not be established to
fileserver-(SQL server). Unable to connect. The max number of 15 configured
user connections are already connected. System administrator can configure to
a higher value with SP_Configure”
- I receive the same error message in many conditions while I am using
the EM (Enterprise Manager) GUI

Environment
========
Windows NT 4.0
SQL 6.5

Troubleshooting (we have done & Analysis)
=====
- Seems that sql server has reached the max allowable number of
connections
- It might be some opened connection those never being closed by some
application.
- This problem also appears when 7.5 installed while 6.5 is also
installed, however I don’t have 7.5 installed
- We tried to perform:
Exec sp_configure ‘user connections’, 25
Go
RECONFIGURE
Go

And then try to restart the sql server

- I was unable to execute the above steps as I was receiving time out
- Unable to stop/restart Sql server, I had to reboot to start sql
server (I was being interrupted with the error message again)
- Check sql configuration parameters from EM, I checked:
1. “conn time out” : reasonable values for Min, Max and running
2. “worker threads”: reasonable values for Min, Max and running
3. “user connections”: reasonable values for Min, Max and running
- Seems no problem with configuration parameters (the major ones
related to the symptoms we have at least)
- Also we performed restar for sql server service through the
rebooting with no impact on the problem
- We tried to truncate the log file of the database as I suspected it
causes a problem, we performed the following procedure:
Backup LOG <your database name> with truncate_only
- Try to restart your sql server, no avail
- We checked scheduled tasks, as you mentioned that this problem
started to appear three weeks ago and I noted that when I restart the sql
server or stop the clients the problem disappears but reoccurs each Sunday,
we found one scheduled task which configured to run in the exact same time (on
Sunday) however you added that restarting your server is no more effective
to temporary solve the problem as before (and this is obvious through our
trials above to restart the server)
- We tried to remove that schedule task and then restart as it might
be the cause of the problem
- I was unable to remove the scheduled task, and I received another
error message related to Sql server!!
- While we were performing the above steps, I have been interrupted
with the same error message while I am using the query analyzer
- The server looks to be in very unstable state, so I need some
recommendations to fix the problem as mentioned bove.


Further work done:

I've tried to change the user connections to 0, which means unlimited connections are going to be accepted by SQL server, I found the error message was no more active for a long period before it
reactivated again at the end but with connections user 25! Through that time
I've received the following messages

"A connection could not be established to fileserver - (DB-Library) SQL
server connection Timed out".

"SQL server connection time out. Do you wish to retry?

"ERROR 10024 (DB Library) SQL server connection time out"

Msg No 10007 Severity 5 State 0. General SQL server error.



Here some more problem clarification that it could help fixing the problem

- The working data base is marked inaccessible and cannot be edited

- The following message appears when restart the server and before login

"The application log file is full".







heya!
ur sql server is not properly installed that's why u can't connect with others...like u we have 1 server and 4 client computers but it is working properly....if error appears your IP adressing and network setup is not properly!try to reinstall it and see for networking setup properly.......
we are using version 6.5 too..
Sep 18 '07 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

4
1275
by: Savas Ates | last post by:
"SQL Server does not exist or access denied" sql server error:17 i cant connect sql Server 2000 why?
9
6548
by: Niyazi | last post by:
Hi, I can connect using my PC local SQL Server Enterprise manager to Remote SQL Server. But I cannot connect using my Connection string? strConn = "Data Source=190.168.0.97,1433;Network Library=DBMSSOCN;Initial Catalog=DBANK;User ID=myID;Password=myPASSWORD;" Does anyone knows any idea?
4
2062
by: Brian Henry | last post by:
I an trying to connect to a sql server in asp.net with the sql connection object, and every time i try to open the connection i get this Server Error in '/' Application. Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection. why am i getting this? and how do i get around it? I am logged into the...
5
1334
by: Justin Ray | last post by:
I've created an ASP.NET application that runs on my local IIS server. It needs to connect to a SQL Server database on a different machine. The SQL server is setup for "mixed mode" authentication. As you can tell from the connection string in the following code, I am using SQL Authentication. Dim sConn As String = "Data...
3
1700
by: Marcos Beccar Varela | last post by:
Hello, does anyone knows how to make a SQL Server connection from a string not using the "wizard"? I have various reports and I need to make a connection that when the parameters are changed in that string, all connections in reports change too. Thank you and sorry for my english!
17
9194
by: Danieltbt05 | last post by:
just installed SQL server 2000 and using my client , i can't locate the server. I used SQL query analyzer to search but no servers were found. Error message is as below Server : Msg17,level 16, state1 SQL server does not exist or denied access.
1
1948
by: BobLewiston | last post by:
I’m trying to learn how to connect to an SQL Server database (I’m using the AdventureWorks sample database), but I’m having problems. Here’s the code I’m using: // define connection string for database server string connectionString = "server=<server name>; database=AdventureWorks; uid=<user name>; pwd=;"; // no password // define...
10
4206
by: Elaine121 | last post by:
Hi i've been batteling for hours and can't seem to find the problem. When my server runs and I press the connect button the gui freezes until the client gui is terminated.. only then the gui becomes active again and displays the messages. Here is my server code: import java.io.*; import java.net.*; public class serverForm extends...
0
7322
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
7718
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
1
7316
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
7665
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
0
5862
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
1
5239
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
4878
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
1
1790
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
1
941
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.