08-30-2019 12:20 PM
Hello,
I am receiving the error "Could not connect to SQL server:Named Pipes Provider:Could not open a connection to SQL Server" during the installation page of TMS. Here's my current lab environment:
TMS Server:
2016 Server 64 bit
.Net 4.7.1
SQL Native Client 11
SQL Server:
2016 Server 64 bit
SQL 2017 Express 64 bit
I've tried enabling and disabling Named Pipes, TCP is enabled on the SQL Manager. Turned off firewall rules on both servers. Not sure what else could be the problem.
Thanks,
Aaron
09-04-2019 12:50 AM - edited 09-04-2019 12:51 AM
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 (you didn't mention which version you were running).
Please remember to mark helpful responses and to set your question as answered if appropriate.
09-04-2019 07:06 AM
Hi Wayne,
I forgot to the put the version but I do have that version installed for the Native Client. I've actually figured out the issue and have TMS installed. I had to launch the SQL Configuration Manager, under SQL Server Network Configuration, click on Protocols for SQLEXPRESS, double click TCP/IP, click IP Adress tab, scroll down to IPAII and set TCP/IP to 1433.
Thanks,
Aaron
09-04-2019 08:36 PM
Port 1433 is the default port for SQL Server, so it should have been set that way already unless for some reason you had changed it previously.
Please remember to mark helpful responses and to set your question as answered if appropriate.
05-13-2021 09:59 PM - edited 05-13-2021 10:02 PM
Thank you for this solution.
Also, wanted to add, to make sure on the "Protocol" TAB, the "Enable" value is "Yes"
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide