SOAP Endpoint Access Using InfoPath && SPD

I posted this in the Sharepoint Designer forum, but did'nt get an answer...so trying here...Below is my soap endpoint in sql2005...works fine for InfoPath to consume the service...but when SharePoint Designer attempts to retieve data I get

"The server returned a non-specific error when trying to get data from the data source."

In SPD I can connect to the service and see the methods and parameters...but never get any data returned...wondering if it's in my endpoint setup. BTW-using Windows security by default in SQL2005...I've tried different types of logins without success...

/****** Object: Endpoint [getSCMADataEndpoint] Script Date: 11/28/2007 10:38:43 ******/

CREATE ENDPOINT [getSCMADataEndpoint]

AUTHORIZATION [SCMAadministrator]

STATE=STARTED

AS HTTP (PATH=N'/getscmadatawebservice', PORTS = (CLEAR), AUTHENTICATION = (), SITE=N'scmasvr01', CLEAR_PORT = 80, COMPRESSION=DISABLED)

FOR SOAP (

WEBMETHOD 'GetCourseInfo'( NAME=N'[SCMA].[dbo].[prGetCourseInfo]'

, SCHEMA=DEFAULT

, FORMAT=ROWSETS_ONLY),

WEBMETHOD 'GetCourseLectures'( NAME=N'[SCMA].[dbo].[prGetCourseLectures]'

, SCHEMA=DEFAULT

, FORMAT=ROWSETS_ONLY),

WEBMETHOD 'GetCourseLecturesInstr'( NAME=N'[SCMA].[dbo].[prGetCourseLecturesInstr]'

, SCHEMA=DEFAULT

, FORMAT=ROWSETS_ONLY),

WEBMETHOD 'GetCourseObjectives'( NAME=N'[SCMA].[dbo].[prGetCourseObjectives]'

, SCHEMA=DEFAULT

, FORMAT=ROWSETS_ONLY),

WEBMETHOD 'GetCourseRosterInfo'( NAME=N'[SCMA].[dbo].[prGetCourseRosterInfo]'

, SCHEMA=DEFAULT

, FORMAT=ROWSETS_ONLY),

WEBMETHOD 'GetSCMAAccounts'( NAME=N'[SCMA].[dbo].[prLookupSCMA_accounts]'

, SCHEMA=DEFAULT

, FORMAT=ROWSETS_ONLY),

WEBMETHOD 'GetSCMAAccounts_FieldNames'( NAME=N'[SCMA].[dbo].[prLookupSCMA_Accounts_FieldNames]'

, SCHEMA=DEFAULT

, FORMAT=ROWSETS_ONLY), BATCHES=DISABLED, WSDL=N'[master].[sys].[sp_http_generate_wsdl_defaultcomplexorsimple]', SESSIONS=DISABLED, SESSION_TIMEOUT=60, DATABASE=N'SCMA', NAMESPACE=N'http://tempuri.org', SCHEMA=STANDARD, CHARACTER_SET=XML)