There are tons of people using AWS. There are tons of people running Windchill. There are tons of people running SQL Server. Is there anybody out there running Windchill and SQL Server on AWS? I've been trying for days, along with PTC tech support to install Windchill on an AWS instance. It just will not connect to SQL Server no matter what we try.
Yes, we are using supported versions of everything. SQL Server 2016 Enterprise Edition with Service Pack 1. Microsoft Windows Server 2012 R2 RTM 64-bit Locale English AMI provided by Amazon. Windchill 11.
SQL Server appears to be installed correctly We can log into it using the Microsoft SQL Server Management Studio (SSMS) tool but the PTC Solution Installer (PSI) refuses to connect to it. "Failed to connect to the database. Please check the login credentials (Hostname, Instance name, Port number and User connection information)."
The problem turned out to be that the AWS Instance machine name needed to be added to the hosts file, along with its private ip address. The hosts file is located at: C:\Windows\System32\drivers\etc\hosts