Data connection is failed.

Question

Data connection is failed.

Here is the Query I wrote.

SELECT [SalesOrderID]

,[OrderDate]

,[OnlineOrderFlag]

,[SalesOrderNumber]

,[CustomerID]

,[SalesPersonID]

,[TerriroryID]

,[SubTotal]

,[TaxAmt]

,[Freight]

,[TotalDue]

FROM [TailwindTraders].[Sales].[SalesOrderHeaders] s

WHERE s.[SalesPersonID] = 279

This question is related to the following Learning Module

Answer 1

Hi Lee, Changyeol,

Thank you for reaching out to us on Microsoft Q&A forum. 

The units before the exercise are informational, with no Tailwind Traders sample matching what is shown. You are expected to read and follow along. When you reach the exercise in Unit 11, you will be able to connect to a VM, download files from GitHub, extract them to the VM's disk, and complete the exercise instructions.

We tried from our end; it's working fine for us. Kindly refer the below screenshots. Please follow the lab instructions, whatever mentioned in the right side when you launched the Lab.

If you are still facing any issue, please let us know in the comments. We are glad to help you.

If the information is helpful, please Accept Answer so that it would be helpful to community members.

Thank you.

Answer 2

FROM [TailwindTraders].[Sales].[SalesOrderHeaders] s

You use a three-part qualifier in your query; does the database [TailwindTraders] exists on the server you are connected to?