I wanted to configure a separate SQL server to do a vCenter migration and I was getting errors to connect to the DB server, I was able to fix this issue after doing some changes in the SQL server. Here, I thought to post the steps that I took to resolve the issue. I believe this post will help others who involved with the configuration and resolve these type of issues in the middle of their configuration without wasting more time on this.
I have installed a fresh SQL 2008 R2 server with the custom SQL instance (SQL Express instance name is not the default one). Installed the relevant SQL Native client and tried to connect to the DB Server. It was throwing the below error message
a kermanDecember 30, 2018
this fixed my problems too
Aruna LakmalDecember 30, 2018
Thanks for the reply!
saikumarFebruary 27, 2020
I was also facing same issue where I have installed SQL server versions from online includes ….express additions.
But later on I have uninstalled all sql server versions installed on my machine and installed ENTERPRIZE SQL SERVER 2014 version which resolved my issue.
Aruna LakmalFebruary 28, 2020
Cool, Glad to hear it!