Skip to Content
0

Cannoot see list of DBs - Connecting to a named SQL Server 2014 instance in Crystal 2016

Nov 08, 2017 at 04:17 PM

16

avatar image
Former Member

Hello,

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.

crystal-reports-oledb-ado.jpg

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Don Williams
Nov 08, 2017 at 04:20 PM
0

Hi Tony,

For newer SQL Servers you need to install the SQL Server Client Native 10 or 11 clients.

When selecting the Driver use one of those and you'll be able to see the tables.

Don

Share
10 |10000 characters needed characters left characters exceeded