TMS INSTALL ISSUE 15.7.0

[Chet Cronin]

TMS server failed and we built new one on windows 2016  and also moved the old tmsdb SQL file to the new SQL server.

Problem is when running the installation app at the database settings window I entered both the IP address and the DNS address and getting error it can't find the SQL server.   The SQL client msodbcsql is installed on the TMS windows server. 

Any ideas folks ?? 

[Wayne DeNardi · Accepted solution]

Assuming your SQL server is not on the same box as TMS, did you remember to install the SQL Native Client on the TMS Server?

As per the install guide:

If Cisco TMS and SQL Server are hosted on different servers, SQL
Native Client 11 must be installed on Cisco TMS Server before
installation or upgrade of Cisco TMS. Ensure that Native Client
13.0.1601.5 or later version is installed

Also make sure thar the SQL Server Browser is running on the SQL Server.

There are some good Troubleshooting steps and references in the Troubleshooting section of the Install Guide from Page 60.