Re: restrict login to one instance

From: Fred Payne (fpayne_at_ryerson.ca)
Date: 10/29/03 

Date: Wed, 29 Oct 2003 14:34:41 -0500

I should have chosen my words better. There is only one instance of the
server installed. I want to restrict the user from login at multiple
workstations. I could restrict the workstation login via windows but I was
hoping for a SQL alternative

Fred

"Sue Hoegemeier" <Sue_H@nomail.please> wrote in message
news:iuqvpvgh875eeesv6s4pn10l0si0kiva6c@4ax.com...
> If you have installed multiple instances, each one is like
> it's own separate server in terms of security. So granting a
> login access on one instance on the server will not give
> that login access to other instances on the server. It's
> fine to set it up that way. You don't necessarily want every
> login to have access to every SQL Server instance.
>
> -Sue
>
> On Wed, 29 Oct 2003 10:57:19 -0500, "Fred Payne"
> <fpayne@ryerson.ca> wrote:
>
> >Hello All,
> > I'm using SQL Server 2000 and wish to restrict the user login to one
> >instance only. Is this possible? Is this wise?
> >
>

Relevant Pages

  • RE: howto let asigned user login destinated workstation
    ... among them we have 5 workstations ... our give them the rights to login every workstation i.e. any ... may be really setting up your network for failure. ... resources on their own server with very limited access to anything else. ...
    (microsoft.public.windowsxp.general)
  • gdm hangs
    ... gdm will hang 9 of 10 times when logging out. ... with or without the client having been connected to the Server. ... # Timed login, useful for kiosks. ... Must output the chosen host on stdout, ...
    (Debian-User)
  • Re: this should be so simple..... but it aint ... so far
    ... kinda lost wrote: ... you'll have to join the rest of the workstations to ... i can login sometimes as administrator and other times i get errors ... server and NOT to the new server ...
    (microsoft.public.windows.server.general)
  • RE: OWA 2003 with ISA 2004
    ... OWA externally. ... i can login by any user. ... 825763 How to configure Internet access in Windows Small Business Server ... g. Reproduce this issue and send the logs to me. ...
    (microsoft.public.windows.server.sbs)
  • Re: Compromised Server? Anyone recognize the suspect Services?
    ... there are a bunch of logins for Website Accounts created by the ... The login accounts are for web sites that are on the ... Server management is ... right under Network Connections there were 3 ...
    (microsoft.public.windows.server.networking)