I am trying to setup an OLE ADO connection in Crystal Reports 2016 Support Pack 2 to a SQL Server 2014 named instance where encryption is mandatory on the database side. I am using the Microsoft OLE DB Provider for SQL Server.
The list of databases is not populating. No error message appears.
I have confirmed that the credentials, instance name and port number are all correct. I can also connect using the credentials and instance name in SQL Server Management Studio.
I have tried using the following syntaxes for the server name:
SQL Server Name\Instance Name
SQL Server Name\Instance Name,Port number
SQL Server Name:Port Number
None of these have resolved the issue of not seeing a list of databases
Any suggestions on how to resolve this would be much appreciated.