This article applies to:

• MailMarshal (SEG)
• WebMarshal

Questions:

What versions of SQL Server do you support?

See Knowledgebase article Q11358, and also the Release Notes for each product version.

• LevelBlue generally plans to test each major and feature product release with the latest versions of SQL Server.
• MailMarshal (SEG) supports Azure SQL Server, when the MailMarshal installation is on Azure.

What Service Packs and Cumulative Updates do you support?

LevelBlue generally supports any new SP or CU for the supported SQL versions.  Minimum SP requirements are listed in Knowledgebase article Q11358, and the Release Notes.

• For a general policy statement, see Knowledgebase article Q13687.

Do the products support named instances?

Yes.

Do the products support SQL Clusters?

Yes, the products only require a constant SQL endpoint that they can connect to. The architecture behind the endpoint is not relevant.

Do the products work with SQL Server Availability Groups? 

Yes, the products only require a constant SQL endpoint that they can connect to. The architecture behind the endpoint is not relevant.

• SEG interfaces depend on up-to-date databases. Availability of data can be subject to SQL performance considerations.
• Data purging from databases hosted on Availability Groups is one area that has caused performance concerns. Ensure good connectivity between the connected SQL Servers.
• Multi-Subnet Failover is available in MailMarshal 10.0.5 and above

What best practices for SQL do the products support? 

• Automatic creation of a security role that has minimal permissions, for everyday connections to the database; one-time entry of credential with higher permission for upgrades.
• Enterprise administrators can create an empty database that the product will populate.
• TLS1.2 connectivity.

Do you support SQL Server encryption?

• Data encryption at rest is supported, assuming this is transparent to the client (subject to performance considerations).
• Transport encryption is not supported; however TLS connectivity is supported.