Hi,
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.
Feb 06, 2020 10:25 AM
Hi Steven,
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
Best regards,
Markward
Feb 09, 2020 11:46 AM
I checked the TLS settings and they are fine for the SQL server. Trying to stage AD data into a physical table but it is getting a memory exception error.
Feb 10, 2020 08:18 AM
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.
Feb 10, 2020 08:24 AM
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.
Feb 10, 2020 08:29 AM
Hi Steven,
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.
Best regards,
Markward
Feb 13, 2020 07:01 AM
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
Feb 13, 2020 07:31 AM
Hi,
Sounds like it could be related to the source. Have you tried playing with the page size feature?
Best regards,
Markward
Feb 13, 2020 08:01 AM
I will try the page size. I was playing around with the timeouts. Keep you updated on my findings.
Feb 13, 2020 08:39 AM
Hello,
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
Dec 28, 2021 07:26 AM