This is the first time anyone from my group has tried to build a report of a sql server stored proc. the procedure and the report are very simple. The error I am getting makes no sense.

here is the acx:

NAME=INPUT, CONNECTION=kmssqlprod2-bireportprod,
STPNAME=dbo.kms_credit_exposures_report, $
SEGNAME=OUTPUT, STPRESORDER=0, $
SEGNAME=ANSWERSET1, STPRESORDER=1, $

Here is the mas:

FILENAME=KMS_CREDIT_EXPOSURES_REPORT, SUFFIX=SQLMSS , $
SEGMENT=INPUT, SEGTYPE=S0, $
FIELDNAME=, ALIAS=DUMMY, USAGE=A1, ACTUAL=A1,
MISSING=ON, $
SEGMENT=OUTPUT, SEGTYPE=S0, PARENT=INPUT, $
FIELDNAME=@RETURN_VALUE, ALIAS=P0000, USAGE=I11, ACTUAL=I4, $
SEGMENT=ANSWERSET1, SEGTYPE=S0, PARENT=INPUT, $
FIELDNAME=COUNTERPARTY_NAME, ALIAS='Counterparty Name', USAGE=A50V, ACTUAL=A50V,
TITLE='Counterparty Name', $
FIELDNAME=PARENT_NAME, ALIAS='Parent Name', USAGE=A50V, ACTUAL=A50V,
TITLE='Parent Name', $
FIELDNAME=CREDIT_RATING, ALIAS='Credit Rating', USAGE=A10V, ACTUAL=A10V,
TITLE='Credit Rating', $
FIELDNAME=HIGH_RISK, ALIAS='High Risk', USAGE=A1, ACTUAL=A1,
MISSING=ON,
TITLE='High Risk', $
FIELDNAME=SMALL_COAL_PRODUCER, ALIAS='Small Coal Producer', USAGE=I11, ACTUAL=I4,
MISSING=ON,
TITLE='Small Coal Producer', $
FIELDNAME=NET_EXPOSURE, ALIAS='Net Exposure', USAGE=P33.6, ACTUAL=P16,
MISSING=ON,
TITLE='Net Exposure', $
FIELDNAME=CREDIT_LIMIT, ALIAS='Credit Limit', USAGE=I11, ACTUAL=I4,
MISSING=ON,
TITLE='Credit Limit', $



Here is the fex:

TABLE FILE KMS_CREDIT_EXPOSURES_REPORT
PRINT
'KMS_CREDIT_EXPOSURES_REPORT.ANSWERSET1.COUNTERPARTY_NAME'
'KMS_CREDIT_EXPOSURES_REPORT.ANSWERSET1.PARENT_NAME'
'KMS_CREDIT_EXPOSURES_REPORT.ANSWERSET1.CREDIT_RATING'
HEADING
""
FOOTING
""
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
LEFTMARGIN=0.500000,
RIGHTMARGIN=0.500000,
TOPMARGIN=0.500000,
BOTTOMMARGIN=0.500000,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
GRID=OFF,
FONT='ARIAL',
SIZE=9,
TOPGAP=0.013889,
BOTTOMGAP=0.027778,
$
TYPE=TITLE,
STYLE=BOLD,
$
TYPE=TABHEADING,
SIZE=12,
STYLE=BOLD,
$
TYPE=TABFOOTING,
SIZE=12,
STYLE=BOLD,
$
TYPE=HEADING,
SIZE=12,
STYLE=BOLD,
$
TYPE=FOOTING,
SIZE=12,
STYLE=BOLD,
$
TYPE=SUBHEAD,
SIZE=10,
STYLE=BOLD,
$
TYPE=SUBFOOT,
SIZE=10,
STYLE=BOLD,
$
TYPE=SUBTOTAL,
BACKCOLOR=RGB(210 210 210),
$
TYPE=ACROSSVALUE,
SIZE=9,
$
TYPE=ACROSSTITLE,
STYLE=BOLD,
$
TYPE=GRANDTOTAL,
BACKCOLOR=RGB(210 210 210),
STYLE=BOLD,
$
ENDSTYLE
END



Here is the error:

(FOC1400) SQLCODE IS 4060 (HEX: 00000FDC) XOPEN: 42000
: Microsoft OLE DB Provider for SQL Server: [42000] Cannot open database r
: equested in login 'poddev'. Login fails.
L (FOC1406) SQL OPEN CURSOR ERROR.


poddev is a database that exists on a seperate server from what I am connecting to. I can't find anything in any of my code that has anything to do with poddev. Has anyone ever seen anything like this?

Thanks.

Go to the reporting servers admin console.

Click Step 2
Right Click your adapter and choose "properties".

Click the Test button.

If this test fails then the problem is not in your report. The problem is with the database permissions/connection.

From you error it looks like your fex is trying to connect to the database with the username 'poddev'.