ALZDBA (12/9/2011)

---

Nice article. And what's most important .... It will help people diagnose and solve this kind of issues !

With fixed ports, you can also register the spn yourself ( after install of the instance ) using this

DOS script

echo off

rem http://blogs.msdn.com/sql_protocols/archive/2005/10/12/479871.aspx

rem To create an SPN for SQL Server, enter the following code at a command prompt:

rem setspn -A MSSQLSvc/Host:port serviceaccount

rem For example:

rem setspn -A MSSQLSvc/server1.redmond.microsoft.com sqlaccount

echo on

rem C:\Program Files\Support Tools\setspn -A MSSQLSvc/yourservername.yourdomain.yourdomainsuffix:2388 DOMAIN\SERVICEACCOUNT