Take the 2-minute tour ×
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. It's 100% free, no registration required.

Does anybody know how i could use a linked server as a data source for a report model in SQL server 2008 r2? or how i could make this linked server a data source on a report model? Please help. Thank you.

share|improve this question
add comment

2 Answers

up vote 3 down vote accepted

Why not just put the datapull for the linked data source in a stored procedure and then access it from a "local" database?

share|improve this answer
    
How do I accomplish that? –  db7 May 2 '11 at 11:22
1  
@db7 via something like "create proc [procname] [arglist] as begin exec [linkedserver].[database].[schema].[remoteprocname] [arglist] end" ... –  jcolebrand May 2 '11 at 15:03
add comment

The two ideas are unrelated

  • A linked server is for SQL Server to other database server connections at the database level.
  • In SSRS you have DataSets which point to a database

There are some cases where the DataSet calls a SQL Server database that uses a linked server: but I suspect you aren't that far yet.

If you think you need to use a "linked server" to call one database only to get data from another database, then why not call the other database directly. And stop thinking of linked servers

share|improve this answer
    
The linked server is a Linux box. –  db7 May 3 '11 at 11:05
    
@db7 it doesn't matter. If you can set up a linked server then can set it up as a datasource in SSRS –  gbn May 3 '11 at 11:43
add comment

Your Answer

 
discard

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.