http://blogs.technet.com/b/configurationmgr/archive/2010/10/26/troubleshooting-duplicate-or-missing-spns-for-a-configmgr-2007-sql-database.aspxThis blog post addresses a common problem customers face during the installation of System Center Configuration Manager 2007 in which the following error appears: “Setup failed to install SMS Provider.” When this error occurs, there are several possibleen-USTelligent Evolution Platform Developer Build (Build: 5.6.50428.7875)http://blogs.technet.com/b/configurationmgr/archive/2010/10/26/troubleshooting-duplicate-or-missing-spns-for-a-configmgr-2007-sql-database.aspx#3383399Fri, 28 Jan 2011 22:07:42 GMTd5e57398-b9ef-4490-9955-07cbb4e4a80d:3383399Chris Mullins<p>Its been my experience (and I&#39;ve done twenty or more of these types of installs), that I need to do more than just those particular SPNs. I need to add two more (FQDN + Netbios name) omitting the ports. </p> <p>MSSQLSvc/servername:port</p> <p>MSSQLSvc/servername.domain.com:port</p> <p>MSSQLSvc/servername</p> <p>MSSQLSvc/servername.domain.com</p> <p>I&#39;ve tried using just the first two entries, and 9 times out of 10, I&#39;ll continue to get the SMSProv error. Add the last two SPN entries, and I&#39;m good to go. </p> <div style="clear:both;"></div><img src="http://blogs.technet.com/aggbug.aspx?PostID=3383399" width="1" height="1">http://blogs.technet.com/b/configurationmgr/archive/2010/10/26/troubleshooting-duplicate-or-missing-spns-for-a-configmgr-2007-sql-database.aspx#3367921Fri, 12 Nov 2010 10:07:52 GMTd5e57398-b9ef-4490-9955-07cbb4e4a80d:3367921Louis Reedijk<p>after hours of trying and testing, it turns out that you manually have to TYPE the line with setspn, do NOT copy &amp; paste, this will not work</p> <div style="clear:both;"></div><img src="http://blogs.technet.com/aggbug.aspx?PostID=3367921" width="1" height="1">