Re: Cannot connect to SQL Server

Is the Browser service running on S2?
Did you see the whitepaper on my blog? http://betav.com/blog/billva/2006/06/getting_and_staying_connected.html

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant, Dad, Grandpa
Microsoft MVP
INETA Speaker
www.betav.com
www.betav.com/blog/billva
www.hitchhikerguides.net
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
-----------------------------------------------------------------------------------------------------------------------

"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: Indexing French docs on an English server
    ... Henri ... > Looking for a SQL Server replication book? ... >> Our server is in English but docs stored on it are in French. ...
    (microsoft.public.inetserver.indexserver)
  • Re: Thanks for your help, one last question
    ... Tibor Karaszi, SQL Server MVP ... > "Henri" a écrit dans le message de ... >> another, about setting foreign keys. ...
    (microsoft.public.sqlserver.server)
  • Re: newbie question about transactions
    ... Henri ... > You have to check after each statement as the @@error variable gets reset ... > Mike Epprecht, Microsoft SQL Server MVP ... >> I'm thinking of using transactions but there's something I don't know. ...
    (microsoft.public.sqlserver.server)
  • RE: Starter kit will not install no localhost connection
    ... To enable TCP/IP server network library by the Server Network Utility, ... In the "SQL Server Network Utility" dialog box, ... Restart your instance of Microsoft SQL Server 2000 Desktop Engine ...
    (microsoft.public.sqlserver.setup)
  • Re: SQL server 2000 not listening on TCPIP
    ... On the Start menu, point to All Programs, Microsoft SQL Server, and then click Server Network Utility. ... In the SQL Server Network Utility program you will see an box marked "Instanceon this server." ... Select it and then click Enable to move TCP/IP to the Enabled protocols box. ...
    (microsoft.public.sqlserver.connect)
Loading