Re: i can't connect with the MSDE instance from another computer

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Ron Allen (rallen_at__nospam_src-us.com)
Date: 09/14/04


Date: Tue, 14 Sep 2004 08:44:18 -0400

Jorge,
    If you installed the latest version the network protocols are probably
disabled (the default setting). Use svrnetcn.exe in the Binn folder under
your sql server directory to enable TCP/IP and things should work again. If
the machine with MSDE has a firewall make sure that the appropriate ports
can pass through the firewall (normally 1433). Use Properties on the
enabled TCP protocol to see the port used.

Ron Allen
"Jorge Lozano" <j.lozano@initron20.com> wrote in message
news:07f001c49a51$94f2b8e0$a601280a@phx.gbl...
> I've installed a MSDE in one computer and i can access the
> data without problems from the same computer , but if i
> try to connect to the MSDE from another computer in the
> same network , the instance doesn't appear. I tried from
> almost 3 computers but i can't connect.
>
> What i'm doing wrong?



Relevant Pages

  • Securty connecting from internet to MSDE
    ... I'm trying to connect to a MSDE instance behind a firewall using ... I configured the firewall to redirect the 1433 and 1434 ports ...
    (microsoft.public.sqlserver.connect)
  • Re: Anonymous MSDE?
    ... What is more likely is that network protocols are currently disabled. ... MSDE Manager SQL Tools ... "steve" wrote in message ... > am getting no indication of the installtion when my app ...
    (microsoft.public.sqlserver.msde)
  • Re: How to shut down port # 1434?
    ... How to Block Specific Network Protocols and Ports by Using IPSec ... > was reading info related to slammer virus on MSDN and at ... How do I shut down a port in SQL Server. ...
    (microsoft.public.sqlserver.security)
  • Re: Installation
    ... > I am very new to MSDE version. ... edition of SQL Server 2000, so you can have a look at SQL Server related ... MSDE installs by default disabling network protocols to protect the server ...
    (microsoft.public.sqlserver.msde)
  • Re: Cant connect via Enterprise Manager
    ... Most likely network protocols not enabled. ... MSDE Manager SQL Tools ...
    (microsoft.public.sqlserver.msde)