So we are wanting to update our MSSQL 2008 R2 server with the latest service pack and were wondering if Spark 2.6.3 supports the most current service pack of 2008R2. Currently the most current service pack is SP3. Any information on this would be greatly appreciated.
First of all, Spark is only a client, which is connecting to a server. I presume you are using Openfire as a server for Spark. I can’t say whether SP3 is 100% compatible, but i think SP is usually a cumulative fix update, not some drastic changes to the scheme of the database, so i think it should work. But you can make a backup, then update to SP3, and if it doesn’t, roll back the backup.
I’m running openfire on a sql 2008r2 that is current without issue.