CODEWITHSUNDEEP
sql-serverdatabaseazureazure-sql-databaseazure-data-sync
Potnoodle13
Potnoodle13

Reputation: 23

Azure SQL DB connecting to local SQL

I'm trying to connect from my azure SQL DB to link to the local SQL DB and create some linked tables that i can run some reports on within the Azure environment.

I've tested that i can follow the steps and successfully connect to another SQL Db within my Azure environment and this is working fine, so the steps i am following are correct.

However when i try to run the same steps connecting against my local DB i receive the following error:

A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted.)

Steps i'm following are

This creates a external table within my azure database but when i try to select from this table i get the following message

A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted.)

So two questions really as i've googled for some time and a lot of the posts I've found seemed to be old.

I've read up about this and the only comments i could see mentioned TrustServerCertificate=True to false. However i'm not sure where this is set and where the change is required? to me this looks more like a change within a connectionstring for coding rather than a db to db?

Upvotes: 0

Views: 743

Answers (1)

Alberto Morillo
Alberto Morillo

Reputation: 15648

Elastic queries allow a query to span multiple Azure SQL Databases but on-premises SQL Server instances can not be part of elastic queries.

My suggestion is to perform replication of on-premises databases to Azure SQL Database or use SQL Data Sync so you can have an always updated copy of on-premises databases on Azure SQL Database and you can then query them as local tables or with elastic queries on Azure SQL Database.

Upvotes: 2

Related Questions