So i have BDC activated on my sharepoint app. And i would like to create external content types based on tables from my local database. It's a sql database and when i'm trying to add a connection to that database from my sharepoint designer it says
Cannot connect to the LobSystem (External Ssytem): Reason: "A network-related or instance specific error occured while establishing a connection to SQL Server"
It didn't prompt me to enter my usernam and password tho. To connect to my database there's a password needed. Do i have to do something specific to enter my usernam and password before tyring to connect to my database?