I am trying to set up an OLE DB connection to a Microsoft SQL server.(OLE DB Provider for Microsoft SQL server).
I use trusted connection.
Test connection works.
After that I press Load and Select Database... Problem is, there is no database in the list.
This works in QlikView, on the same server using the same credentials.
I can connect (and Select database) to other databases (different DB server though), both using trusted connection and regular user/pwd.
Port 1433 is open.