These two services are in stopped state or ‘Change pending’ Please enable SQL Server TCP/IP protocol and restart SQL Server service.
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 results: Feature: Database […]
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 work between the […]
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 used in hash. […]
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 Join SQL Server […]
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 greater than 12.1, […]
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 how to use […]