Re: Server does not exist or access denied

From: Uri Dimant (urid_at_iscar.co.il)
Date: 03/16/04


Date: Tue, 16 Mar 2004 15:33:19 +0200

Buzby
What is an output of select @@version?
or
select * from sysservers ?

"Buzby" <gb@pumpupthe.net> wrote in message
news:c36v60$2322ng$1@ID-186443.news.uni-berlin.de...
> I have a bit of an issue with my usually excellent isp. I have 4 web sites
> all with an underlying sql db which have worked perfectly for 2 years
until
> the sites were moved to new servers (Win2003), and sql was upgraded from
> SQL7 to SQL2000.
>
> One site mostly remains up (which holds the SQL account) and the three
> others fall over with monotonous intermittent regularity showing the
> following error:
>
> Microsoft OLE DB Provider for ODBC Drivers error '80004005'
> [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or
> access denied.
>
> I can however, connect to sql server and pull off information from an
> external site whilst the others are down.
>
> Whilst I'd be the first to admit, being self taught my code is far from
> perfect, I don't understand why, when traffic has remained fairly
constant,
> I getting problems all of a sudden, and if it's all gone wrong, why I can
> still connect from an external site.
>
> TIA!
>
> Buzby
>
>



Relevant Pages

  • [REVS] SQL Injection Walkthrough
    ... problems facing them while trying to utilize SQL Injection techniques, ... Many web pages take parameters from web user, and make SQL query to ... MS SQL server ignore the rest of the query, which will get rid of the last ... Microsoft OLE DB Provider for ODBC Drivers error '80040e07' ...
    (Securiteam)
  • Re: Unable to Apply SP4 to SQL 2000 Cluster (new Node)
    ... Rebuild the node in the failover cluster. ... Scenario 1" in SQL Server 2000 Books Online. ... This setup process updates to SP4 only the binaries on the new ...
    (microsoft.public.sqlserver.clustering)
  • Re: WSS 3.0 question
    ... I followed the advise given in removing WSS 3.0 etc, ... the server is complaining that the SQL service(?) was tempered with or corrupt. ... I may just instal the SQL server as I was going eventuall use it anyway. ... If WSUS 3.0 is installed, I would suggest you uninstall it and then you install WSS 3.0. ...
    (microsoft.public.windows.server.sbs)
  • Re: SQL Server 2005 Cluster Setup Quiz
    ... I did test and it did not install the client tools. ... http://www.clusterhelp.com - Cluster Training ... Microsoft SQL Server MVP ... Provide a template on how to read SQL Server 2005 setup log files. ...
    (microsoft.public.sqlserver.clustering)
  • Re: WSUS
    ... I'm not seeing performance issues with the full enchilada installed, and 25 users busy hitting SQL. ... WSUS isn't difficult to uninstall - if you have WSUS v2 (installed with SBS R2) uninstall R2 from add/remove programs. ... How can anyone work with 4 instances of SQL Server on the same box? ...
    (microsoft.public.windows.server.sbs)