Solved

Sharepoint 2010 Foundation - External Data Connection to SQL 2005

Posted on 2014-01-23
7
264 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
Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

 
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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
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 SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

733 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