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

One thing to note is that SQL Server 2008 has the ability to use all the RAM that the operating system supports. So the OS you’re considering will affect how much RAM SQL Server can use. Windows Server 2008 Standard Edition is limited to 4 GB for 32-bit processors. Windows Server 2008 Enterprise and Datacenter editions have a 64 GB limit for 32-bit processors. So it is best to use Windows Server 2008 Enterprise Edition to make sure of the additional RAM for SQL Server.