How to connect to msde on an other server?

I tried to connect to a msde on an other server via the enterprise manager.
This wasn't possible!
Unable to establish connection. Server unknown or access denied!
What can i do?
thx
Hi,
Can you enable the TCPIP protocol using the utility svrnetcn.exe from SQL
server machine. Run the
svrnetcn.exe from command prompt and after enabling the protocol stop and
start the MSSQL server Service .
After starting the service try connecting remotely
Thanks
Hari
SQL Server MVP
"Raupes" <Raupes@.discussions.microsoft.com> wrote in message
news:1055E5E7-0B98-4A3D-A303-8DA1C511FED4@.microsoft.com...
>I tried to connect to a msde on an other server via the enterprise manager.
> This wasn't possible!
> Unable to establish connection. Server unknown or access denied!
> What can i do?
> thx
|||Hi,
I have exactly the same problem. I have tried your
suggestion but without success.
Anyone have another suggestion?
Tks, Rui

>--Original Message--
>Hi,
>Can you enable the TCPIP protocol using the utility
svrnetcn.exe from SQL
>server machine. Run the
>svrnetcn.exe from command prompt and after enabling the
protocol stop and
>start the MSSQL server Service .
>After starting the service try connecting remotely
>
>--
>Thanks
>Hari
>SQL Server MVP
>
>"Raupes" <Raupes@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:1055E5E7-0B98-4A3D-A303-8DA1C511FED4@.microsoft.com...
enterprise manager.[vbcol=seagreen]
access denied!
>
>.
>
|||I had the same problem.
If you telnet to port 1433 on the machine running msde do you get a
connection failed message? If it fails it could be firewall settings.
I fixed the problem here by removing all protocols and then re-adding only
tcp/ip.
"Rui Oliveira" <anonymous@.discussions.microsoft.com> wrote in message
news:495b01c4c748$732788c0$a401280a@.phx.gbl...[vbcol=seagreen]
> Hi,
> I have exactly the same problem. I have tried your
> suggestion but without success.
> Anyone have another suggestion?
> Tks, Rui
> svrnetcn.exe from SQL
> protocol stop and
> message
> enterprise manager.
> access denied!
|||At first I had to configure the port at which the msde is listening.
After that I had to open the UDP 1434 port vor all wizzards of the
enterprise manager. Only god knows why the enterprise manager uses 1433 tcp
only and all other wizzards use 1434 udp.
hm.
hope that i could help you
cu
Raupes
"Rui Oliveira" wrote:

> Hi,
> I have exactly the same problem. I have tried your
> suggestion but without success.
> Anyone have another suggestion?
> Tks, Rui
> svrnetcn.exe from SQL
> protocol stop and
> message
> enterprise manager.
> access denied!
>