These two services are in stopped state or ‘Change pending’ Please enable SQL Server TCP/IP protocol and restart SQL Server service.
Author: Liwei
My name is Liwei, I joined Microsoft in 2011. Currently I am a SQL Server Support Escalation engineer.
Realcase: Failed to upgrade SQL Server 2016 SP2 CU11. (Installation success or error status: 1648)
One of my customer failed to upgrade SQL Server 2016 SP2 CU11. Here is the troubleshooting steps 1.Check SQL Server setup log(C:\Program Files\Microsoft SQL Server\130\Setup Bootstrap\Log\) Detailed… Read more “Realcase: Failed to upgrade SQL Server 2016 SP2 CU11. (Installation success or error status: 1648)”
Connect SQL Server from Linux Client using Windows Authentication and troubleshoot steps
Connect SQL Server from Linux Client using Windows Authentication is supported. Here are the Prerequisites. 1.As Kerberos is the only one supported, the Kerberos authentication needs to… Read more “Connect SQL Server from Linux Client using Windows Authentication and troubleshoot steps”
Different AG groups have the exactly same group_id value if the group names are same and the ‘CLUSTER_TYPE = EXTERNAL/NONE’
For external/none cluster type, since there is no orchestration, each replica needs to know how to independently determine the AG ID, thus the AG group name is… Read more “Different AG groups have the exactly same group_id value if the group names are same and the ‘CLUSTER_TYPE = EXTERNAL/NONE’”
An example of SQL Linux Windows Authentication configuration using Managed Service Accounts
Environment === Domain:contoso.com Linux server:red1(Redhat 7.6) MSA:msa01 SQL Server 2017 CU17 Red1 has joined the domain contoso.com(For information on how to join an active directory domain, see… Read more “An example of SQL Linux Windows Authentication configuration using Managed Service Accounts”
An example of Polybase for Oracle(TSQL)
Here is the topology of the environment SQL Server Oracle SQL Server 2019 RTM Oracle 11g Platform:Windows 2016 IP:192.168.1.31 Port:1521 SQL 2019 RTM does not support versions… Read more “An example of Polybase for Oracle(TSQL)”
Use Azure Data Studio to create external table for Oracle server.
Use T-SQL to create external tables for Oracle is cumbersome and error-prone. You may refer the article if you are interested. Today I’m going to show you… Read more “Use Azure Data Studio to create external table for Oracle server.”
Missing MSI and MSP files
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”
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”
SQL Server 