sql server reporting services: How can I avoid the connection TimeOuts while creating a model for Report
Builder? The databases we're using are pretty big (100s of tables) and in
the millions of rows. Is Report Builder just not up for this kind of

Are you trying to create a model that has 100s of tables? The whole point of
Report Builder is to make reporting easier for end users. So why not create
different models that have the data that different users/groups need access
to? (each model having only a few tables, not 100s.) Also, with that much
data, have you considered analysis services?

Mike G.


[quoted text, click to view]

I kept timing out while trying to deploy a model and found out the
deployment was being blocked by another process which was 'getting
model information'...the process was hung up for two days before I
found it.