Hi Arun,
Please first read this and make sure you have the correct driver for SQL Server:
https://docs.appeon.com/appeon_online_help/pb2019/connecting_to_your_database/ch10s07.html
It says you need the v 10 driver, but I think the v 11 should be okay or even more compatible. Since you say that all is working fine on your developer machine:
You're getting the error "SQL native client is not installed ..", because indeed, it's not been installed.
"Client doesn't agree to install MSI?" Haha, we have a customer who would "only allow installs using MSI" anything else they don't like. But I know ... "customer is king", regretfully.
Plan A: Try to get someone (preferably of his own staff) to talk some sense into this customers head.
Plan B: If you are allowed to "import reg files", I guess one of your options might be to:
1) create a clean windows install on maybe a virtual machine, update all windows updates and then export the registry to "before.reg". (If you don't do the windows updates first you will get lots of differences with the registry exported in step 3) ).
2) install your of SNC sql server by using the MSI (as soon as possible, to avoid many registry differences in step 3)
3) export the registry to "after.reg".
4) compare all the differences in the registry files of "before" and "after.reg", using a tool like "araxis merge", "Meld", "windiff", etc. This will allow you to get all the registry entries that normally would have been done by the MSI installer.
There's also tools like the "Wix installer tool" to generate all the differences between the before and after registry (I think "heat.exe" should be able to do it), but let's keep it simple.
5) save those differences as "reg_entries_needed_for_SNC.reg".
6) Now you can copy "all the files" and run the registry to get a - hopefully valid - install of SNC SQL server client.
Good Luck!
