0
i have installed a SQL2008 Server developer-Edition on my Dell Precision M90 Notebook with windows Vista, but the service dosen't start. SQL Server Configuration Manager shows MSSQLSERVER as stopped and an attempt to start this service fails. No entry in eventviewer... where to look? What might be the reason?
Ice
Posted 2010-03-27T17:12:50.757
Reputation: 599
Interactive start on a command prompt shows at least the following: 2010-03-27 20:59:58.06 Server The SQL Server Network Interface library coul d not register the Service Principal Name (SPN) for the SQL Server service. Erro r: 0x54b, state: 3. Failure to register an SPN may cause integrated authenticati on to fall back to NTLM instead of Kerberos. This is an informational message. F urther action is only required if Kerberos authentication is required by authent ication policies. – Ice – 2010-03-27T20:02:52.893
I think this is just a warning, which I think can be avoided by starting the server as LocalSystem.
Do you get messages like 'The SQL Server (MSSQLSERVER) service is starting' and 'The SQL Server (MSSQLSERVER) service was started successfully? – sgmoore – 2010-03-27T20:34:25.927
That is the issue, no other message than this 'Server Principal Name' - thing. The SQL-Server Log shows in detail how sql-server is starting, looks like ever but at the end there is the posted message. As the sql-server is configured not to accept sql-login there is no chance to work with it. This is a Show-Stopper. – Ice – 2010-03-27T22:01:57.300