[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

Sharepoint 2010 Foundation - External Data Connection to SQL 2005

Posted on 2014-01-23
7
Medium Priority
?
278 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 500 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
Will your db performance match your db growth?

In Percona’s white paper “Performance at Scale: Keeping Your Database on Its Toes,” we take a high-level approach to what you need to think about when planning for database scalability.

 
LVL 38

Assisted Solution

by:Justin Smith
Justin Smith earned 1500 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 1500 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 1500 total points
ID: 39812032
0
 

Author Closing Comment

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

Featured Post

Learn how to optimize MySQL for your business need

With the increasing importance of apps & networks in both business & personal interconnections, perfor. has become one of the key metrics of successful communication. This ebook is a hands-on business-case-driven guide to understanding MySQL query parameter tuning & database perf

Question has a verified solution.

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

A recent project that involved parsing Tableau Desktop and Server log files to extract reusable user queries for use in other systems. I chose to use PowerShell to gather the data, and SharePoint to present it...
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

649 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