April 3, 2018 at 9:28 am
Hello experts,
I have a noob question. Do the following server principals get re-created each time a SQL Server is restarted? I am trying to better document the logins on my servers and noticed that the creation date for these logins is fairly recent, like within the past month.
##MS_AgentSigningCertificate##
##MS_PolicyEventProcessingLogin##
##MS_SmoExtendedSigningCertificate##
##MS_PolicySigningCertificate##
##MS_SQLAuthenticatorCertificate##
##MS_SQLReplicationSigningCertificate##
##MS_SQLResourceSigningCertificate##
Thanks for any help.
- webrunner
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
April 3, 2018 at 10:54 am
webrunner - Tuesday, April 3, 2018 9:28 AMHello experts,I have a noob question. Do the following server principals get re-created each time a SQL Server is restarted? I am trying to better document the logins on my servers and noticed that the creation date for these logins is fairly recent, like within the past month.
##MS_AgentSigningCertificate##
##MS_PolicyEventProcessingLogin##
##MS_SmoExtendedSigningCertificate##
##MS_PolicySigningCertificate##
##MS_SQLAuthenticatorCertificate##
##MS_SQLReplicationSigningCertificate##
##MS_SQLResourceSigningCertificate##Thanks for any help.
- webrunner
Mine have the create date being of the date of last CU applied. None of them are updated from restarts.
Sue
April 3, 2018 at 10:57 am
Sue_H - Tuesday, April 3, 2018 10:54 AMwebrunner - Tuesday, April 3, 2018 9:28 AMHello experts,I have a noob question. Do the following server principals get re-created each time a SQL Server is restarted? I am trying to better document the logins on my servers and noticed that the creation date for these logins is fairly recent, like within the past month.
##MS_AgentSigningCertificate##
##MS_PolicyEventProcessingLogin##
##MS_SmoExtendedSigningCertificate##
##MS_PolicySigningCertificate##
##MS_SQLAuthenticatorCertificate##
##MS_SQLReplicationSigningCertificate##
##MS_SQLResourceSigningCertificate##Thanks for any help.
- webrunner
Mine have the create date being of the date of last CU applied. None of them are updated from restarts.
Sue
" the date of last CU applied" - thanks! I think that's the answer.
- webrunner
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply