Re: restrict login to one instance

From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 10/29/03 

Date: Wed, 29 Oct 2003 14:07:33 -0700

Don't think there is a SQL alternative to that. You could
always monitor for a particular hostname (workstation) but
that's not necessarily reliable and you can't prevent the
user from logging in, it just allows you to kill their SPID
after the fact.

-Sue

On Wed, 29 Oct 2003 14:34:41 -0500, "Fred Payne"
<fpayne@ryerson.ca> wrote:

>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: "Classic logon" screen in XP does not remeber the user name
    ... I went to the workstation. ... does not show up on the server when I log onto the ... as I get to the login screen of the ... "Local security policy does not allow interactive login on this machine". ...
    (microsoft.public.windowsxp.security_admin)
  • Re: Login Failures - 529/537 Errors
    ... Please post the ipconfig/all from the server and a client? ... > workstation, then login successfully but will not be able to access shared ... they will have to manually provide their login ... > their whole network connection dies. ...
    (microsoft.public.windows.server.sbs)
  • Re: Cannot unlock workstation
    ... screensaver kicks in they can't unlock it. ... >When i locked the workstation i had to reboot the machine ... >and i have done many modifications to secure the server, ... >> login as Admnand reset my ...
    (microsoft.public.win2000.security)
  • Re: Login problems
    ... If it works at a different workstation it wouldn't seem that the problem is ... the server, as that hasn't changed, only the workstation has. ... I have a windows 2003 server running sharepoint services 2.0. ... begin to constantly be prompted by sharepoint to login. ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: SA Login
    ... sa can do anything to the server. ... > We are using sql authentication, the client insists on ... > having the SA login to maintain other dB's on the same ... Is there a way to deny the SA login access to a ...
    (microsoft.public.sqlserver.security)