SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have problem with Business Data Connectivity, when I try to create new external content type in SharePoint Designer - I "Add Connection" then I choose SQL Server I fill Database Server and Name and I can't connect I see "Login failed for user" In Evet Log I have Critical error Event ID 8080.

The BDC service is working and user have perrmision to SQL database.

I use SharePoint Foundation and SharePoint Designer.

best regards, Andrzej

share|improve this question
up vote 1 down vote accepted


SPD2010 may need local admin rights to create this connection, it was the case in my setup anyway. What I did is I have created External Content Type with a logged on user who is a member of local administrators on the SQL server, I haven't had time to get to the bottom of this but it worked. I will update this answer as soon as I get this sorted out with only SQL permissions if possible at all.


share|improve this answer
Thanks you for your support, I also check it... Best regards – Wilon Sep 25 '12 at 20:10

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.