Skip to content

Lab 2 Configuring Connection String #26

@nickbats

Description

@nickbats

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!

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions