Solved

Sharepoint 2010 Foundation - External Data Connection to SQL 2005

Posted on 2014-01-23
7
261 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
Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

 
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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

These days socially coordinated efforts have turned into a critical requirement for enterprises.
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
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.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

861 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