Community Tip - When posting, your subject should be specific and summarize your question. Here are some additional tips on asking a great question. X
Hi All,
I have tried to install Windchill 10.2M030 With Microsoft SQL Server Express Edition (64Bit) version,
I am facing below issue while executing PSI.
Issue - Validation Failed for SQL Server Client installation Directory as shown in below image,
We provided the required location as well, but still same issue.
Please let me know is anyone face same kind of issue.
Thanks,
Vivek
Hey Vivek,
The PSI is looking for your SQL Server installation location (specifically the sqlcmd.exe file) and is unable to find it.
The default location where Microsoft SQL Server 2014 is installed is in:
C:\Program Files\Microsoft SQL Server\110\Tools
The first thing I would try would be giving that value in the SQL Server Client Directory.
You didn't mention which SQL Server Express edition you were installing-
If you refer to the Windchill 10.2 Software Matrices (p. 9 & 10)
You will find that the supported SQL Server instances for Windchill 10.2 M030 are:
So please note that installing on SQL Server Express is not supportable by PTC and not recommended.
Also note that when installing SQL server you need to change the collation during installation:
The UTF-16 collation (Latin1_General_100_CS_AS_SC) is required. If upgrading the SQL Server from version 2005 or 2008 to version 2012 or 2014, the existing database collation must be changed from SQL_Latin1_General_CP1_CS_AS to the new supported collation Latin1_General_100_CS_AS_SC. For a detailed procedure, see “Changing SQL Server Database Collation” in the Windchill Upgrade Reference Guide: http://www.ptc.com/view?im_dbkey=155678