Re: localhost SQL Server does not exist after XP SP2

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Nicole Calinoiu (nicolec_at_somewhere.com)
Date: 08/31/04 

Date: Tue, 31 Aug 2004 13:47:28 -0400

Kerry,

The Windows firewall is blocking access on ports required by SQL Server.
Try using server=(local) instead of server=localhost to see if that resolves
the problem without opening the port. Otherwise, you'll find
recommendations for the firewall configuration at
http://www.microsoft.com/sql/techinfo/administration/2000/security/winxpsp2faq.asp.

HTH,
Nicole

"Kerry Sorenson" <KerrySorenson@discussions.microsoft.com> wrote in message
news:0CC0108E-7664-432B-B99F-50E4A965BE77@microsoft.com...
>I installed Windows XP (Pro) Service Pack 2
> yesterday and now my asp.net pages give me this error when they go looking
> for data: "SQL Server does not exist or access denied."
>
> My connection string which has worked up until now is
> "server=localhost;Trusted_Connection=true;database=bwdb".
>
> My ASP pages continue to work just fine.
>
> Set oConn = Server.CreateObject("ADODB.Connection")
> oConn.Open "bwdb","sa",""
> Set Rst = oConn.Execute(sqlStmt)
>
> I tried substituting the name of my computer for 'localhost' in the
> connection string and seem to be able to circumvent the problem this way.
> I
> don't really want to replace 'localhost' everywhere with a computer name
> because I am doing prototype development and will upload all this code to
> a
> different server with a different name.
>
> Advice?
>
>

Relevant Pages

  • Re: MSDE/SQL Server Problem
    ... I've had problems using "localhost" in my connection string. ... >> I've downloaded a couple of Microsoft sample source codes, ... >> I've SQL Server 2000 installed but for some reason its giving the error. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: ASP.net: Error "Exception Details: System.InvalidOperationException: The ConnectionString p
    ... > try using this connection string: ... >> Dear Martin, ... >> I have installed Sql Server on my localhost. ...
    (microsoft.public.dotnet.framework.aspnet)
  • localhost SQL Server does not exist after XP SP2
    ... "SQL Server does not exist or access denied." ... Set oConn = Server.CreateObject ... I tried substituting the name of my computer for 'localhost' in the ... connection string and seem to be able to circumvent the problem this way. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: One Connection String for Multiple Users (SQL)
    ... Hitchhiker’s Guide to Visual Studio and SQL Server ... "William Vaughn" wrote: ... This uses the> same connection string for all instances of the application. ...
    (microsoft.public.sqlserver.connect)
  • RE: How do I configure Analysis Services for Excel 2003 users?
    ... they had had Office 2003 installed AFTER SQL Server. ... > I have been preparing a set of cubes in Analysis Services 2005 to be viewed ... > Excel reports have been designed as pivot tables based on AS cubes, ... > Surely it must be that the connection string is incorrect but I seem to have ...
    (microsoft.public.sqlserver.olap)