Hi, 1.) I just installed SQL Server 2008 including SSRS. I created a simple database. I then created an SSRS project and wrote a report using my simple database. It built and deployed fine. 2.) I downloaded the AdventureWorksDW2008 database. In the same Project as above, I created another report using AdventureWorksDW2008 as a Datasource. It previewed fine and I saw my data. The project with the two reports built fine, but the AdventureWorksDW report did not deploy (but the first report would???) The deployment would eventually timeout. The project would deploy except for the AdventureWorks report. 3.) I scripted the AdventureWorksDW2008 database, changed only the name in the script to AdventureWorksDW20082 (through out the script) and ran it. I created the new database (AdventureWorksDW20082) and a simple table with data. I added a third report to the project the queried my new database (AdventureWorksDW20082). This report deployed fine. ... It seems if I create the database there is no problem deploying, but the AdventureWork database I downloaded, I can't deploy!!! I can query and preview the data in a report in BIDS, but deployment fails due to a timeout. Does anyone know where I should start looking? It must be some permissions thing. The Service account I am using for SSRS is "Network Service", but I do not see this User anywhere in my database's security settings. What could be going on? Confused, please help Thanks, Mike

Hmm looks odd. If you just rename the database (no need to script out) will it work for you?Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/

Renaming the database didn't help. I created a project with two reports, one uses AdventureWorksDW2008 that I renamed to AdventureWorksDW200orig and the other report use a database I created. Build work, when I deploy the AdventureWorksDW2008orig times out. BIDS can connect and preview data from AdventureWorksDW2008orig. So I am thinking that the reportserver can not access the database. How does the reportserver login to AdventureWorks? Using the SSRS service account, corrrect? Thanks for the response, am willing to try anything to figure this out.

Hi, As you suspected, it seems like a security issue in accessing the database. You can set the credentials to access the database within the datasource itself. By default it get set to windows authentication. To try an alternate account, 1. open the datasource 2. click on the credentials tab 3. set the account that you are sure of having access to database without any issue 4. click ok. 5. try deploying the datasource again to report server. hope this helps. Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful. BH

OK, I think figured it out. It only took me two months. I am working through a SSRS step by step book and am a newbie at SSRS. I was using an older IBM thinkpad running XP Pro as development enviorment. I started creating small tables with two rows in various databases and writting reports from them. They always deployed. But the AdventureWorks Report from my Step by Step book would not deploy. I gradually increase the complexity of the query that worked to mirror the adventureWorks report, and eventually it failed to deploy too. I ran a report with three columns and 100 rows and it would deploy. I tried to grouped the report by one of the columns and it failed. I found at a certain point of complexity in the report, it hangs because my thinkpad doesn't have enough resources. Any thoughts? Thanks again to everyone who replied.