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!



  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?

    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. Olá, gostei muito do seu web-blog! achei o materia muito bem estruturado.
    escrevi um blogue no mesmo ramo e gostaria de ver se você tem alguma
    sugestão para quem está começando a escrever blog sobre isso.

    Comment by dieta — October 27, 2015 @ 10:46 am

  10. u8fd8u73e0u65e5u5fd7u8fdeu8f7du554a~ u770bu6765u4f60u8d70u706bu5165u9b54u4e86u5c0fu6797u5b50~ Click https://twitter.com/moooker1

    Comment by annettaknowles1827 — April 8, 2016 @ 9:37 am

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 )

Google+ photo

You are commenting using your Google+ 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 )


Connecting to %s

Blog at WordPress.com.

%d bloggers like this: