SQL Native Client Configuration TCP\IP

Question

I'm trying to setup a new DPM server 2022 on windows server 2022 i have installed MS SQL instance and configured SQL Native Client Configuration TCP\IP as DPM Requires

Still getting this error in the DPM setup log :

**DPM requires SQL Native Client Configuration TCP\IP to be enabled. Enable SQL Native Client Configuration TCP\IP on the DPM machine.**any idea or help why this is happening ?

Answer 1

Hi @Shad Qadir , 

SQL Server Network Configuration manages the network protocols used by SQL Server instances, applies to the server side, affecting how SQL Server listens for incoming connections.

SQL Native Client 11.0 Configuration manages the network libraries used by client applications to connect to SQL Server, applies to the client side, affecting how client applications connect to SQL Server.

Both configurations need to be properly set up to ensure smooth communication between the client and server. Please restart SQL server instance to make this configuration effect.

Did you install SQL server 2022? Per MS document Get DPM installed, if you plan to use SQL server 2022 with DPM 2022, ensure to install SQL server Native Client (SQLNCLI) on the SQL server machine before you install DPM 2022 RTM as SQL 2022 doesn't ship with SQLNCLI.

 

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it.

Answer 2

In the screenshot, you have highlighted the configuration for the SQL Server instance. But I read the error message to refer to the client-side configuration, which is the node below.