0

I just installed SQL Server 2016 Express and was going to add an ODBC connection to my SSRS instance. When I went to the dropdown to change the connection type from SQL Server to DB2, the only connection type available in the dropdown is SQL Server.

Anyone know how to fix this? Is this a limitation in the Express version?

1

It is a limitation that you are hitting for Reporting Services in SQL Server Express

Report data sources must be SQL Server relational databases that run locally in SQL Server Express.

| improve this answer | |
  • The link is for 2008 R2. Is there any documentation for 2016? – Edward Rhoades Jan 11 '17 at 20:56
  • It remains the same for 2016. – Kin Shah Jan 11 '17 at 23:42

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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