CODEWITHSUNDEEP
sql-serverreporting-services
stighy
stighy

Reputation: 7170

Is it possible to create a Sql Server Report (using SSRS) based on a linked database?

I have a Sql Server 2005 with SSRS configured on a local server. Then, we have on the same server a Linked Server to a Sql 2012 on a remote server.

I would like to do a report based on a db on the linked sql 2012, but i can't neither to connect ...

So, is it possible to do ?

Upvotes: 0

Views: 51

Answers (1)

Hannover Fist
Hannover Fist

Reputation: 10870

Are you connecting to the 2012 server directly or do you need to go through another server first?

If you can connect to the 2012 server, you can just use the Data Source Connection Properties to connect to the server.

enter image description here

If you are using a Linked Server to get to the other server, you would set the connection to the server and a database. Then you would need to include the linked server reference in the name.

SELECT * 
FROM LINKED_SERVER_NAME.DATABASE_NAME.dbo.TABLE_NAME

Upvotes: 1

Related Questions