Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

I have a SQL and a Access database which I need to import to SharePoint. These database contains information collected from my Internet site like registration info, usernames etc.

Is this possible to do it? I have read somewhere that it can be done using BCS. But I am unable to find more information on it.

Can someone please help me out?

share|improve this question
    
Do you want your users to authenticate into SharePoint using these data? Or do you just want the data accessible in SharePoint for internal consumption (not necessarily for authentication)? –  James Love Dec 3 '11 at 10:09
    
I need e data accessible in SharePoint for internal consumption (not necessarily for authentication). Tx –  neo269 Dec 3 '11 at 10:13

2 Answers 2

up vote 3 down vote accepted

A few things come to mind, using BCS and external lists to bring the content in, creating a DVWP with the database as a data source, using SSRS to bring the data into SharePoint.

Some references on the BCS, Link 1, Link 2, Link 3

share|improve this answer

You can write your own authentification provaider. I think this articles will helpful:

Forms Authentication in SharePoint Products and Technologies (Part 1): Introduction

Forms Authentication in SharePoint Products and Technologies (Part 2): Membership and Role Provider Samples

share|improve this answer
    
Based on the comments above, this isn't what the user wants, although it is a good answer for setting up forms authentication. He just wants to expose that data in SharePoint. –  PirateEric Dec 3 '11 at 11:43

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.