Problems with Enterprise Manager/MSDE

I have installed an MSDE instance on my PC. I have used both the setup.exe program and installed MSDE with the merge modules. Everything works fine - I am able to programmatically connect to the database and execute all of my statements. However, when I t
ry to register the database with Enterprise Manager, Enterprise Manager doesn't see the instance. Similarly, my program that uses SQLDMO.DLL to enumerate all servers does not see the MSDE instance. Both the database, my program, and Enterprise Manager are
running locally on the same machine.
This is a development box, and I have had to uninstall MSDE by hand several times by removing registry keys manually. I suspect that my problem is that I have deleted a key that I needed. Does anyone have any clues? Thanks in advance.
Rob Reagan
By default MSDE only uses Shared Memory for communicating with client
applications. Make sure that when you install MSDE that you use the command
line switch DISABLENETWORKPROTOCOLS=0.
Jim
"Rob Reagan" <RobReagan@.discussions.microsoft.com> wrote in message
news:94D3760F-80D4-41DB-97A0-320506FE04AA@.microsoft.com...
> I have installed an MSDE instance on my PC. I have used both the setup.exe
program and installed MSDE with the merge modules. Everything works fine - I
am able to programmatically connect to the database and execute all of my
statements. However, when I try to register the database with Enterprise
Manager, Enterprise Manager doesn't see the instance. Similarly, my program
that uses SQLDMO.DLL to enumerate all servers does not see the MSDE
instance. Both the database, my program, and Enterprise Manager are running
locally on the same machine.
> This is a development box, and I have had to uninstall MSDE by hand
several times by removing registry keys manually. I suspect that my problem
is that I have deleted a key that I needed. Does anyone have any clues?
Thanks in advance.
> Rob Reagan
|||Can one re-enable NETWORK connections without an uninstall/re-install ?
Pete
"Jim Young" <thorium48@.hotmail.com> wrote in message
news:uLzTSNzVEHA.208@.TK2MSFTNGP10.phx.gbl...
> By default MSDE only uses Shared Memory for communicating with client
> applications. Make sure that when you install MSDE that you use the
command[vbcol=seagreen]
> line switch DISABLENETWORKPROTOCOLS=0.
> Jim
> "Rob Reagan" <RobReagan@.discussions.microsoft.com> wrote in message
> news:94D3760F-80D4-41DB-97A0-320506FE04AA@.microsoft.com...
setup.exe
> program and installed MSDE with the merge modules. Everything works fine -
I
> am able to programmatically connect to the database and execute all of my
> statements. However, when I try to register the database with Enterprise
> Manager, Enterprise Manager doesn't see the instance. Similarly, my
program
> that uses SQLDMO.DLL to enumerate all servers does not see the MSDE
> instance. Both the database, my program, and Enterprise Manager are
running
> locally on the same machine.
> several times by removing registry keys manually. I suspect that my
problem
> is that I have deleted a key that I needed. Does anyone have any clues?
> Thanks in advance.
>
|||hi Pete,
"Pete" <p0911@.hotmail.com> ha scritto nel messaggio
news:%23zmObU4VEHA.584@.TK2MSFTNGP09.phx.gbl...
> Can one re-enable NETWORK connections without an uninstall/re-install ?
>
execute Server Network Utiliy (svrnetcn.exe) and enable the desired network
protocol(s)
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Thank you Andrea - will give it a whirl
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:2jo0brF139hlfU1@.uni-berlin.de...[vbcol=seagreen]
> hi Pete,
> "Pete" <p0911@.hotmail.com> ha scritto nel messaggio
> news:%23zmObU4VEHA.584@.TK2MSFTNGP09.phx.gbl...
?
> execute Server Network Utiliy (svrnetcn.exe) and enable the desired
network
> protocol(s)
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
|||Brilliant - comes up like a dream and all protocols are listed - thank you
once again Andrea
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:2jo0brF139hlfU1@.uni-berlin.de...[vbcol=seagreen]
> hi Pete,
> "Pete" <p0911@.hotmail.com> ha scritto nel messaggio
> news:%23zmObU4VEHA.584@.TK2MSFTNGP09.phx.gbl...
?
> execute Server Network Utiliy (svrnetcn.exe) and enable the desired
network
> protocol(s)
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
|||Andrea,
I believe that I am using SQL Server 2000 Personal edition. When I try to run the Server Network Utility from either the programs menu or from the command line, nothing happens. Is this included with Sql Server Personal edition?
When I look at the Client Network Utility, both TCP/IP and Named Pipes are enabled. Since this was working before and I have screwed with the registry by hand, I tend to think that the problem is that I deleted some needed key. Any suggestions on how to t
roubleshoot this problem?
Rob Reagan
"Andrea Montanari" wrote:

> hi Pete,
> "Pete" <p0911@.hotmail.com> ha scritto nel messaggio
> news:%23zmObU4VEHA.584@.TK2MSFTNGP09.phx.gbl...
> execute Server Network Utiliy (svrnetcn.exe) and enable the desired network
> protocol(s)
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
|||hi Rob,
"Rob Reagan" <RobReagan@.discussions.microsoft.com> ha scritto nel messaggio
news:C8C04B22-74FB-464E-8ECF-36F594E34E86@.microsoft.com...
> Andrea,
> I believe that I am using SQL Server 2000 Personal edition. When I try to
run the Server
>Network Utility from either the programs menu or from the command line,
nothing happens.
>Is this included with Sql Server Personal edition?
yep, the Server Network Utility is installed with every server installation,
MSDE or SQL Server, while Client Network utility is installed with client
component and/or MDAC..

> When I look at the Client Network Utility, both TCP/IP and Named Pipes are
enabled.
>Since this was working before and I have screwed with the registry by hand,
I tend to
>think that the problem is that I deleted some needed key. Any suggestions
on how to
>troubleshoot this problem?
=;-D
unfortunately I can't help your (damaged) registry :-(
try installing another SQL Server/MSDE instance (and then removing it), that
coul'd resolve your registry issues..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply