Re: SA Password

From: Ray Higdon (sqlhigdon_at_nospam.yahoo.com)
Date: 02/27/04


Date: Fri, 27 Feb 2004 07:23:05 -0500

You might run profiler to ensure no one is using SA before changing it,
also, you might announce to the IT department that you are changing it so
that if anything breaks it can be reasonably traced

-- 
Ray Higdon MCSE, MCDBA, CCNA
---
"JFleming" <anonymous@discussions.microsoft.com> wrote in message
news:E5C7435B-5CFF-455A-B767-E29BA68B1629@microsoft.com...
>
> Is it alright to change the sa password with users on the system?  No one
is using the sa account in any programs.


Relevant Pages

  • RE: Failed to start a new trace - SQL PROFILER
    ... Please explain what account you're logging into the ... Active Directory Domain User ... >"I am not able to start SQL profiler as well as SQL Query ... did you create new desktop shortcuts to Profiler ...
    (microsoft.public.sqlserver.security)
  • RE: Unable toconnect to database
    ... Hi, I ran profiler, did 2 things, in VS I clicked on "Shpow project portal", ... Now, if you open with tfsservice account, this account ... SQL Profiler doesn't capture any error. ...
    (microsoft.public.vsnet.general)