Server admin/service account - too many users

Hi,
I have a problem which needs resolving fairly quickly.. We have a
Win2003 AD server and 5 Win2000 member servers performing various
duties on the LAN. On the Win2000 servers I have an account which
allows the SQL developers to log on locally & remotely to perform tasks
but need to rescind this now due to some data delteions form SQL &
files overwrites in IIS! The developers have dev servers to work from
but I think there may have been a mix up & they copied the dev
directory to live casuing downtime to the website.

Is their a best practice for me, as I know if I simply change the
account password, services will not run such as SQL2000 , Veritas
backup exec server and their backup agents to name a few. I basically
want these servers locked down for anyone except the IT Director &
myself as we cannot afford to have data deleted from both drives & SQL!

Any advice would be much appreciated.
G

.

Relevant Pages

  • Re: sql 2005 active/passive cluster options
    ... that is storing data on a seperate SQL 2005 Standard box. ... SQL server had an hardware fault causing application downtime for ... their product is an active/passive sql cluster. ... terms of active/passive failover I need two identical servers (since ...
    (microsoft.public.sqlserver.clustering)
  • RE: permissions compatible with pre-Win2000 servers
    ... Based on your reply, the NT machine which running SQL 7 is not a PDC, BDC, ... With regards to the anonymouse connection to SQL, ... >Our concern is for our NT4 servers that are dedicated to running SQL7 ...
    (microsoft.public.windows.server.migration)
  • Re: Performance Monitor / Database Storage using ODBC
    ... This solution would be just working temporarily (a few servers), ... Andrew J. Kelly SQL MVP ...
    (microsoft.public.sqlserver.tools)
  • Re: Web App Security Model.
    ... SQL permissions are correctly restrictive (so worse case the allowed ... If these machines are standalone the threats posed by them are ... applications / implementation and whether their design has ... My company wants to have a few Windows Servers running web app's (ASPX ...
    (microsoft.public.security)
  • SQL Server 2005 Version Confusion
    ... We installed SP2 on all our dev servers before March 5th. ... server that have new SP2 applied, the GDR is automatically applied. ...
    (microsoft.public.sqlserver.setup)