Re: Problem in connecting after service pack 3a installed in MSDE 2000

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: oj (nospam_ojngo_at_home.com)
Date: 03/11/04 

Date: Wed, 10 Mar 2004 19:43:14 -0800

How do you connect? Try specify the IP for the server/data source and see if you
can connect. 

-- 
-oj
http://www.rac4sql.net
"chellam" <chellammal@touchtelindia.net> wrote in message
news:OphgNmxBEHA.3256@TK2MSFTNGP09.phx.gbl...
> Hi All,
>             I have installed MSDE 2000 server and i installed service pack
> 3a. The server machine has SQL Server 2000 client connectivity. When i
> connect from client machine to Server machine it is showing error.
>
> [Microsoft ] [ODBC SQL Server Driver] [TCP/IP sockets]
> SQL Server does not exists or access denied.
>
> I installed Servicepack 3a with out DISABLENETWORKPROTOCOL = 1
>
> Any suggestion would be greatly appreciated.
>
>
> Regards,
> A.Chellam.
>
>
>

Relevant Pages

  • Re: Connect to SQL Server from A2k
    ... A good idea would be to define an alias for the SQL-Server (SQL Server ... Firewall on the server machine. ... -Can connect to the Server through Access FE on the server machine. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: [SLE] network boot installation
    ... at home I have a little server without CDrom. ... Setting up a complete network install system isn't hard. ... Get the Suse CDs and set up an installation source. ... If you put a tail on /var/log/messages on the server machine, ...
    (SuSE)
  • Re: Connect to SQL Server from A2k
    ... -Have enabled multi mode security in the SQL server. ... -Can connect to the Server through Access FE on the server machine. ... so you should use a sql-server login account instead. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Error 8218 in Eventlog when using ms faxservice on win2000 server
    ... You have one external fax modem which works on Windows 2000 Professional ... machine but on Windows Server machine. ... On the Server machine does the 'send' work? ...
    (microsoft.public.win2000.fax)
  • Re: sp_trace_create problem
    ... what account is running the MSSQLSERVER Service. ... That OS account must have write permission to the c: drive on the server ... SQL Server MVP ... permission to write to the C: drive on the server machine? ...
    (microsoft.public.sqlserver.programming)