Hi,

I have two questions:
- where I can find certification matrix between SQL Server version and
Windows version ?
- is there compatibility between version ?
i.e. client SS2000 can connect to SS2008
or client SS2008 can connect to SS2000 ...

Thanks in advance

bob123 (bob123 (AT) gmail (DOT) com) writes:
See the topic "Hardware and Software Requirements for Installing SQL Server
2008" in Books Online, also available here:
http://msdn.microsoft.com/en-us/library/ms143506.aspx

For SQL 2005: http://msdn.microsoft.com/en-
us/library/ms143506%28SQL.90%29.aspx

Yes. Currently there are no restrictions on connections from older APIs,
but Microsoft may drop support for DB-Library and some really old ODBC
versions in the next version of SQL Server.

Note however, that if you connect with an older API that some features
may not be available to you.

For that particular combination, I know of no restrictions. But not
all client APIs in use today support connections to SQL 6.5.

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx