SQL Server Remote Management - Command Line Question

From: JDB (jbell_at_vitria.com)
Date: 06/20/04 

Date: Sun, 20 Jun 2004 15:38:09 -0500

As a Sys Admin, I was wondering - if I have admin rights to a Win2k machine
that is hosting SQL Server 2000, do I have the ability using any
command-line tools such as OSQL or ISQL to add, delete, or change accounts
registered in SQL Server for the various databases if I don't have access to
a specific account within SQL Server?

I ask, because the question that came up was - what if we have a DBA leave
under less than amicable circumstances? Could I, someone who has admin
rights on the machine, be able to log into that machine remotely and somehow
via command line (I don't maintain active SQL clients centrally), change the
SA password, remove an account, and/or add an account with sysadmin rights,
etc?

Thanks in advance for any help -

Relevant Pages

  • Re: Windows 2003 Users vs Software
    ... You need to have both an admin and a limited account ... >> as a limited user, to effect, "the software has not been installed ... The users do not have rights to install programs. ...
    (microsoft.public.security)
  • Re: Reboot command no longer works in Task Scheduler
    ... User rights assignment are set with a GPO located under Computer configuration, windows settings, security settings,local policies. ... Check there if the account, even the domain admin has the needed rights. ...
    (microsoft.public.win2000.general)
  • Re: Lost admin access to ADAM
    ... Firewall may be doing harm here. ... SDE, DS Admin eXperience ... This posting is provided "AS IS" with no warranties, and confers no rights. ... User account: NETWORK SERVICE ...
    (microsoft.public.windows.server.active_directory)
  • Re: Lost admin access to ADAM
    ... admins) as ADAM admin principal, as opposed to a specific user. ... use your domain account to connect (provided this account is a member of ... This posting is provided "AS IS" with no warranties, and confers no rights. ... If I install with my account (which has has local ...
    (microsoft.public.windows.server.active_directory)
  • Re: Lost admin access to ADAM
    ... User account: NETWORK SERVICE ... admins) as ADAM admin principal, as opposed to a specific user. ... This posting is provided "AS IS" with no warranties, and confers no rights. ... If I install with my account (which has has local ...
    (microsoft.public.windows.server.active_directory)
Loading