I'm trying to execute a report against a master/synonym that describes a MSSQL stored procedure.

We use SQL passthru and 'EX [stored procedures]' currently without any issues.

I can create the master, but it fails when I try and run Sample Data;

(FOC1400) SQLCODE IS 17 (HEX: 00000011) XOPEN: 08001 : Microsoft OLE DB Provider for SQL Server:
[08001] [DBNETLIB][ConnectionO : pen (Connect()).]SQL Server does not exist or access denied.
(FOC1406) SQL OPEN CURSOR ERROR

I *think* the problem is that we use Trusted connections for most of our data adapters and Windows Authentication on the SQL Server. My guess is that to use a proc as a data source we need to use Explicit security on the connector and SQL Server Authentication?

I haven't bothered my DBA's yet since there's a process involved so I thought I'd do a quick post to see if my assumption is correct.

Thanks

This message has been edited. Last edited by: RickW,

It looks like my assumption may not be right since I tested it - submitting a ticket to IBI...

That was odd. It looks like it was only picking up the first data connector even thought it's specified in the acx file. Once I made a change to edasprof, it all works.