Solved

Sharepoint 2010 Foundation - External Data Connection to SQL 2005

Posted on 2014-01-23
7
254 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
  • 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
Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

 
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

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Dynamics crm 2011 8 45
Distinct values from two tables 14 20
Access Migration to Sql Server 2 22
sql query Help 12 33
Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

762 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

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now