Named Instance Not Visible local instance visible but does not exist?!?!

I have installed a named instance of MSDE on 4 machines with no problems.
Some had preexisting versions of local which were uninstalled no problems.
On this machine the local instance has been uninstalled. The names instance
installs fine however when you try to connect the named instances are not
visible but the now non existing local instance is visible. Connecting to
ether by manually typing in computername\instancename does not work. I have
removed folders registry values ect with no luck. Any Ideas?
Shane Lim
hi Shane,
"Shane Lim" <gslim@.spatialdynamics.com> ha scritto nel messaggio
news:%23opqoD84EHA.2180@.TK2MSFTNGP10.phx.gbl
> I have installed a named instance of MSDE on 4 machines with no
> problems. Some had preexisting versions of local which were
> uninstalled no problems. On this machine the local instance has been
> uninstalled. The names instance installs fine however when you try to
> connect the named instances are not visible but the now non existing
> local instance is visible. Connecting to ether by manually typing in
> computername\instancename does not work. I have removed folders
> registry values ect with no luck. Any Ideas?
> Shane Lim
what (SQL Server) service name is available in the Control
Panel->management->Services applet?
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||I only have the MSQL&Instancename and the SQLAGENT$instancename.
They are both set to log in with the localmachine administrator.
When I try to conntect with query analyzer it doesn't show up in the
list but just the computername does. When I type in the
computername/instancename it says connecting then after a bit I get
undable to connect to server computername\instancename:
Server:Msg17,level16, State 1
[Microsoft][ODBC SQL Server Driver][DBNETLIB]Sql Server does not exist
or Access is denied.
Same thing when I just click on the computername that is in the list
of available servers after I click the refresh button.
If I uninstall everything then the computername is not available. But
once I reinstall an instance its back.
I even removed all the SQL server Registry enteries under local
machine > software > microsoft still no luck.
On Fri, 17 Dec 2004 12:16:37 +0100, "Andrea Montanari"
<andrea.sqlDMO@.virgilio.it> wrote:

>hi Shane,
>"Shane Lim" <gslim@.spatialdynamics.com> ha scritto nel messaggio
>news:%23opqoD84EHA.2180@.TK2MSFTNGP10.phx.gbl
>what (SQL Server) service name is available in the Control
>Panel->management->Services applet?
|||hi Shane,
"Shane Lim" <gslim@.blizzardice.com> ha scritto nel messaggio
news:fs66s09089a0igajttiku8q93r7stnrj4h@.4ax.com
> ...
> Server:Msg17,level16, State 1
> [Microsoft][ODBC SQL Server Driver][DBNETLIB]Sql Server does not exist
> or Access is denied.
please have a look at
http://support.microsoft.com/default...06&Product=sql
for potential causes of this problem..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply