If you hit missing MSI/MSP issue, suggest them to try the FixMissingMSI tool developed by Simon https://blogs.msdn.microsoft.com/psssql/2018/01/24/sql-setup-toolsuite-introduction-1-fixmissingmsi/ Here is how SQL Server work with MSI/MSP files, you… Read more “Missing MSI and MSP files”
Month: November 2019
You may fail to backup log or restore log after TDE certification/key rotation
When TDE is enabled, all the records written to transaction log files are encrypted as well. During the TDE certification/key rotation, these log records are not touched.… Read more “You may fail to backup log or restore log after TDE certification/key rotation”
Password is required when adding a database to AG group if the database has a master key
When you are trying add a database having a ‘master key’ to a AG group, you will see the message in SSMS. You can’t move to next… Read more “Password is required when adding a database to AG group if the database has a master key”
Process ID and application name are NULL when you connect SQL Server in Linux
When you run DMV sys.dm_exec_sessions , sys.sysprocesses to check the process id/application, these DMVs return NULL. This is a bug that has been fixed in ODBC 17.4.2.… Read more “Process ID and application name are NULL when you connect SQL Server in Linux”
Use KTPASS instead of adden to configure mssql.keytab
There is a known issue with the krb5 library that is shipped on RHEL(7.3, 7.4, 7.5, or 7.6) and Ubuntu(16.04) where AES keys are incorrectly salted on… Read more “Use KTPASS instead of adden to configure mssql.keytab”
Error 15404 ‘Could not obtain information about Windows NT group/user ‘%ls’, error code 0x80090304′
Your SQL Linux has been joined to domain and you can connect to the SQL Server instance using Windows Authentication. The connection itself is fine, but when… Read more “Error 15404 ‘Could not obtain information about Windows NT group/user ‘%ls’, error code 0x80090304′”
My First Blog Post
My name is Liwei, I was a SQL Server MVP in 2010 and 2011. Then I joined Microsoft. Currently I am a SQL Server Support Escalation Engineer… Read more “My First Blog Post”
SQL Server 