cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Windchill and SQL Server on Amazon Web Services

Highlighted
Contributor

Windchill and SQL Server on Amazon Web Services

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)."

 

Please help!

1 REPLY 1

Re: Windchill and SQL Server on Amazon Web Services

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

Entries look like this:

172.31.23.250 win-qa82kt1om0p.us-west-2.compute.internal
172.31.23.250 win-qa82kt1om0p