Logo 
Search:

MOSS Forum

Ask Question   UnAnswered
Home » Forum » MOSS       RSS Feeds

Connect to data base

  Date: May 29    Category: MOSS    Views: 530

I am unable to creat a database connection from SharePoint Designer. We use
SQL-server 2005 and MOSS 2007.

Share: 

 

4 Answers Found

 
Answer #1    Answered On: May 29    

You have not told us how you attempted to create the connection. Did you
read:
office.microsoft.com/.../add-a-database-as-a-d\
ata-source-HA010100908.aspx

 
Answer #2    Answered On: May 29    

It's very hard to help you when it appears you are asking us to search
Google for you and tell you how to do the whole thing. I don't think you
are asking that but you should let us know what you have tried and what
errors you see.

 
Answer #3    Answered On: May 29    

Take a look at the following article. Pay special attention to the section
on connecting to SQL using SSO. This is what I find is usually the issue.
SharePoint can't impersonate the logged in user through the two hops
required to get to the database, so you need to use SSO unless you are using
Mixed mode authentication and SQL credentials.

office.microsoft.com/.../add-a-database-as
-a-data-source-HA010100908.aspx

 
Answer #4    Answered On: May 29    

Please follow the linked video step by step:
www.layer2.de/.../...usiness-data-list-connector.a\
spx

 
Didn't find what you were looking for? Find more on Connect to data base Or get search suggestion and latest updates.




Tagged: