Jack of all that is Microsoft, Master of None

November 18, 2010

BCS External List Error – The username returned by the Secure Store Provider is not of the form ‘Domain\user’

Wow, has it been a while since I last blogged.  But now that SharePoint 2010 deployments are in full swing, I expect to be getting back into the blog swing of things.  So on to my first 2010 post regarding an error I ran into this evening when setting up an External List using BCS.  Essentially I wanted to allow CRUD operations against a SQL database – nice simple implementation to start things off.  I went through and successfully created by Secure Store Provider Service Application, setup the external content type within SharePoint Designer, and then created the External List through the web UI and specified by new external content type: 

I then granted rights to this new cType in Central Admin because I was getting the ‘Access denied by Business Data Connectivity’ error.  This error went away, but then came the following:

The username returned by the Secure Store Provider in not of the form ‘Domain\User’.

So in usual fashion, I put this line into Google and found one post that mentioned an iisreset fixing this error.  Tried that, no go.  Thinking cap on… and then it hit me… when I specified my username for the Secure Store Service Application via the Set Credentials link:

In the username field I had specified the AD account name, but not the domain name:

So in the end, it was something simple – just make sure to include your DOMAIN\username when specifying an AD account in the credentials for your Secure Store Target Application.  Hopefully this saves someone a bit of time and some hair.  Enjoy 2010!

About these ads

10 Comments »

  1. Hello from England! I stumbled upon your post while searching for secure stores for my company. I stayed to read and still have no idea what you are talking about. It sounds like it should be brilliant though! :)

    Comment by cabin guy — November 24, 2010 @ 12:42 pm

  2. .I stayed to read and still have no idea what you are talking about?

    Comment by freeware for mac — January 28, 2011 @ 5:53 pm

  3. This is really awesome! I have a heck of the time trying to figure out what the problem is with my external list.

    Thank you so much! You made my day…. :)

    Comment by Millie — January 5, 2012 @ 2:32 pm

  4. thank you. it resolved my issue :)

    Comment by rajkumarbathula — January 29, 2012 @ 6:49 am

  5. THANKYOU. Was about to tear my teeth out with pliers.

    Comment by Nathaniel Johnstone — October 22, 2012 @ 1:06 am

  6. I am still getting the error.

    Comment by Corrie Sigler — February 22, 2013 @ 3:21 pm

  7. Good day!
    I know this is kind of off topic but I was wondering if you knew
    where I could locate a captcha plugin for my comment
    form? I’m using the same blog platform as yours and I’m having difficulty locating one?
    Thanks!

    Comment by buy twitter followers — May 17, 2014 @ 3:53 am

  8. HI Jack of all…thank you for posting on the error…The username returned by the Secure Store Provider in not of the form ‘Domain\User’. This was the second result that came up in the google search and it was the one I needed! Much appreciated, my external list is now rendering properly.

    Comment by Kathryn Ogawa — July 22, 2014 @ 7:14 pm

  9. You could certainly see your skills within the work you write. The world hopes for more passionate writers like you who arent afraid to say how they believe. Always follow your heart. kddgcekkbdcb

    Comment by Johnf266 — July 30, 2014 @ 3:31 pm


RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

The Silver is the New Black Theme. Create a free website or blog at WordPress.com.

Follow

Get every new post delivered to your Inbox.

%d bloggers like this: