Getting the Name of an MSDE Install

I am trying to verify the "name" of the MSDE installation on a system. I
look at:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server
And the value for the InstalledInstances Key is: MSSQLSERVER NetSDK
I know that the name of the server used in connection strings is "JIM"
Am I looking in the wrong place?
Wayne
Hi Wayne,
Sounds like you need JIM\NETSDK as the name to connect to.
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"Wayne Wengert" <wayneDONTWANTSPAM@.wengert.com> wrote in message
news:eNv8bNHwEHA.2568@.TK2MSFTNGP11.phx.gbl...
>I am trying to verify the "name" of the MSDE installation on a system. I
> look at:
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server
> And the value for the InstalledInstances Key is: MSSQLSERVER NetSDK
>
> I know that the name of the server used in connection strings is "JIM"
> Am I looking in the wrong place?
> Wayne
>
|||Nope! Just "JIM" is working fine? I thought that key was supposed to contain
the names of installed instances?
Wayne
"Greg Low [MVP]" <greglow@.lowell.com.au> wrote in message
news:utc1nGLwEHA.2732@.TK2MSFTNGP12.phx.gbl...
> Hi Wayne,
> Sounds like you need JIM\NETSDK as the name to connect to.
> HTH,
> --
> Greg Low [MVP]
> MSDE Manager SQL Tools
> www.whitebearconsulting.com
> "Wayne Wengert" <wayneDONTWANTSPAM@.wengert.com> wrote in message
> news:eNv8bNHwEHA.2568@.TK2MSFTNGP11.phx.gbl...
>
|||Wayne,
Is the name of the machine Jim. It looks to me like you have a default
instance which is showing up as the MSSQLSERVER (which you would use the
name of the machine to connect to it) and another named instance of NetSDK
for that one you would need to use jim\netsdk to connect (assuming that jim
is the name of the machine)
If you look in the services.msc then you should see MSSQLSERVER and a
MSSQL$NetSDK service for the respective instances .
Hope that helps,
David Copeland
Microsoft Small Business Server Support
This posting is provided "AS IS" with no warranties, and confers no rights.
SBS Newsgroups:
SBS v4.x: microsoft.public.backoffice.smallbiz
SBS 2000: microsoft.public.backoffice.smallbiz2000
SBS 2003: microsoft.public.windows.server.sbs
"Wayne Wengert" <wayneDONTWANTSPAM@.wengert.com> wrote in message
news:ezkFmyMwEHA.1292@.TK2MSFTNGP10.phx.gbl...
> Nope! Just "JIM" is working fine? I thought that key was supposed to
contain[vbcol=seagreen]
> the names of installed instances?
> Wayne
> "Greg Low [MVP]" <greglow@.lowell.com.au> wrote in message
> news:utc1nGLwEHA.2732@.TK2MSFTNGP12.phx.gbl...
I
>
|||David;
Yes, Jim is the machine name. Your explanation clarifies several things but
when I connect I simply use "(local)" which I suspect uses the default
instance.
Thanks for the help.
Wayne
"David Copeland [MSFT]" <davidcop@.online.microsoft.com> wrote in message
news:uQDnSBiwEHA.3336@.TK2MSFTNGP11.phx.gbl...
> Wayne,
> Is the name of the machine Jim. It looks to me like you have a default
> instance which is showing up as the MSSQLSERVER (which you would use the
> name of the machine to connect to it) and another named instance of
NetSDK
> for that one you would need to use jim\netsdk to connect (assuming that
jim
> is the name of the machine)
> If you look in the services.msc then you should see MSSQLSERVER and a
> MSSQL$NetSDK service for the respective instances .
> --
> Hope that helps,
> David Copeland
> Microsoft Small Business Server Support
> This posting is provided "AS IS" with no warranties, and confers no
rights.[vbcol=seagreen]
>
> SBS Newsgroups:
> SBS v4.x: microsoft.public.backoffice.smallbiz
> SBS 2000: microsoft.public.backoffice.smallbiz2000
> SBS 2003: microsoft.public.windows.server.sbs
> "Wayne Wengert" <wayneDONTWANTSPAM@.wengert.com> wrote in message
> news:ezkFmyMwEHA.1292@.TK2MSFTNGP10.phx.gbl...
> contain
system.[vbcol=seagreen]
> I
"JIM"
>
|||Hi Wayne,
Yes, it does.
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"Wayne Wengert" <wayneDONTWANTSPAM@.wengert.com> wrote in message
news:OSHvn4zwEHA.3228@.TK2MSFTNGP10.phx.gbl...
> David;
> Yes, Jim is the machine name. Your explanation clarifies several things
> but
> when I connect I simply use "(local)" which I suspect uses the default
> instance.
> Thanks for the help.
> Wayne
> "David Copeland [MSFT]" <davidcop@.online.microsoft.com> wrote in message
> news:uQDnSBiwEHA.3336@.TK2MSFTNGP11.phx.gbl...
> NetSDK
> jim
> rights.
> system.
> "JIM"
>