Business adapter studio Error
Has anyone experienced this error before trying to do a test connection to a database server? Also trying to stage AD data to that SQL server? I also tried it on SQL Express on the Beacon.
Do you know if this SQL requires a secured connection? Maybe you can check if the error is related to TLS 1.0? https://support.microsoft.com/en-us/help/4077486/secdoclienthandshake-ssl-security-error-installing-dynamics-crm-server
I always find that when you have SQL Server connectivity issues from a beacon, it helps to install SQL Server Management Studio on the beacon. When SSMS gets the same connection errors, the customer is more likely to believe that they do have a network/environmental issue and it is not an issue with the Beacon itself. Once SSMS is able to connect, then the beacon is able to connect.
Yes I have SSMS installed on the Beacon, and I am able to connect. I am trying to pull in AD data into a physical table so i can normalize it. It keeps failing. The filter I am using is ObjectClass=User.
I just saw a colleague getting the same error message on a local test VM this morning. He ignored the connection test and the actual connection just worked.
I have seen the connection error before and it was able to pull the data into a physical table. What I am finding is the memory timeout trying to pull in AD is failing but the Server has enough memory. I was playing with the timeouts, but it kept failing in the Non Prod environment. I was able to get it to work in Prod with the same filter. What causes the memory timeout since it is not on the actual server. Could it be that the LDAP source DC creating this failure? @mfranz
Sounds like it could be related to the source. Have you tried playing with the page size feature?
Sorry to jump into this topic after almost 2 years, but I also encountered the same issue. I fixed upgrading the business adapter studio to the same version as FNMS, in my case version 17