jorton Absent Member.
Absent Member.
1033 views

MS SQL constant database connections

We are still having issues with our Server 2008 Zenworks database server's sql service crashing once in a while. Taking a look at the Windows logs (Application) we have noticed constant logins connecting to the database, like 50 a second. Yet there appears to be no logouts happening or connections closing. I am wondering if this is normal behavior for zenworks 11 SP3? The connections are mostly from our 3 primary servers. I would think the primary server would only need to open a connection to the database once, not for every transaction.

Message in Application log:
Source: MSSQL$ZCM; Event ID: 18454; Task Category: Logon
Login succeeded for user 'zensql'. Connection made using SQL Server authentication. [CLIENT: (ip address)]


Our setup:
1 Server2008 R2 x64 SQL database server
1 Server2008 R2 x64 Audit Server
3 Server 2012 primary servers
~2000 Win7 x64 computers using Zen.

Anyone have any ideas please let me know, and if there is any information I could provide I would be happy to.

Thanks
Labels (2)
0 Likes
2 Replies
Anonymous_User Absent Member.
Absent Member.

Re: MS SQL constant database connections

jorton,

It appears that in the past few days you have not received a response to your
posting. That concerns us, and has triggered this automated reply.

Has your problem been resolved? If not, you might try one of the following options:

- Visit http://www.novell.com/support and search the knowledgebase and/or check all
the other self support options and support programs available.
- You could also try posting your message again. Make sure it is posted in the
correct newsgroup. (http://forums.novell.com)

Be sure to read the forum FAQ about what to expect in the way of responses:
http://forums.novell.com/faq.php

If this is a reply to a duplicate posting, please ignore and accept our apologies
and rest assured we will issue a stern reprimand to our posting bot.

Good luck!

Your Novell Forums Team
http://forums.novell.com


0 Likes
Micro Focus Expert
Micro Focus Expert

Re: MS SQL constant database connections

jorton;2352430 wrote:
We are still having issues with our Server 2008 Zenworks database server's sql service crashing once in a while. Taking a look at the Windows logs (Application) we have noticed constant logins connecting to the database, like 50 a second. Yet there appears to be no logouts happening or connections closing. I am wondering if this is normal behavior for zenworks 11 SP3? The connections are mostly from our 3 primary servers. I would think the primary server would only need to open a connection to the database once, not for every transaction.

Message in Application log:
Source: MSSQL$ZCM; Event ID: 18454; Task Category: Logon
Login succeeded for user 'zensql'. Connection made using SQL Server authentication. [CLIENT: (ip address)]


Our setup:
1 Server2008 R2 x64 SQL database server
1 Server2008 R2 x64 Audit Server
3 Server 2012 primary servers
~2000 Win7 x64 computers using Zen.

Anyone have any ideas please let me know, and if there is any information I could provide I would be happy to.

Thanks


Not sure if your logging is different than my server, but I do not record any SUCCESSFUL logons in my event viewer, though I do see some failed ones for "Logon" (not a recurring issue...likely due to the fact I'm looking at a lab.)

Regarding Multiple Connections, that is normal. There may be dozens or hundreds of active connections to the DB from any given primary server.
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.