March 24, 2004 at 5:39 pm
Hey!
About once a day our production Windows 2003 - SQL 2000 SP3a machine has its user connections skyrocket to about 200 almost instantly. This is after an entire day of hovering around 60.
The machine is a quad Xeon 1.4 w/ 6GB of RAM. SQL is the only thing running on the server. The webs connect via TCP only.
The machine is super busy all day with usage peak at around 2:00PM. The user connections skyrocket at around 7:00PM (although it is quite unpredictable... sometimes its at like 10AM which is also not peak) which is long after everything has calmed down for the day.
Our web machines that are hitting the SQL machine get the error:
Login failed for user 'user'. Reason: Not associated with a trusted SQL Server connection.
This is after hours and hours of accessing it exactly the same, and when we reset our webmachines, they can again access the DB exactly as they had before, and the user connections return back down to about 60.
Any idea what would cause the connections to go up like this, and then deny access?
Thanks for any advice!
Paul Cassar
March 24, 2004 at 6:24 pm
March 24, 2004 at 6:30 pm
Hey!
Thanks for the response!
Unfortunately this SQL is set to use both Windows & SQL authentication already, as if it wasnt then the connections would never work.
Connections work flawlessly 99.99% of the time, but every once in a while (about once a day) we get a flood of these errors. Unless SQL is somehow changing this setting, and then quickly changing it back, this is not the cause.
March 24, 2004 at 7:16 pm
Paul,
How are you connecting to the database. i mean do you connect through a Trusted_connection or SQL Authentication ? And whta is your connection string and from where are you calling it?
I came across a simillar issue below but not sure if it is relevant.
March 25, 2004 at 10:15 am
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply