Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

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

1 Answer 1

up vote 1 down vote accepted

Andrzej,

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.

LW

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

Your Answer

 
discard

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.