Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question
In your comment below you mention Report Model, there is a good bit of difference between a Report Model project and a Report Server project. – Larry Smithmier Jan 27 '11 at 17:20
up vote 3 down vote accepted

You can create a stored procedure which selects the desired data and call it from your report as you call any other procedure. If you want to avoid having stored procedure just put the query directly into the report. You do need to use Mysql provider, just use a sql provider.

share|improve this answer

I don't see any problems generating reports the usual way, as long as you use the 4 part name: 'select top 10 col1, col2 from server.database.schema.table' in the code used to get the data for your reports.

share|improve this answer
But, when I create a Report Model project, I don't seem to have the option to use my connection to MYSQL as a data source? I only seem to have two provider options - 'SQLClientDataProvider' and 'OracleClientDataProvider'. – Jimmy C Jan 24 '11 at 12:03

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.