RE: Storing Password

Hi Jamie, I was even thinking that I might not store the sa password at all.
Just set it to a strong password and then forget about it since everyone is
using windows authentication or a different sql login to acces the server. At
the moment I'm storing the password on my pc in an encrypted password safe
that only I have the pass key.

Adam

"thejamie" wrote:

I did what you suggested as a matter of course... I would just as soon that
the other sysadmin's login with their Windows Authority and explain to them
there is no difference between logging in as a system admin or using the sa
password.

If they have the sysadmin status, what difference does it make whether they
know the sa password or not? I'd actually like to hear your take on this as
I am struggling with it myself. Why should the sa password be known by
anyone other than myself and perhaps the network administrator or my direct
superior? I haven't found a really GOOD reason yet but there are lots of
"what if's" to contend with.
--
Regards,
Jamie


"Adam Sankey" wrote:

Hello, I work in a team of 4 dba's. In order to save passing sa passwords
around I'm going to add a Windows group on each server and add this group
into SQL Server as a memeber SysAdmin role. I can also add the service
account into this role (we use the same service account for the server and
the server agent - is this bad?).

If I still want to store the sa password, who is best to do that or should I
not bother just set it to a different strong password on a regular basis and
forget it since I'm not goin gto use it. How about storing othe rlogin \
paswords?

Thanks
Adam
.

Relevant Pages

  • HP OfficeJet 6210/7210/PSC 750 printers & Windows Server 2003 w/Terminal Services
    ... I'm trying to help a client setup a Windows Server 2003 platform to ... a HP OfficeJet 6210, the other has an OfficeJet 7210 printer. ... attempting to setup support for each store so they can use Terminal ... Services/Remote Desktop into the server to use their application, ...
    (comp.sys.hp.hardware)
  • Re: HP OfficeJet 6210/7210/PSC 750 printers & Windows Server 2003 w/Terminal Services
    ... I'm trying to help a client setup a Windows Server 2003 platform to ... attempting to setup support for each store so they can use Terminal ... Services/Remote Desktop into the server to use their application, ... still have the ability to print to their local HP OfficeJet printers. ...
    (comp.sys.hp.hardware)
  • Permission error while migrating from Exchnage5.5 to exchange 2003
    ... I have upgraded Windows NT 4. ... acting as a front end server and ExchngSRV2 is acting as a backend server has ... I installed Exchange 2003 on separate windows ... Could not log onto the Message store for Account” ...
    (microsoft.public.exchange.admin)
  • Re: Mailbox Store (SERVER)" cannot be read
    ... I am using the built in NTBackup in Windows 200 server ... "Candee" wrote: ... >> store. ...
    (microsoft.public.exchange2000.information.store)
  • SecurityFocus Microsoft Newsletter #154
    ... MICROSOFT VULNERABILITY SUMMARY ... ISS RealSecure Server Sensor SSL Denial Of Service Vulnerabi... ... Roger Wilco Remote Server Side Buffer Overrun Vulnerability ... available for Microsoft Windows operating systems. ...
    (Focus-Microsoft)