Re: Disabling or renaming the sa account

From: Kalen Delaney (kalen_please_reply_on_public_newsgroups_delaney@compuserve.com)
Date: 12/30/02 

From: "Kalen Delaney" <kalen_please_reply_on_public_newsgroups_delaney@compuserve.com>
Date: Mon, 30 Dec 2002 08:58:44 -0800

In the future, please state which version of SQL Server you are using.
In addition to what Dejan mentioned, SQL Server 7 and 2000 have a server
role called sysadmin. If you add a login to that role, they have all the
rights and priviliges of 'sa'.

I have worked with clients who have 'disabled' the sa account by just giving
it an unbelievable complex password, and then not giving that password to
anybody.

HTH 

--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Ghulam Farid" <gfaryd@yahoo.com> wrote in message
news:#vn03v#rCHA.844@TK2MSFTNGP10...
>
> Hello
> can i disable the sa account and make some other account with the writes
> of sa account for security reasons. or can i rename the sa account. if
> so then how
> thanx.
> Farid
>
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!

Relevant Pages

  • Re: Error 15401 using sp_grantlogin (not addressed by current KB articles)
    ... Restarting Windows 2000 resolved the problem for this particular account, ... confused when it sees a duplicate SID. ... > One way to get SQL Server to agree with the renamed NT ... > Preview (to ensure the script was created), ...
    (microsoft.public.sqlserver.security)
  • Re: SharePoint V3 Install Error
    ... But it our case it had to do with Group Policies that forbid the account of ... WSS FAQ:www.wssv3faq.com/wss.collutions.com ... Event Source: WindowsSharePointServices3Search ... whatever you are installing WSS as sufficient rights to the SQL Server ...
    (microsoft.public.sharepoint.windowsservices)
  • RE: Problems with WebParts
    ... to a database called aspnetdb. ... > The connection string specifies a local SQL Server Express instance using a ... > server account must have read and write access to the applications directory. ... > This is necessary because the web server account will automatically create ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Cannot connect to Query Analyzer
    ... For Query Analyzer, I tried replacing the file as you suggested but had the ... same results (Enterprise Manager starts up fine, ... I created an account on my laptop and changed SQL ... Try replacing the MMC app for SQL Server from the original ...
    (microsoft.public.sqlserver.connect)
  • Problems with WebParts
    ... The connection string specifies a local SQL Server Express instance using a ... database location within the applications App_Data directory. ... server account must have read and write access to the applications directory. ... logged-in user needs the dbcreator privilege in the appropriate SQL Server ...
    (microsoft.public.dotnet.framework.aspnet)