SQL Server / The target principal name is incorrect. Cannot generate SSPI context

SQL Server / The target principal name is incorrect. Cannot generate SSPI context
One of our old SQL servers was running under the local system context. Then we decided to change the account that the SQL service runs under, and we created domain service account with basic domain user permissions. Eventually, we end up with following error trying to access our SQL Server remotely.   SQL Server SPN Creation To run SQL Server service you can use Local System account, local user account or a domain user account. If you are using Local System account to run your SQL Service the SPN will be automatically registered. ...
read more

Microsoft SQL Server 2017 Updates / RTM (14.0.1000.169)

Microsoft SQL Server 2017 Updates / RTM (14.0.1000.169)
SQL SERVER 2017 RTM Update Version: MSSQL 2017 RTM CU-22, Build: 14.0.3356.20, KB: KB4577467, Release Date: September 2020, Download: https://support.microsoft.com/en-us/help/4577467/kb4577467-cumulative-update-22-for-sql-server-2017; Update Version: MSSQL 2017 RTM CU-21, Build: 14.0.3335.7, KB: KB4557397, Release Date: July 2020, Download: https://support.microsoft.com/en-us/help/4557397/kb4557397-cumulative-update-21-for-sql-server-2017; Update Version: MSSQL 2017 RTM CU-20, Build: 14.0.3294.2, KB: KB4541283, Release Date: April 2020,...
read more

Microsoft SQL Server 2016 Updates / RTM (13.0.1601.5) / SP1 (13.0.4001.0 or 13.1.4001.0) / SP2 (13.0.5026.0 or 13.2.5026.0)

Microsoft SQL Server 2016 Updates / RTM (13.0.1601.5) / SP1 (13.0.4001.0 or 13.1.4001.0) / SP2 (13.0.5026.0 or 13.2.5026.0)
SQL SERVER 2016 SP2 Update Version: MSSQL 2016 SP2 CU-15, Build: 13.0.5850.14 / 13.2.5850.14, KB: KB4577775, Release Date: September 2020, Download: https://support.microsoft.com/en-us/help/4577775/kb4577775-cumulative-update-15-for-sql-server-2016-sp2; Update Version: MSSQL 2016 SP2 CU-14, Build: 13.0.5830.85 / 13.2.5830.85, KB: KB4564903, Release Date: August 2020, Download: https://support.microsoft.com/en-us/help/4564903/kb4564903-cumulative-update-14-for-sql-server-2016-sp2; Update Version: MSSQL 2016 SP2 CU-13, Build: 13.0.5820.21 /...
read more

Microsoft SQL Server 2014 Updates / RTM (12.0.2000.0) / SP1 (12.0.4100.1 or 12.1.4100.1) / SP2 (12.0.5000.0 or 12.2.5000.0) / SP3 (12.0.6024.0 or 12.3.6024.0)

Microsoft SQL Server 2014 Updates / RTM (12.0.2000.0) / SP1 (12.0.4100.1 or 12.1.4100.1) / SP2 (12.0.5000.0 or 12.2.5000.0) / SP3 (12.0.6024.0 or 12.3.6024.0)
SQL SERVER 2014 SP3 Update Version: MSSQL 2014 SP3 CU-4 SECURITY UPDATE, Build: 12.0.6372.1 / 12.3.6372.1, KB: KB4535288, Release Date: February 2020, Download: https://support.microsoft.com/en-us/help/4535288/description-of-the-security-update-for-sql-server-2014-sp3-cu4-feb; Update Version: MSSQL 2014 SP3 CU-4, Build: 12.0.6329.1 / 12.3.6329.1, KB: KB4500181, Release Date: July 2019, Download: https://support.microsoft.com/en-us/help/4500181/cumulative-update-4-for-sql-server-2014-sp3; Update Version: MSSQL 2014 SP3 CU-3, Build: 12.0.6259.0...
read more

Microsoft SQL Server 2012 Updates / RTM (11.00.2100) / SP1 (11.0.3000.0 or 11.1.3000.0) / SP2 (11.0.5058.0 or 11.2.5058.0) / SP3 (11.0.6020.0 or 11.3.6020.0) / SP4 (11.0.7001.0 or 11.4.7001.0)

Microsoft SQL Server 2012 Updates / RTM (11.00.2100) / SP1 (11.0.3000.0 or 11.1.3000.0) / SP2 (11.0.5058.0 or 11.2.5058.0) / SP3 (11.0.6020.0 or 11.3.6020.0) / SP4 (11.0.7001.0 or 11.4.7001.0)
SQL SERVER 2012 SP4 Update Version: MSSQL 2012 SP4 SECURITY UPDATE, Build: 11.0.7493.4 / 11.4.7493.4, KB: KB4532098, Release Date: February 2020, Download: https://support.microsoft.com/en-us/help/4532098/security-update-for-sql-server-2012-sp4-gdr; Update Version: MSSQL 2012 SP4 HOTFIX, Build: 11.0.7469.6 / 11.4.7469.6, KB: KB4091266, Release Date: March 2018, Download: https://support.microsoft.com/en-us/help/4091266/on-demand-hotfix-update-package-for-sql-server-2012-sp4; Update Version: MSSQL 2012 SP4 SECURITY UPDATE, Build: 11.0.7462.6 /...
read more