Anonymous MSDE?

Is it possible for MSDE to be installed but to have no
identifying name? I have installed MSDE on a system but I
am getting no indication of the installtion when my app
tries to access it. There is some code I have used which
basically uses SQLBrowseConnect() to determine if it is
installed. It comes back with no server in the list.
Steve
What is more likely is that network protocols are currently disabled. Run
svrnetcn.exe and check that appropriate protocols are enabled.
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"steve" <steven.dahlin@.gmail.com> wrote in message
news:95b801c496e6$c7d70ae0$a301280a@.phx.gbl...
> Is it possible for MSDE to be installed but to have no
> identifying name? I have installed MSDE on a system but I
> am getting no indication of the installtion when my app
> tries to access it. There is some code I have used which
> basically uses SQLBrowseConnect() to determine if it is
> installed. It comes back with no server in the list.
> Steve
|||What would be the best way to verify that a local server is
up and running programmatically from an application?
Steve

>--Original Message--
>What is more likely is that network protocols are
currently disabled. Run
>svrnetcn.exe and check that appropriate protocols are
enabled.[vbcol=seagreen]
>HTH,
>--
>Greg Low [MVP]
>MSDE Manager SQL Tools
>www.whitebearconsulting.com
>"steve" <steven.dahlin@.gmail.com> wrote in message
>news:95b801c496e6$c7d70ae0$a301280a@.phx.gbl...
I[vbcol=seagreen]
which
>
>.
>
|||No really good way currently except via the scripting interface into the
operating system and checking for SQL Server services and then checking
their states.
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
<anonymous@.discussions.microsoft.com> wrote in message
news:013901c49761$e875e980$a401280a@.phx.gbl...[vbcol=seagreen]
> What would be the best way to verify that a local server is
> up and running programmatically from an application?
> Steve
> currently disabled. Run
> enabled.
> I
> which
|||Is there any article that touches upon the details of how
to accomplish this?
Steve

>--Original Message--
>No really good way currently except via the scripting
interface into the
>operating system and checking for SQL Server services and
then checking
>their states.
>HTH,
>--
>Greg Low [MVP]
>MSDE Manager SQL Tools
>www.whitebearconsulting.com
><anonymous@.discussions.microsoft.com> wrote in message
>news:013901c49761$e875e980$a401280a@.phx.gbl...
>
>.
>
|||Hi Steve,
I wrote some courseware a few years ago that covered scripting. This is an
excerpt from some VBScript code that checks for services that should start
automatically but haven't:
Set objWMI = GetObject("winmgmts:")
Set objServices = objWMI.InstancesOf("Win32_Service")
strList = ""
For Each objService In objServices
If (objService.StartMode = "Auto")
and (objService.State = "Stopped") Then
strList = strList & objService.DisplayName & strCRLF
End If
Next
wscript.echo strlist
Modifying it for to find any sql server services that have started would be
something like:
Set objWMI = GetObject("winmgmts:")
Set objServices = objWMI.InstancesOf("Win32_Service")
strList = ""
For Each objService In objServices
if Left(objService.DisplayName,5) = "MSSQL" Then
if objService.State = "Running" Then
strlist = strlist & objservice.DisplayName & chr(13) & chr(10)
End If
End If
Next
wscript.echo strlist
If you translate that to whichever language you're using, you should be
close.
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"steve" <steven.dahlin@.gmail.com> wrote in message
news:a08101c497c5$4b56d5b0$a601280a@.phx.gbl...[vbcol=seagreen]
> Is there any article that touches upon the details of how
> to accomplish this?
> Steve
> interface into the
> then checking