SQL Server Connection failed with jTDS JDBC Driver – SSPI handshake failed with error code 0x80090302, state 14 while establishing a connection with integrated security; the connection has been closed.

This is a quick blog post about one error that I encountered earlier last week. One customer has a web application from VMWare uses jDTS open source JDBC driver to connect with SQL Server, and it failed with the following error message: 2013-07-17 17:33:22.01 Logon       Error: 17806, Severity: 20, State: 14.2013-07-17 17:33:22.01 Logon       SSPI handshake failed with…

4

SQL Server cluster failover fails with Error Code: 0x80071398

I have installed a 3-node SQL Server 2012 failover cluster on Windows Server 2012 few days ago, and it has been running very well. Until today, I found that I could not manually failover the SQL cluster service from node 3 to node 1, and failed with the following information: The operation has failed The…

10

An example to PIVOT on a column with undermined unique values

SQL Server T-SQL PIVOT is a great feature that you can turn the unique values from one column into multiple into multiple columns in the output table result. It also works great if you can iterate all unique values in the column to be pivoted , but the problem is that sometimes you don’t know…

0

SQL Server can’t start after accidently set the "max server memory" to 0

One of my customer accidently set the “max server memory” of SQL Server to 0, and then the server can’t start after that. If we try to start SQL Server from SQL Server Configuration Manager, it failed to start (esp. when you have several active databases), and in the SQL Server error log file, we…

4