Does Archive Server for MDaemon support SQL Server 2005?

Archive Server for MDaemon supports SQL Server 2005 (Express, Workgroup, Standard, Enterprise) from the 2.1.4 version.

The SQL Server setup typically suggests the Windows NT authentication to access to its objects as default while Archive Server for MDaemon requires the SQL authentication. SQL Server may be set to use the "mixed mode" authentication which supports both.

After the installation, SQL Server 2005 will be "locked down" in that: 

• may work only locally
• TCP/IP protocol is disabled

To install and run Archive Server for MDaemon you should:

• use the SQL Server 2005 "Surface Area Configuration" tool to:
  • allow remote connections
  • start the SQL Browser
• use the SQL Server 2005 "SQL Server Configuration Manager" tool to enable the TCP/IP protocol for Network and Native Client
• use the SQL Server Management studio to assure the SA login was enabled