I'm running the evaluation software on a development machine running XP and everything was fine until I installed SP1. Now I can't get services to run, and the error log displays:
"The SQL Network Interface library could not deregister the Service Principal Name (SPN) for the SQL Server service. Error: 0x2098. Administrator should deregister this SPN manually to avoid client authentication errors."
Looking through previous questions, I see similar issues where the SPN needs to be deregistered, but my problem looks different; I can't even load services on local only. I'm downloading the SP2 from November, but thought I'd see if anyone else is/has had similar issues.
This is what Microsoft says about SP1:
http://download.microsoft.com/download/b/d/1/bd1e0745-0e65-43a5-ac6a-f6173f58d80e/ReadmeSQL2005SP1.htm#_1463_uninstalling_sql_server_2005_sp1_fzpy
So unfortunately you can't remove SP1, you have to reinstall.
|||Mm... I was hoping someone had seen the issue and had a less drastic fix, but if that's the only way, I guess it'll have to do. Just wish I could get the local up and running so I could script out my tables and sp's, etc.
Thanks just the same
