SQL support matrix
9013
24 May 2019
24 May 2019
| SQL and OS support | Windows 2000 SP4 (Advanced Server, Server) | Windows 2003 SP1 and SP2 ( Enterprise Edition, Standard Edition) | Windows 2003 R2 SP2 ( Enterprise Edition, Standard Edition) | Windows 2003 SP1 + SP2 ( Enterprise Edition, Standard Edition) X64 | Windows 2003 R2 SP2 ( Enterprise Edition, Standard Edition) X64 |
| MDB Local Ingres 3.0.3 103b | y | y | y | n | n |
| MDB remote Ingres 3.0.3 103b | y | y | y | n | n |
| Non clustered environment | |||||
| MDB local: MS SQL 2000 SP4 | y | y | y | n | n |
| MDB Local MS SQL 2005 SP1 and SP2 | y | y | y | n | n |
| Multi MDB Local MS SQL 2005 SP1 and SP2, with many named instances | n | n | n | n | n |
| MDB remote: MS SQL 2000 SP4 | y | y | y | n | n |
| MDB remote MS SQL 2005 SP1 and SP2 | y | y | y | n | n |
| Multi MDB remote MS SQL 2005 SP1 and SP2, with many named instances | n | n | n | n | n |
| MDB local MS SQL 2005 x64 SP2 | n | n | n | y | n |
| MDB remote MS SQL 2005 x64 SP2 | n | n | n | y | n |
| Multi MDB remote MS SQL 2005 x64 SP2 with many named instances | n | n | n | n | n |
| MS cluster environment | |||||
| MDB local: MS SQL 2000 SP4 | n | n | n | n | n |
| MDB Local MS SQL 2005 SP1 and SP2 | n | y | y | n | n |
| Multi MDB Local MS SQL 2005 SP1 and SP2, with many named instances | n | n | n | n | n |
| MDB remote: MS SQL 2000 SP4 | n | n | n | n | n |
| MDB remote MS SQL 2005 SP1 and SP2 | n | y | y | n | n |
| Multi MDB remote MS SQL 2005 SP1 and SP2, with many named instances | n | n | n | n | n |
| MDB local MS SQL 2005 x64 SP2 | n | n | n | n | n |
| MDB remote MS SQL 2005 x64 SP2 | n | n | n | n | n |
| Multi MDB remote MS SQL 2005 x64 SP2 with many named instances | n | n | n | n | n |
| Port & instance support | Default port | No-default port | Dynamic port |
| Default instance | y | y | n |
| Name instance | y | y | n |