TailwindTraders Database Connection

Question

https://learn.microsoft.com/en-us/training/modules/get-data/3b-parameters

While connecting to the TailwindTraders Database, it asks for username and password for authentication. What should we enter there because it is not connecting.

Error:

Details: "Microsoft SQL: 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.)"

This question is related to the following Learning Module

Answer 1

Hi Daman Preet Singh,

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

As per the lab instructions, Server name: localhost\SQLEXPRESS and Database: TailwindTraders. Server name it's a case sensitive. Make sure give the exact name whatever provided in Lab instructions. Kindly refer the below snapshot for reference.

If you want to load any specific columns, below is the snapshot for reference.

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.