September 28, 2007 at 9:19 am
Has anyone ever run into an issue where during a Service Pack upgrade to SP2 the authentication mode changes? If so what is the root cause?
September 28, 2007 at 9:39 am
You mean the SQL server changed from SQL-ONLY Authentication to mixed authentication (or vice-versa)?
Never heard of that if that is the case. But it shouldn't be a big deal to switch back if that is the case.
The Redneck DBA
September 28, 2007 at 9:41 am
Yes. We changed it back, but I'm trying to explain why it happened to a bunch of managers.
September 28, 2007 at 9:46 am
Interesting. That's a new one on me.
I've upgraded about half a dozen or so to SP2, and I don't recall changing the authentication mode even being an option in that process. Are you certain it's related to the SP2 install?
I don't know if it matters, but were you upgrading from the RTM or SP1 version? I know there have been some issues with some odd things happening to maint. plans when upgrading from RTM to service packs, I suppose it's possible there is something that happens to authentication, but I can't imagine it's that common.
The Redneck DBA
September 28, 2007 at 9:53 am
It was an upgrade from SP1 to Sp2.
September 28, 2007 at 11:31 am
I think I finally found the issue:
The SQL Network Interface library could not register the Service Principal Name (SPN) for the SQL Server service. Error: 0x2098, state: 15. Failure to register an SPN may cause integrated authentication to fall back to NTLM instead of Kerberos. This is an informational message. Further action is only required if Kerberos authentication is required by authentication policies.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply