user and group permissions

From: Gabriel (anonymous_at_discussions.microsoft.com)
Date: 01/10/05 

Date: Mon, 10 Jan 2005 07:28:16 -0800

Hello,

Is it possible to deny access to local NT administrator
and one specific domain user on sql server cluster? The
cluster runs under domain user account with adminstrator
privileges on the local machine, I have another domain
user account, it is my personal account - but this one
should have no access to the sql server database. For
server administration I use local NT administrator - and
of course this account can access sql server with
adminstrator privileges - but I would like to deny this
access.
The easiest way would be probably blocking all NT builtin
admin accounts and domain admin accounts to access SQL
Server, except one domain account - which runs SQL Server
instance. Can this be done somehow?
thanks

Relevant Pages

  • Re: Workaround for 0x8007045A (!)
    ... works if you log on to the administrator account of a workstation attached to ... in a fit of social conscience that might help other WU5 ... domain account under previous versions of SBS were now missing. ... on as domain user and WU5 doesn't work. ...
    (microsoft.public.windowsupdate)
  • Re: BULK Insert Problem
    ... Vyas, MVP (SQL Server) ... I Log on to my system using the Local System Administrator Account. ... And If I Try to Bulk Insert any thing from my ...
    (microsoft.public.sqlserver.programming)
  • Re: SQL Agent cannot run DTS packages that contain Analysis Services tasks
    ... >The source of the problem seems to be the Windows account the agent runs as. ... >into an administrator on the server where MS Analysis Services is installed. ... Darren Green (SQL Server MVP) ...
    (microsoft.public.sqlserver.dts)
  • Re: MSSQL$SBSMONITORING Login to Disabled Account?
    ... SQL Server installed, I can't have the tools you were using, can I? ... I still don't know what that process is doing trying to login to the ... Administrator account and I don't understand why this login attempt is ...
    (microsoft.public.windows.server.sbs)
  • Re: Microsoft Search service cannot be administered under the present user error SP3
    ... - Have not modified Administrator account, but i ran the SQL script anyway. ... SQL account is not a local administrator. ... > has this server ever been upgrade from SQL Server 7.0 or is this SQL ...
    (microsoft.public.sqlserver.fulltext)
Loading