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.
I am also bit confused on what the connection string format should be, and which of these should I use. Please see screenshot.
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;
I have tried mixing and matching several stuffs unfortunately I still get the same error message.
Thank you for your help!