Wednesday, March 21, 2012

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

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?
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?

No comments:

Post a Comment