Guest_imported
New member
- Jan 1, 1970
- 0
Hello,
I have a report that calls a stored procedure with one parameter to get data from two different databases.
The Stored Procedure gets data from a view in one database and some data from another view in another database like so:
CREATE PROCEDURE [st_Report]
@Parameter int
AS
SELECT *
FROM DB1..vw_1
LEFT JOIN DB2..vw_2
ON DB1.Field1 = DB2.Field1
WHERE DB1.Field2 = @Parameter
The SP works fine and testing with the report in design-mode works fine also. However, when I place the report on the web server and try to link to it passing the following querystring, it still asks me for UserName & Password:
User has access to both DBs.
Any help would be greatly appreciated. I apologize for the length of the message.
Bibhuti
I have a report that calls a stored procedure with one parameter to get data from two different databases.
The Stored Procedure gets data from a view in one database and some data from another view in another database like so:
CREATE PROCEDURE [st_Report]
@Parameter int
AS
SELECT *
FROM DB1..vw_1
LEFT JOIN DB2..vw_2
ON DB1.Field1 = DB2.Field1
WHERE DB1.Field2 = @Parameter
The SP works fine and testing with the report in design-mode works fine also. However, when I place the report on the web server and try to link to it passing the following querystring, it still asks me for UserName & Password:
User has access to both DBs.
Any help would be greatly appreciated. I apologize for the length of the message.
Bibhuti