Re: SQL Server Desktop Engine

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Guy (youngrichsingle_at_hotmail.com)
Date: 12/01/04 

Date: Wed, 1 Dec 2004 04:17:20 -0800

Wonderful, so much for our own SQL teams.

Thanks very much!
>-----Original Message-----
>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