topic Re: Direct Query SQL connection Report Server in Report Server

Direct Query SQL connection Report Server

Anonymous — Mon, 24 Feb 2020 04:55:03 GMT

We couldn't connect to the Analysis Services server. Make sure you've entered the connection string correctly.

Got the above error while tring to connect to Microsoft sql server. I was able to connect with import method. However the above error is displayed for Direct Query Method. It is a distributed system with the Report server and Database on different servers. I am uable to connect to the database even if i mannually enter the User Name and password for Windows Authentication.

I am using January 2019 desktop app and Report Server.

Re: Direct Query SQL connection Report Server

KBO — Mon, 24 Feb 2020 12:26:51 GMT

Hi Anonymous ,

you try to connect a Analysis Service with the SQL connector?

Please use the Analysis Service and connect via Live Connection 🙂

Best,

Kathrin

If this post has helped you, please give it a thumbs up!
Did I answer your question? Mark my post as a solution!

Re: Direct Query SQL connection Report Server

Anonymous — Tue, 25 Feb 2020 11:33:07 GMT

Hi KBO Kathrin,

Are Analysis services applicable to Report server as well?

Thanks & Regards,

Kadambare

Re: Direct Query SQL connection Report Server

KBO — Tue, 25 Feb 2020 12:03:57 GMT

Sure 🙂
Best,
Kathrin