Re: restrict login to one instance

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

Date: Wed, 29 Oct 2003 09:36:14 -0700

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: msde under user group accounts
    ... The user or group that needs to connect to the MSDE instance needs to have ... login access to the server and permissons on the database. ... > If i switch to a limited user account, i cannot access the database. ...
    (microsoft.public.sqlserver.msde)
  • How to login in MsSqlServer
    ... I disable administrator and BUILTIN\administrators's ... access right, only the sa have login access, Now I can't ... login in to the server, ... iUsr_MachineName to the Sql Server account, ...
    (microsoft.public.sqlserver.security)
  • Re: SA Login
    ... When you create a new instance of SQL Server 2000 on a given server, ... > 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)
  • 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)
  • RE: SBS 2003 Unable to connect to database STS_Config
    ... Uninstall the SQL server from the SBS 2k3 server from add/remove programs ... Uninstall Microsoft SQL Server Desktop Engine (SHAREPOINT) ... If AV software install any extra IIS virtual directory, ...
    (microsoft.public.windows.server.sbs)