Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
saurabh309
Starting Member
1 Post |
 Posted - 2010-12-02 : 14:16:03
|
Hi All,I am new to SQL Server Reporting Services. Today i was trying to publish a report using 3 machines. Let me explain the scenario first:We have 3 machines1) Machine A, a dedicated database engine with a database name sql_dev2) Machine B, a dedicated Report Server where Datasource rep_B has been made which is fetching data from sql_dev DB3) Machine C, a client workstation to verify the reports.What i did is, i deployed a report in machine B and check the report in machine B and i was able to see the report but when i was trying to get the report from Machine C using the ReportServer URL, i was getting the error "Cannot connect to datasource rep_B"Did anybody go through the same issue? Please help me out here, it is very important for me.  |
|
|
|
|
|
Error connecting to datasource