As it's hard to find one consolidated one, I have compiled to share with all; as well as for my own future easy net search in future =)
Query Command: SELECT @@VERSION
(A) SQL Server 2000
RTM - 8.00.194
SP1 - 8.00.384
SP2 - 8.00.534
SP3a - 8.00.760 (SP3a)
SP4 - 8.00.2039
(B) SQL Server 2005
RTM - 9.00.1399.06
SP1 - 9.00.2047.00
SP2 - 9.00.3310.00
SP3 - 9.00.4035.00
(C) SQL Server 2008
RTM - 10.0.1600.22
SP1 - 10.00.2531.00
Source: SQL Server Version Builds - Big Database List
Sample MAGT log entries showing SQL Server 2005 SP3 is used for BESMgmt DB:
[35019] (01/06 00:00:00.723):{0xA38} [ENV] [DB] Database Schema Version: 5.0.0 <5.0.2009.03.19>
[30000] (01/06 00:00:00.738):{0xA38} [ENV] [DB] Connection String = Server= SQLSvr01.rim.net;Database=BESMgmt;Trusted_Connecti on=Yes
[30000] (01/06 00:00:00.738):{0xA38} [ENV] [DB] DBMS Name = Microsoft SQL Server; DBMS Version = 09.00.4035; Provider Name = sqlncli.dll; Provider Friendly Name = Microsoft SQL Native Client; OLE DB Version = 02.80; Provider Version = 9.00.1399.06; Failover Partner = SQLSvr02
xxx12304;System Requirements for BES Domino 4.1 SP7xxx12305;
• MSDE 2000 SP3
• Microsoft® SQL Server® 2000 SP4
• Microsoft SQL Server 2005 SP3
• Microsoft SQL Server 2005 Express SP3
• Microsoft SQL Server 2005 SP3 (64-bit)
For all versions of the Microsoft SQL Server that are earlier than Microsoft SQL Server 2005 SP3, visit http://technet.microsoft.com to read KB960082 and Microsoft Security Bulletin MS09-004.
xxx12304;System Requirements for BES Domino 5.0 SP1xxx12305;
• MSDE 2000 SP3
• Microsoft® SQL Server® 2005 SP3 (32-bit or 64-bit)
• Microsoft SQL Server 2005 Express Edition SP3
• Microsoft SQL Server 2008 (32-bit or 64-bit)
• Microsoft SQL Server 2008 SP1 (32-bit or 64-bit)
• Microsoft SQL Server 2008 Express Edition (32-bit or 64-bit)
• Microsoft SQL Server 2008 Express Edition SP1 (32-bit or 64-bit)
For all versions of the Microsoft SQL Server earlier than Microsoft SQL Server 2005 SP3, Microsoft Security Bulletin MS09-004 (for more information, visit http:// technet.microsoft.com to read article KB960082).
Database mirroring:
To support database mirroring for the BlackBerry Configuration Database or BlackBerry MDS Integration Service database, the following conditions:
• the database server must be Microsoft SQL Server 2005 SP3 Enterprise Edition (32- bit or 64-bit), Microsoft SQL Server 2008 Enterprise Edition (32-bit or 64-bit), or Microsoft SQL Server 2008 SP1 Enterprise Edition (32-bit or 64-bit)
• the database server that hosts the mirror database must use the same version and build as the principal database
• a separate database server for the mirror database
• static port with the same port number for both database servers
• Microsoft SQL Server Browser running on both database servers
Database transactional replication:
To support database transactional replication for the BlackBerry Configuration Database or BlackBerry MDS Integration Service database, the following conditions:
• the database server must be Microsoft SQL Server 2005 SP3 or later
• the database server that hosts the replicated database must use the same version and build as the primary database
Knowledge Sharing - List of SQL Server Versions
