hi ~~
the error happening…again…
it is occuring randomly…
Please help us … ;(
Ted
I am spending most of my time working on it today, trying to isolate users using 20+ logins (a sign of not closing connections)
Any update ?
Still the same here…
MM
I am manually changing some things, it is taking a while, and will be quite a while longer.
[QUOTE=Stephen]
I am spending most of my time working on it today, trying to isolate users using 20+ logins (a sign of not closing connections)
[/QUOTE]
Sounds like a classic case of poorly written code being reused all over the place.
In ASP you have to always remember -
Recordset.Close (or something like that)
Hatton
just want to give my support to stephen and his crew. hopefully this nightmare will be behind us soon.
i think its working now.
wait…im on mssql2, nm 
MSSQL2 was having the same error, the ram upgrade fully fixed it, but no such luck on MSSQL3.
However, I have really tuned mssql3 server a lot now, what I am reading now is that it could be on the webserver side, if people still having problems could PM or otherwise list what server they are on, I will see if it is a common server and maybe a maxconnection being met of the webserver instead of the SQL server.
Over the last 6 hours MSSQL3 is averaging less than 10%(most of the time sitting at 0-1%, so I am being very liberal on the average) cpu, with 3 few second long spikes to 70%, and still has 30% free memory.
This is begining to piss me off abit now,…
Still happening…
Microsoft OLE DB Provider for SQL Server error ‘80004005’
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
/forum/includes/pm_check_inc.asp, line 67
Same problem, same codes all the time, you guys changed, upgraded the memory last night, so thats rulled out…
Im Just paid for the yearly Platinum account, and am about to upgrade at the end of the week to the yearly Titanium..
It was,has,is a prob Ive had since last November..
Im looking at going from 100 to 4000+ forum members in a few weeks…!!!
Please convince me you can fix this…
MM
Hehhe…
Its happening more often
Microsoft OLE DB Provider for SQL Server error ‘80004005’
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
/forum/default.asp, line 347
MM
I am running the SQL profiler now, seeing how it is happening.
Edit: seems to be a windows 2003 thing, check this out:
http://www.webservertalk.com/showthread.php?threadid=254594&perpage=10&pagenumber=1
I am still researching and trying to make it quit,but up to now the SQL server is running perfect.
[QUOTE=Stephen]
I am running the SQL profiler now, seeing how it is happening.
Edit: seems to be a windows 2003 thing, check this out:
http://www.webservertalk.com/showthread.php?threadid=254594&perpage=10&pagenumber=1
I am still researching and trying to make it quit,but up to now the SQL server is running perfect.
[/QUOTE]
Ive had this problem since joining last November, the link you posted is over 3 months old..
But, Ill read in detail, and comment back..
MM
I’ve seen this exact same problem on other II6 installations…non Jodo setups…
Also as a final, final option…
If this is behond your control, how should I proceed.
Using the Forum programe at the moment, in my case [url=
Web Wiz Forums - Free Forum Software]webwiz[/url].
I DONT want to loose any data…
And as this problem also effects the main .net site you are hosting, where do I go from here…?
Im not a noob, but im no way an even slight expert in this field, and was recomended your as a host, by one of my staff, who has never, ever had any problem here..
Your set up, and ease of use allowed me to create my site, and forum, but transfering all the data, may be a problem for me..
MM
[QUOTE=Bobum]
I’ve seen this exact same problem on other II6 installations…non Jodo setups…
[/QUOTE]
And never saw a solution ?
If so, and its a know problem, why still let paying peeps like me carry on ?
Q, Bobum, so why point me here !!!
MM
I am still researching the windows 2003 side, about to give MS a call, as I can’t duplicate or force errors on a 2000 server, just on windows 2003.
For sure they know about this by now, and as you said, that is old, certainly have some idea what to do at this point.
[QUOTE=Stephen]
I am still researching the windows 2003 side, about to give MS a call, as I can’t duplicate or force errors on a 2000 server, just on windows 2003.
For sure they know about this by now, and as you said, that is old, certainly have some idea what to do at this point.
[/QUOTE]
Thanks…
MM
It was because of a software install, there was a post in the network forum.