Account Password - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Account Password

Author

Topic

kappa02
Yak Posting Veteran

65 Posts

Posted - 2009-06-02 : 11:12:30

I know it may sounds crazy but should accounts such as these have a password:

##MS_SQLAuthenticatorCertificate##
##MS_AgentSigningCertificate##
##MS_SQLReplicationSigningCertificate##
##MS_SQLResourceSigningCertificate##

Or is that they should be set to null (which sound just as crazy)

jholovacs
Posting Yak Master

163 Posts

Posted - 2009-06-02 : 11:57:24

the system manages these accounts via certificate, right? Can't imagine why you'd try to manually assign passwords.

SELECT TOP 1
w.[name]
FROM
dbo.women w
INNER JOIN
dbo.inlaws i
ON
i.inlaw_id = w.parent_id
WHERE
i.net_worth > 10000000
AND
i.status IN ('dead', 'dying')
AND
w.husband_id IS NULL
ORDER BY
w.hotness_factor DESC

ecohen18
Starting Member

1 Post

Posted - 2010-12-16 : 15:22:55

One of my clients is working on hardening thier security. The certificate created accounts have been identified as accounts with no or null passwords.

Example:
##MS_SQLResourceSigningCertificate##

What can I do to dissalow NULL password login sessions?

itsupport
Starting Member

5 Posts

Posted - 2010-12-21 : 04:13:35

I dont agree to this . There can be various ways for the same.

Regards,

<a href="http://www.it-support-service.com">Server Management Service</a> |
<a href="http://www.it-support-service.com">Application Management Service</a>

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources