Solved

Issue while connection to Adventure Works

Hello!

I’m new to TimeXtender and I was trying to complete the training but I’m having issues connecting to the Adventure Works database via TimeXtender.

I connect just fine via SQL Server Management Studio 20:

But when I try to connect with the same credentials and configurations via TimeXtender I get the following error message:

Can anyone help me figure out what the issue is? At the moment this is really impacting my training

Thank you in advance for your help :)

Best answer by daniel

Dear @marianaandrade ,

sometimes I forget to put in the 'trust server certificate'. I usually check the learntimextender - Portal page:
https://timextender.training/portal#data-sources

And you are using the TimeXtender SQL connector? (I'm not sure which version of TX you are running)

Hope this helps

= Daniel

+8

Hi,

do you have SSMS installed on the same machine as TimeXtender?

Hi Rory,

Yes, I have the SSMS 20 on the same virtual machine as TimeXtender

+8

Hi,

it should not be required but you can try installing: https://learn.microsoft.com/en-us/sql/connect/oledb/download-oledb-driver-for-sql-server?view=sql-server-ver16 on the VM. It looks like you are connecting to Azure SQL DB so there should be no requirements other than SSMS to connect.

Installed it and I still get the same error. Do you have any other suggestions?

+8

Hi,

just to be sure: your ODX Server is also on that machine? If so, I would create a support ticket.

+8

Dear @marianaandrade ,

sometimes I forget to put in the 'trust server certificate'. I usually check the learntimextender - Portal page:
https://timextender.training/portal#data-sources