SQL Errors - Need your input

118 Posts | Latest reply on 15/03/2009 21:10:27 by old red | Go to original / last post
Matt's Profile
Matt

In: Veldhoven
Posts: 8053
100% Karma100% Karma 100% Karma100% Karma

Hi everyone,   Please can you let me know if you get the following error? "SQL Server does not exist or access denied"   Please copy all the error, including code-line reference numbers etc.  Include the exact time that it occurred also.   I'm working with the webhosts to resolve this, but there appears to be a problem with the main web server connecting to the new DB server.   I need to ascertain if it's a particular time of day, certain code, etc.   Many thanks as always   ~Matt                                                                                                                                                                             
Wills's Profile
Wills

In: New Brighton
Posts: 3265
73% Karma73% Karma 73% Karma73% Karma

I didn't make any copies, but it was coming up over and over again late last night.                                                                                                                                                                              
Holmfirthgirl's Profile
Holmfirthgirl

In: Larkfield
Posts: 3156
0% Karma0% Karma 0% Karma0% Karma

bugger - have been getting that all morning, so have just logged out & back in again & all appears to be ok for the time being! If it does it again, I'll copy the details for ya Matt                                                                                                                                                                             
Wannabe's Profile
Wannabe

In: Dartford
Posts: 4922
0% Karma0% Karma 0% Karma0% Karma

Likewise - last night/this morning - stacks of 'em, but since logging back in 15-20 minutes ago, no problems.                                                                                                                                                                             
Wannabe's Profile
Wannabe

In: Dartford
Posts: 4922
0% Karma0% Karma 0% Karma0% Karma

Ooh - tell a lie. Just clicked on "all active topics" and got this (above the list):

Microsoft OLE DB Provider for SQL Server error '80004005'

[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

/sites/bm/forum/active_topics.asp, line 220
Wannabe's Profile
Wannabe

In: Dartford
Posts: 4922
0% Karma0% Karma 0% Karma0% Karma

Same error @ 12.46                                                                                                                                                                             
Matt's Profile
Matt

In: Veldhoven
Posts: 8053
100% Karma100% Karma 100% Karma100% Karma

Its mainly a problem late at night, or so I thought. And logging out/in wont help at all... all you have to do is press refresh (Or F5) and the page will reload fine.                                                                                                                                                                             
Deleted Member's Profile
Deleted Member

In: NA
Posts: 0
0% Karma0% Karma 0% Karma0% Karma

Yep i had the same probs last night about 23.30.                                                                                                                                                                             
Deleted Member's Profile
Deleted Member

In: NA
Posts: 0
0% Karma0% Karma 0% Karma0% Karma

Had the same myself last night but today it seems to be fne.                                                                                                                                                                             
Triumph_Sy's Profile
Triumph_Sy

In: Newtown
Posts: 904
27% Karma27% Karma 27% Karma27% Karma

Same as that.....                                                                                                                                                                             
TeeCee's Profile
TeeCee

In: Blair Atholl
Posts: 2888
0% Karma0% Karma 0% Karma0% Karma

19 Nov 08 12:48 (and after 3 refreshes)     Microsoft OLE DB Provider for SQL Server error '80004005' [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. /sites/bm/forum/active_topics.asp, line 220                                                                                                                                                                              
Matt's Profile
Matt

In: Veldhoven
Posts: 8053
100% Karma100% Karma 100% Karma100% Karma

Thanks TeeCee, keep them coming. I've not been online much today so don't know if it's been bad or not.                                                                                                                                                                             
Wannabe's Profile
Wannabe

In: Dartford
Posts: 4922
0% Karma0% Karma 0% Karma0% Karma

My clock says 23:21 but it's fast, to try and stop me being late for work! ;o)

Microsoft OLE DB Provider for SQL Server error '80004005'

[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

/sites/bm/forum/active_topics.asp, line 220
Matt's Profile
Matt

In: Veldhoven
Posts: 8053
100% Karma100% Karma 100% Karma100% Karma

hmmm its always the same line of code but the line in question isn't a big task, just a quick calculation.                                                                                                                                                                             
Matt's Profile
Matt

In: Veldhoven
Posts: 8053
100% Karma100% Karma 100% Karma100% Karma

Happened again to SP this morning at 8:30...   Microsoft OLE DB Provider for SQL Server error '80004005' [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. /sites/bm/forum/active_topics.asp, line 220                                                                                                                                                                             
Deleted Member's Profile
Deleted Member

In: NA
Posts: 0
0% Karma0% Karma 0% Karma0% Karma

Happened again to SP this morning at 8:30...  Server does not exist or access denied.     pony didn't stay over then....?Wink                                                                                                                                                                             
Wannabe's Profile
Wannabe

In: Dartford
Posts: 4922
0% Karma0% Karma 0% Karma0% Karma

I'm sure that before you asked the question I'd had similar errors but on other places i.e. not just on "active topics"

I had a couple of times where a thread would part load and the error message would come up in place of a post. But it's not happened since and I didn't pay attention to the error number.

Another one for the collection of completely pointless Wannabe posts. *ahem*
TeeCee's Profile
TeeCee

In: Blair Atholl
Posts: 2888
0% Karma0% Karma 0% Karma0% Karma

Also yesterday.... when you clicked on Active Topics, after a VERY long time only two or three thread topics would come up...   (no error message shown)                                                                                                                                                                             
Matt's Profile
Matt

In: Veldhoven
Posts: 8053
100% Karma100% Karma 100% Karma100% Karma

wannabe - that's interesting!  Keep an eye open for them and post up if you get them.   Remember - I need date/time AND a copy of the whole error that comes up!                                                                                                                                                                             
Wannabe's Profile
Wannabe

In: Dartford
Posts: 4922
0% Karma0% Karma 0% Karma0% Karma

Ooops... thought a post had bounced but I backpaged, hit the button again and it's posted twice... meantime I got another page flick up with this:

CDO.Message.1 error '80040213'

The transport failed to connect to the server.

/sites/bm/header_inc.asp, line 136

Between 23:15 and 23:16


Remove these advertisements                  Advertise Here
Biker Match is a UK social, events and dating website by bikers, for bikers.  All British motorcyclists are welcome to join our large and exciting community free of charge in search of ride-outs, motorcycling events & rallies, biker dating & relationships, motorcycle help, motorcycle forums, biking news, racing news, motorcycle classifieds or just to get to know other UK bikers.  Create your profile and upload your photos now completely free.
Website copyright 2002-2024 www.bikermatch.co.uk.

Page generated in 0.6563 seconds. There are 791 users online now.

Site tested and secured by Comodo HackerGuardian       Site tested and approved by McAfee SiteAdvisor      Site PCI DSS security approved      Site tested and secured by Comodo HackerProof       Site secured and validated using highest 2048bit encryption