SQL Server Performance

how to access multiple databases

Discussion in 'SQL Server 2005 Reporting Services' started by eklpublic, Apr 19, 2007.

  1. eklpublic Member


    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
  2. satya Moderator

    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.
  3. eklpublic Member



    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.
  4. satya Moderator

    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.

Share This Page