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?

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Browse other questions tagged or ask your own question.