Thinking about running Windchill® 9.1 on SQL Server? Then you’ll want to know about versions and compatibility. Look no further.Windchill® 9.1 supports Microsoft® SQL Server® 2005. You also need to choose the edition of SQL Server 2005 that you want to deploy. You do not want to deploy Express, Developer, or Workgroup editions because these are not designed for enterprise use. You need to deploy either Standard or Enterprise editions. You can compare the different editions of SQL Server 2005 here: Choose the Right Edition for Your Needs. The most important distinction is the number of CPUs on the box. Standard Edition only supports 4 processors, Enterprise supports unlimited CPUS. CPUs are counted as physical sockets, so two quad core that show up as 8 processors in your task manager, is really just 2 CPUs from the SQL Server licensing stand point.
Which Operating System?Though the 32-bit standard edition of SQL Server 2005 will install on Windows Vista and Windows XP, we highly recommend that you install SQL Server on a server-based operating system—either Windows 2000, Windows Server 2003 or Windows Server 2008. There is no 64-bit version of SQL Server 2005, but it will install on a 64-bit version of the OS, under WOW64. You can find out more about version compatibility here: Hardware and Software Requirements for Installing SQL Server 2008 Read more: PTC Windchill on SQL Server
Which Operating System?Though the 32-bit standard edition of SQL Server 2005 will install on Windows Vista and Windows XP, we highly recommend that you install SQL Server on a server-based operating system—either Windows 2000, Windows Server 2003 or Windows Server 2008. There is no 64-bit version of SQL Server 2005, but it will install on a 64-bit version of the OS, under WOW64. You can find out more about version compatibility here: Hardware and Software Requirements for Installing SQL Server 2008 Read more: PTC Windchill on SQL Server