Re: Cannot connect to SQL Server

So you can connect:
C1 -> S1
C2 -> S1
S2 -> S1
but cannot connect:
C1 -> S2
C2 -> S2

Some things to check:
Can you connect from S2 to S2? If this fails, I suspect the SQL Server is not started, or you have the name wrong because it's a named instance such as S2\MSDN, or it is not accepting any connections on the protocol you are using.

If you can connect from S2 to S2, then I would double-check the firewall. I see that you said you tried turning off the firewall, but the Windows firewall that is turned on in SP2 causes most of these problems.

What protocol are you using? If TCP/IP, try connecting using the TCP address and port number, such as 120.24.118.17,1433. It's possible you have a problem resolving the computer name. That would cause this error.
--
Rick Byham (MSFT)
This posting is provided "AS IS" with no warranties, and confers no rights.

"Henri" <foucauld@xxxxxxxxxx> wrote in message news:%23ZoxT3gyHHA.1188@xxxxxxxxxxxxxxxxxxxxxxx
I have almost the same problem than Clive (cf 18/07). I have 2 servers S1, S2 (windows XP Pro, SP2), and 2 clients C1 and C2 (Windows XP Pro, SP2).
The two servers are indentical, but if the two clients can connect S1, they cant' connect to S2 ""Access denied or SQL Server does not exist" (but S2 can connect S1).

- I have checked the Server Network Utility and ClientNetwork Utility : all is correct
- I have tried with the firewall unactivated : no change...
- The version of SQL 2000 on the two servers are the same.
- The network is a wire LAN.

Can anyone tell me where else to look or what else to try?

Many thanks in advance

Henri (Paris)



.

Relevant Pages

  • Re: IS IT SAFE TO HOST SQL SERVER AND IIS SERVER ON THE SAME MACHINE
    ... > safe to host a web application on a mchine outside of our firewall ... and the sql server would reside on this one machine. ... The vulnerabilities of Windows, IIS and SQL are well known, so you ...
    (microsoft.public.inetserver.iis.security)
  • Re: Clickonce and license question question
    ... would prefer to change the way we license / register the application. ... updates the SQL server at our ISP that the license key is now in use. ... What about just meaking the company open their firewall for the server? ...
    (microsoft.public.dotnet.framework.windowsforms)
  • Re: Connection error from VBScript
    ... The only firewall we use is Windows Firewall and that is disabled by default ... -2147467259 from MS OLE DB Provider, Specified SQL Server not found. ... you only need TCP/IP connectivity and TCP port 1433 to ...
    (microsoft.public.data.ado)
  • RE: SBS 2003 Unable to connect to database STS_Config
    ... Uninstall the SQL server from the SBS 2k3 server from add/remove programs ... Uninstall Microsoft SQL Server Desktop Engine (SHAREPOINT) ... If AV software install any extra IIS virtual directory, ...
    (microsoft.public.windows.server.sbs)
  • Re: Memory issues with 64-bit SQL Server 2005 on 64-bit Win 2003 C
    ... I also checked the individual patch levels for the .NET drivers, SQL Server ... The SQL Server is fully patched, however Windows Update reported that the OS ... Lock pages in memory -- I guess you might have taken care of it as well. ...
    (microsoft.public.sqlserver.clustering)
Loading