Solved

Sharepoint 2010 Foundation - External Data Connection to SQL 2005

Posted on 2014-01-23
7
269 Views
Last Modified: 2014-03-27
I have a new SharePoint 2010 FOUNDATION (SP1)system and an SQL 2005 database (SQL5). I have created a view on SQL5 showing all my Customers. On the SP1 I created a list to show my Customer data. I keep getting 'Login failed for user NT AUTHORITY\ANONYMOUS LOGO'. I used to get a different authentication error but I am now trying everything.

1) In SharePoint Designer I created EXTERNAL CONTENT TYPE and I was able to connect to my database and connect to the view I wanted. I can also click the button the says CREATE LISTS and FORMS and the list is in my SharePoint site. I just can access the data because I keep getting authentication error or I don't have rights error. I am sure it is tied to the Authentication Mode but I am still trying.

2) I went to my SharePoint Central Admin on the server and I have tried SERVICE APPLICATIONS and NEW - BUSINESS CONNECTIVITY SERVICE. I created my new service and it says STARTED (I created like 5 different ones because nothing was working).

3) I am missing something in between. What is missing?
0
Comment
Question by:allenkent
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
7 Comments
 
LVL 38

Expert Comment

by:Justin Smith
ID: 39806389
Make sure you read through this article.


What are you using for authentication to the external system?
0
 

Author Comment

by:allenkent
ID: 39807188
Great article and now I know the 'theory' behind it all. Now I need to see how to do it.

When you ask - "what are you using for authentication to the external system?". My only answer so far is Active Directory account to enter SharePoint. As for the SQL server - I log onto server with my Activity Directory account but I have also created a READ ONLY (connect) SQL account to connect to my specific view.

I am still trying to figure out which security to use. Articles keep saying SECURE STORE SERVICE but Foundation does not come with SECURE STORE SERVICE.
0
 
LVL 15

Assisted Solution

by:colly92002
colly92002 earned 125 total points
ID: 39811858
I've just reviewd my notes from setting this up on an SP 2010 farm and these two sections are probably relevant:


The “Claims to Windows Token Service” must be running on the service (http://msdn.microsoft.com/en-us/library/ff487975.aspx )   see Central Admin-> Services on Server (this was using the full SP2010 product)

Must also create the Secure Store (SSO) token that is used to actually access the data (Central Admin-> manage service applications).  In this you set up an SSO token with the username/password you use to access the data, and a set of AD accounts/groups that will be mapped to this SSO to actually get access to the data.
0
Comparison of Amazon Drive, Google Drive, OneDrive

What is Best for Backup: Amazon Drive, Google Drive or MS OneDrive? In this free whitepaper we look at their performance, pricing, and platform availability to help you decide which cloud drive is right for your situation. Download and read the results of our testing for free!

 
LVL 38

Assisted Solution

by:Justin Smith
Justin Smith earned 375 total points
ID: 39812015
When you create the content type in Designer, what did you choose for the authentication type?  These are listed in the article I posted.  I'm guessing without the SSS you'll have to use one of the first two:  Pass Through (User's identity) or Revert To Self (BDC Identity).  The first one will likely require Kerberos authentication to properly pass the logged in user's credentials to the external system.  The second will use the credentials of the application pool.
0
 
LVL 38

Assisted Solution

by:Justin Smith
Justin Smith earned 375 total points
ID: 39812026
I'm guessing you are getting the ANONYMOUS USER error because you have it set to "pass through" but you aren't using Kerberos.  In this case the anon user is used to attempt to authenticate to the backend system, and it fails.
0
 
LVL 38

Accepted Solution

by:
Justin Smith earned 375 total points
ID: 39812032
0
 

Author Closing Comment

by:allenkent
ID: 39959364
These put me on the correct path
0

Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

690 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question