local sql server not visible for 'Users' on the same PC

Users on the same PC who do not have admin rights cannot see or logon to the
sql server/msde that exists on the PC. Any user with admin rights can see
it, of course. I have waded thru lots of hits in my searches but none of
them describe this behavior and whether I can surmount this or not. Does
anyone have any suggestions?
Thanks,
Steve
I'm not sure what tool they are using to "see" SQL Server
but in terms of logging into the instance, they would need a
login set up in order to do this. By default, the windows
local admin group is added as a login on SQL Server. That's
how the admins are able to log into the instance.
-Sue
On Mon, 6 Dec 2004 11:09:04 -0800, "Steven.Dahlin"
<StevenDahlin@.discussions.microsoft.com> wrote:

>Users on the same PC who do not have admin rights cannot see or logon to the
>sql server/msde that exists on the PC. Any user with admin rights can see
>it, of course. I have waded thru lots of hits in my searches but none of
>them describe this behavior and whether I can surmount this or not. Does
>anyone have any suggestions?
>Thanks,
>Steve
|||The tool is Query Analyzer. As a another user I can run the tool and execute
the connect function. This will pull a list of all servers that can be
seen. The (local) server is not visible at all even though others on the
network are and the local is running.
Presumedly this accessing a broadcast feature of the servers. I do not know
why the local cannot be seen.
Steve
"Sue Hoegemeier" wrote:

> I'm not sure what tool they are using to "see" SQL Server
> but in terms of logging into the instance, they would need a
> login set up in order to do this. By default, the windows
> local admin group is added as a login on SQL Server. That's
> how the admins are able to log into the instance.
> -Sue
> On Mon, 6 Dec 2004 11:09:04 -0800, "Steven.Dahlin"
> <StevenDahlin@.discussions.microsoft.com> wrote:
>
>
|||The drop down is populated with instances you have connected
to - it's not based upon servers that are broadcasting.
The users should be able to type the server name or put in a
period (just "." without the quotes) or type in (local) to
connect to the local instance.
-Sue
On Fri, 10 Dec 2004 12:07:02 -0800, "Steven.Dahlin"
<StevenDahlin@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>The tool is Query Analyzer. As a another user I can run the tool and execute
>the connect function. This will pull a list of all servers that can be
>seen. The (local) server is not visible at all even though others on the
>network are and the local is running.
>Presumedly this accessing a broadcast feature of the servers. I do not know
>why the local cannot be seen.
>Steve
>"Sue Hoegemeier" wrote: