Re: Error: SQL Server does not exist or access denied

From: Aaron Bertrand [MVP] (aaron_at_TRASHaspfaq.com)
Date: 04/13/04 

Date: Tue, 13 Apr 2004 17:33:25 -0400

> I'm accessing the server using LOCALHOST as suggested by ASPFAQ.

Actually, http://www.aspfaq.com/2126 has this:

<snip>
If you are running SQL Server or MSDE on the same machine as your ASP pages,
you are probably tempted to use the hostname "localhost." This doesn't
always work, due to different configuration issues, so try (local),
127.0.0.1, the actual host name, or simply a period (".").
</snip>

And in the 80004005 article to which I think you're referring (it is a
rather large site, so saying the site suggested it is rather vague), it
suggested using 127.0.0.1 or LOCALHOST if the *network name* is failing.
Did you try 127.0.0.1, the local network name, (local), ., the local IP
address, ...? 

-- 
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/

Relevant Pages

  • RE: Starter kit will not install no localhost connection
    ... there should be no any SQL Server Service running on your machine. ... telnet localhost 1433 ... In the command prompt, ... osql -S localhost -E (If this works, you installation will be OK) ...
    (microsoft.public.sqlserver.setup)
  • SQL.NET connection error in Active Directory
    ... SQL Server does not exist or ... enabled identity impersonation to true... ... up getting that SQL connection error unless... ... Obviously I can't log onto localhost every minute as it will time ...
    (microsoft.public.dotnet.framework.aspnet)
  • SQL.NET connection error in Active Directory
    ... SQL Server does not exist or ... enabled identity impersonation to true... ... up getting that SQL connection error unless... ... Obviously I can't log onto localhost every minute as it will time ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Using SQL on Development Machine
    ... Note that (localhost) worked on my other computer and I see localhost used in several examples. ... If I right-click on the database in the Server Explorer and select the Modify Connection command, I see 'Use Windows Authentication' is selected, for which I obviously have correct authentication. ... SQL Server 2005 Services ... TCP/IP = Disabled ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: [Solved - of sorts] CUPS printing problems
    ... allow any thing but the localhost to print to my printers by cups. ... to connect I am able to print from other machines on my local network. ... I decided to try a test print of a photo. ... ...the Sin of Stupidity. ...
    (Fedora)