Hello,
I've looked but not found a thread that addresses this question, so I apologise if this exists already.
We've installed storage profiler on a VM and we;d like to interface microsoft reporting services directly to the mysql database. I understand that the preferred way to do this is to set up a service account that matches a read only account in that needs to be created on the mysql database.
I'm database challenged so... is this the correct approach and can I get some pointers on how this should be done. Reporting services sits on a different server and will be using ODBC to connect to the Storage Profiler MySQL database.
Thanks