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.
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 wINNER JOIN dbo.inlaws i ON i.inlaw_id = w.parent_idWHERE i.net_worth > 10000000 AND i.status IN ('dead', 'dying') AND w.husband_id IS NULLORDER 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> |
|
|
|
|
|