MOSS Forum

Ask Question   UnAnswered
Home » Forum » MOSS       RSS Feeds

Connect to data base

  Date: May 29    Category: MOSS    Views: 633

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



4 Answers Found

Answer #1    Answered On: May 29    

You have not told us how you attempted to create the connection. Did you

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.


Answer #4    Answered On: May 29    

Please follow the linked video step by step:

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