how does crystal reports handle SQL AAG or clustered servers.

[viacr1]

We recently upgraded our SQL server to a clustered server using AAG. The server has two hosts one is the primary. The second server is us up but does not have access to the database unless there is a failover.

Our reports fail intermittently since there is some type of round-robin connection to the servers. The ODBC connections handle this without issues, there is an option we check called "multi-subnet failover". This makes the ODBC smart enough to know which server is active and the primary, no issues here.

We would like to continue using OLE DB ADO (DSN-less) connections with integrated security. We are using 2013 and would like to know if version 2020 will fix this issue. or if there is a better way to connect to a clustered AAG environment.

[DellSC · Accepted solution]

Database connections from Crystal have more to do with which version of the database driver you have installed than with anything Crystal is doing. I would make sure that you have the most recent version of the OLEDB driver for SQL Server installed to see whether that helps. If that doesn't resolve the issues, I would post your issue in a Microsoft forum to see whether they can help you there.

-Dell

[viacr1]

thanks all, the statement "Database connections from Crystal have more to do with which version of the database driver you have installed" answered my question. i used old db version 18 for sql server and it seems to work, i get the multi-subnet failover option.

[former_member11696]

FYI - we currently don't support MS's version 18 Client, see this for more info:

https://www.crystalreports.com/datasources/