Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

FP03 ODBC Connection Failure

  Asked By: Benny    Date: Feb 06    Category: Sharepoint    Views: 1116

Every so often, when I’m using FP03 to create a new data source catalog for a DVWP, I try to access the SQL server and receive a permissions error. This error persists no matter what I do. I can even create an ODBC connection directly to the SQL server and yet can’t make the same connection inside FP03 to the SQL server.

I’m sure some of you have seen this, but I’ve not heard of anyone who has figured out what to do to allow FP03 to connect to the SQL database.

Any ideas?



1 Answer Found

Answer #1    Answered By: Marty Mcdowell     Answered On: Feb 06

I don't think FP is connecting to the database. Rather it is the web server. Obviously during run-time it is the web server.

IIRC, to use NTLM access  to SQL Server, the AppPool identity needs permission to your database.

I usually use SQL server  accounts and sprocs and lock them down to prevent problems.

Didn't find what you were looking for? Find more on FP03 ODBC Connection Failure Or get search suggestion and latest updates.