Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Connecting to database (dataview web part) in SPD

  Asked By: Denny    Date: Jan 13    Category: Sharepoint    Views: 2555

I know that I have rights to the database that I am trying to
connect to using the data view functionality in SPD.
Yet, I keep getting authentication errors when I try to connect.
I have checked and the login that I am using to connect is the dbo in
each of the databases that I make this attempt.
Is this something that gets fixed in the service pack for spd?
Am I missing something?



3 Answers Found

Answer #1    Answered By: Malcolm Maxwell     Answered On: Jan 13

Windows authentication  has security holes in it, so Microsoft disabled it for
use in data  View. The userid and Password fields in the data source connection
are for SQL authentication only. To do Windows Authentication of the logged in
user you need to enable the Microsoft Single Sign-on service  and set it up with
Windows credentials that can be passed to the database.

Answer #2    Answered By: Mayur Mandal     Answered On: Jan 13

"Security Holes" might be a little harsh - see
blogs.msdn.com/nunos/archive/2004/03/12/88468.aspx for a decent
description of the issues. It's written for pure ASP.Net, but the
underlying causes are the same since at its core SharePoint is a ASP.Net

Answer #3    Answered By: Deana Lowery     Answered On: Jan 13

I looked at the BLOG and from what I saw that's a discussion of the limitations
of using Integrated security to access a back end database  and the double hop
problem that results. That wasn't what I was referring to. In ASP.net you can
use an Integrated Security connection string as long as you don't violate the
double hop. In SharePoint with the DataForm web  part you can't use Integrated
Security at all, even if you aren't violating the double hop problem. This was
possible in SharePoint 2003 with the DataView webpart and was also available in
BETA 2 of SharePoint 2007. The ability to use it was turned off after Beta 2
because the product team found that it could be exploited to compromise

Didn't find what you were looking for? Find more on Connecting to database (dataview web part) in SPD Or get search suggestion and latest updates.