Connect to MSDE 2000 from SQL 2000 Ent. Manager

With SQL 2000 Ent. Manager I was able to connect to MSDE on another box. I
now have MSDE 2000 installed on the box. When I try to connect with SQL
2000 Ent. Manager I get the error "SQL Server does not exist or access
denied". I get the same error when I created an ODBC connection using the
same settings. I am however able to connect locally on the box using
Microsoft SQL Web Data Administration.
Any thoughts?
have you granted to permissions to the account on the other machine?
"Bishop" <kwayne@.new.rr.com> wrote in message
news:#vzRSOULEHA.2736@.TK2MSFTNGP11.phx.gbl...
> With SQL 2000 Ent. Manager I was able to connect to MSDE on another box.
I
> now have MSDE 2000 installed on the box. When I try to connect with SQL
> 2000 Ent. Manager I get the error "SQL Server does not exist or access
> denied". I get the same error when I created an ODBC connection using the
> same settings. I am however able to connect locally on the box using
> Microsoft SQL Web Data Administration.
> Any thoughts?
>
|||Verify that you have installed the network protocols to enable the remote
access.
To do that, use the tool on the box you installed MSDE2000.
Thierry
"Bishop" <kwayne@.new.rr.com> a crit dans le message de
news:%23vzRSOULEHA.2736@.TK2MSFTNGP11.phx.gbl...
> With SQL 2000 Ent. Manager I was able to connect to MSDE on another box.
I
> now have MSDE 2000 installed on the box. When I try to connect with SQL
> 2000 Ent. Manager I get the error "SQL Server does not exist or access
> denied". I get the same error when I created an ODBC connection using the
> same settings. I am however able to connect locally on the box using
> Microsoft SQL Web Data Administration.
> Any thoughts?
>
|||Hi, Where the tool network protocols?
Thanks, I have the same trouble
|||hi,
"aramgt" <anonymous@.discussions.microsoft.com> ha scritto nel messaggio
news:208EAA99-4E4F-4598-9415-7F443FB13297@.microsoft.com...
> Hi, Where the tool network protocols?
> Thanks, I have the same trouble
locate svrnetcn.exe on the server hosting your MSDE instance and execute
it...
eanble the desired network protocols...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.7.0 - DbaMgr ver 0.53.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Hi,
I completed all these steps and I can't connect using
server IP, just server name like server\machine.
Any ideas?

>--Original Message--
>hi,
>"aramgt" <anonymous@.discussions.microsoft.com> ha scritto
nel messaggio
>news:208EAA99-4E4F-4598-9415-7F443FB13297@.microsoft.com...
>locate svrnetcn.exe on the server hosting your MSDE
instance and execute
>it...
>eanble the desired network protocols...
>--
>Andrea Montanari (Microsoft MVP - SQL Server)
>http://www.asql.biz/DbaMgr.shtm
http://italy.mvps.org
>DbaMgr2k ver 0.7.0 - DbaMgr ver 0.53.0
>(my vb6+sql-dmo little try to provide MS MSDE 1.0 and
MSDE 2000 a visual
>interface)
>-- remove DMO to reply
>.
>
|||To connect with <SERVERNAME>, you need to install MSDE
from the command prompt with the "default" option, rather
than the "instancename" option.
[vbcol=seagreen]
>--Original Message--
>Hi,
>I completed all these steps and I can't connect using
>server IP, just server name like server\machine.
>Any ideas?
>
scritto[vbcol=seagreen]
>nel messaggio
7F443FB13297@.microsoft.com...
>instance and execute
>http://italy.mvps.org
>MSDE 2000 a visual
>.
>
|||Hi,
I'm working on a Windows 2000 Server and can't locate
svrnetcn.exe on it. Is there another way of setting the
required network protocols so that I can connect to MSDE
2000 remotely?
thanks

>--Original Message--
>hi,
>"aramgt" <anonymous@.discussions.microsoft.com> ha scritto
nel messaggio
>news:208EAA99-4E4F-4598-9415-7F443FB13297@.microsoft.com...
>locate svrnetcn.exe on the server hosting your MSDE
instance and execute
>it...
>eanble the desired network protocols...
>--
>Andrea Montanari (Microsoft MVP - SQL Server)
>http://www.asql.biz/DbaMgr.shtm
http://italy.mvps.org
>DbaMgr2k ver 0.7.0 - DbaMgr ver 0.53.0
>(my vb6+sql-dmo little try to provide MS MSDE 1.0 and
MSDE 2000 a visual
>interface)
>-- remove DMO to reply
>.
>
|||hi,
"kman" <anonymous@.discussions.microsoft.com> ha scritto nel messaggio
news:7a4701c43155$c4bf9e90$a401280a@.phx.gbl...
> Hi,
> I'm working on a Windows 2000 Server and can't locate
> svrnetcn.exe on it. Is there another way of setting the
> required network protocols so that I can connect to MSDE
> 2000 remotely?
if you have SQL Server installed on that server, you have to find it.. it's
the Server Network Utility listed in the SQL Server program group...
on client side, it's corresponding tool is the Client Network Utility,
cliconfg.exe
<Only for information>
you coul'd do i t manually editing the registry,
in the HKLM\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\Su perSocketNetLib
ProtocolList = tcp
for TCP/IP network protocol
BUT THIS IS NOT THE BEST WAY, please do it with the appropriate tool, the
Server Network Utility, where you can specify all your desired setting...
</Only for information>
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.7.0 - DbaMgr ver 0.53.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
sqlsql