kromerm/adflab

Lab 2 Configuring Connection String

nickbats opened this issue · 0 comments

Hi Team!

I'm having these errors in Lab 2 specifically in setting up the connections. I'm having these error messages.

image

I am also bit confused on what the connection string format should be, and which of these should I use. Please see screenshot.

image

My current configuration settings are:

Data Source=adflabsqlfj477.database.windows.net;User ID=labadmin;password=L@bP@ss01;Initial Catalog=AirlinePerformance-ODS;Provider=SQLNCLI11.1;Persist Security Info=True;Auto Translate=False;

Data Source=adflabsqlfj477.database.windows.net;User ID=labadmin;password=L@bP@ss01;Initial Catalog=AirlinePerformance-OLTP;Provider=SQLNCLI11.1;Persist Security Info=True;Auto Translate=False;

Data Source=adflabsqlfj477.database.windows.net;User ID=labadmin;password=L@bP@ss01;Initial Catalog=AirlinePerformance-DW;Provider=SQLNCLI11.1;Persist Security Info=True;Auto Translate=False;

image

I have tried mixing and matching several stuffs unfortunately I still get the same error message.

Thank you for your help!