how to access multiple databases | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

how to access multiple databases


Hi all, I have a query that joins data from multiple databases. How do I setup the datasource(s) in BI for this? I setup multiple datasource, one for each db, and I can run the report in preview but when I try to deploy it it prompts me for a Reporting Services Login User Name and Password. I can deploy other reports. Reporting Services is running on my laptop and I am have goddess permissions. Any ideas of what’s going on or things to try would be appreciated. Thanks,
Elizabeth
DO you have BIDS installed? Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
I didn’t find a resolution to the "Reporting Services Login" prompt and google turned up others with the same problem and no resolution. I ended up scrapping the report and rebuilding it. I used a SQL Server login instead of Win Integration and made some other changes as well so unfortunately I don’t know the cause or the solution.
quote:Originally posted by satya DO you have BIDS installed? Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.

The data sources are dependant upon the login that has relevant access on referenced tables, in your case if that login has SYSADMIN privilege then it shouldn’t be a problem. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
]]>