Re: SQL Server Desktop Engine

From: Andrea Montanari (andrea.sqlDMO_at_virgilio.it)
Date: 12/01/04 

Date: Wed, 1 Dec 2004 12:49:39 +0100

hi Guy,
"Guy" <youngrichsingle@hotmail.com> ha scritto nel messaggio
news:044e01c4d798$d9a11570$a401280a@phx.gbl
> I have just had VB .NET installed along with the MS SQL
> Server 2000 Desktop Engine and have got myself a little
> confused.
>
> Apparently MSDE was supposed to have set up a SQL Server
> instance on my PC when it installed but when I look in
> the list on the SQL Server Service Manager it only lists
> network places and I don't know how to connect it to my
> local one.
>
> I believe it's most likely MSSQL$VSDOTNET as it is the
> name of a directory in my Microsoft SQL Server directory
> and there seems to be a component with this name be
> running according to the Services list in Control
> Panel/Administrative Tools.
>
> I can't however get it to show up on the SQL Service
> Manager.
>
> If I type it as above or with a path, be it C:\ or the
> full URL with PC name etc, I just get 'The network path
> was not found'.
>
> Could it be anything to do with the fact that access is
> denied when I try to enter the aforementioned directory?
> I was logged in as myself but with admin rights when it
> was installed and now I am back down to normal security
> level. Could this have a bearing?
>

YourComputerName\VSDOTNET is the full name of the named instance installed
along with the .Net framework and you have to reference it that way from
remote clients... locally, on the same pc, you can use the
YourComputerName\VSDOTNET and/or (local)\VSDOTNET nomenclature...
MSDE installs by default disabling the network protocols to protect the
installed instance(s) from external attack and this often prevent the
instance to be enlisted by broadcast enumeration of available SQL Server,
for further info please have a look at
http://support.microsoft.com/default.aspx?scid=kb;EN-US;814132
in order to allow network availibility of MSDE instances you have to enable
the desired network protocol(s) running the Server Network Utility
(svrnetcn.exe).. 

-- 
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtm        http://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

Relevant Pages

  • RE: SQL Server 2000 SP4 - Intermittent timeout/connection issues
    ... With a network problem nothing is ever simple dealing with sql. ... Could you put an LMHosts file on the web servers to the sql server ...
    (microsoft.public.sqlserver.server)
  • Re: Irritating SQL 2000/2005 connection problem
    ... installed on our network anywhere. ... SqlConnection) to connect to a SQL 2000 database with a connection string ... When connecting to SQL ... Server 2005, this failure may be caused by the fact that under the default ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: SQL2005 Failed when installing SP2
    ... Somehow the name of the Virtual Server already existed on the network. ... It may be that the system tried to start SQL on both nodes at the same time. ... I would move both instances to the same node and attempt to complete the SP install. ...
    (microsoft.public.sqlserver.clustering)
  • Re: APC PowerChute Business Edition Lost Connection
    ... SQL hangs on mostly on mondaymorning. ... I believe one of the MVP's here uses this and never installs ... the bundled software that comes with APC UPS device. ... didnt see any performance increase from the server. ...
    (microsoft.public.windows.server.sbs)
  • Re: Connection from remote computer to network SQL Server
    ... by default connectin to SQL Express from the network is disabled ... There is no firewall on the W2K machine acting as the SQL server. ... connection works. ...
    (microsoft.public.access.adp.sqlserver)