Post reply

KB960090

  • February 23, 2009 at 5:30 am

    #197439

    Hi guys

    This last weekend there was an automated deployment of KB960090 to our SQL cluster.

    We only patched one of our cluster nodes but when the patching was complete and the server restarted the SQL Server Authentication mode had changed from 'SQL Server and Windows Authentication mode' to 'Windows Authentication mode' only.

    Is it possible that this patch could have made a change like that?

    The only other explaination is that one of our DBA's made this change and it only took effect now due to the server instance being restarted. This would be very unlikely since this would be a very deliberate change. (In a production environment)

    Any thoughts, advise...?

    Thanks in advance.

  • February 23, 2009 at 9:54 am

    #948731

    SQL Server MVP Aaron Bertrand has posted about seeing this behavior when installing SQL Server 2005 SP3:

    My latest SP3 experiences - two thumbs acting like divining rods

    Not seeing a connect ID for the bug, though, so I posted on Aaron's blog. You might file a bug report at connect.microsoft.com with reference to this security patch installation.

    K. Brian Kelley
    @kbriankelley

  • February 23, 2009 at 10:52 am

    #948767

    Thanks for the reply. I found the solution.

    Turns out when SQL security patches are automatically deployed it used the default setting for the patch. In this case the securtity defaults were 'Windows Authentication'.

    Problem solved.

  • February 24, 2009 at 12:25 am

    #949164

    automated deployment ... as in unattended deployment ... on a cluster ?

    Lovely to see this behaviour :sick:

    Another reason we still perform the upgrades with (requested) planned downtime and under strickt control of the sysadmins.

    (sequence = sysadminTest, Dev, QA, Prod-standalone, Prod-clusters)

    Thank you for the feedback.

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data/code to get the best help[/url]

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Need a bit of Powershell? How about this

    Who am I ? Sometimes this is me but most of the time this is me

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply