Thank u for your answer.
I tried to connect via linked server and that wooooorks !!!!!!!!!!!!!!!
So, now I can create a report and deploy it ??
Or I must to do something else ??
awesome, glad it's working for you!
now it's up to you and how up-to-date the data needs to be.
for a report, does the report REALLY need up to the second data, or can it be a little behind?
linked servers are notoriously slow
, and you can also run into permissions issues, depending on how you set up the linked server.
i personally prefer to grab the data from a linked server at intervals with a scheduled job, and let my reports read the slightly-out-of-date-but-orders-of-magnitude-faster local data.
so my process might grab data a couple of times a day for reports, and any SSRS reports just hit a local table on my server with the data i grabbed from some remote linked servers.
help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!