I've got a MYSQL server setup as a linked server in MS SQL server 2008. Can someone tell me if it is possible to generate reports from this server? How do I connect it to Reporting Services?
I have configured Reporting Services on one Server and have the ReportServerDb & ReportServerTempDb on other server (Future requirement of scale out deployment). I am connecting to these servers ...