SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Account Password
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

kappa02
Yak Posting Veteran

58 Posts

Posted - 06/02/2009 :  11:12:30  Show Profile  Reply with Quote
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

USA
163 Posts

Posted - 06/02/2009 :  11:57:24  Show Profile  Send jholovacs a Yahoo! Message  Reply with Quote
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
Go to Top of Page

ecohen18
Starting Member

1 Posts

Posted - 12/16/2010 :  15:22:55  Show Profile  Reply with Quote
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?
Go to Top of Page

itsupport
Starting Member

India
5 Posts

Posted - 12/21/2010 :  04:13:35  Show Profile  Visit itsupport's Homepage  Reply with Quote
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>
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000