creating report model timing out

i am trying to create a report model using our sms 2003 sql 2000 database
some of the tables in the model are large and are timing out.
where is the setting that controls the time out parameter in report services
thanksI didn't think you could make report models in SQL 2000, I thought this was
new to SQL 2005. Anyway I had a timeout problem that went away with SQL
2005 sp1. I think sp1 fixed a lot of issues with the ad-hoc report builder
too.
Steve MunLeeuw
"pghboemike" <pghboemike@.discussions.microsoft.com> wrote in message
news:27CA16A8-EFB2-477E-8549-BD92C35ED593@.microsoft.com...
>i am trying to create a report model using our sms 2003 sql 2000 database
> some of the tables in the model are large and are timing out.
> where is the setting that controls the time out parameter in report
> services
> thanks|||Alternatively, If you go to
Start -> All Programs -> Ms SQL Server 2005 -> Configuration Tools ->
Reporting Services Configuration
You can alter the timeout value in there.
Taz
"Steve MunLeeuw" <smunson@.clearwire.net> wrote in message
news:%23Kncke10GHA.1040@.TK2MSFTNGP06.phx.gbl...
>I didn't think you could make report models in SQL 2000, I thought this was
>new to SQL 2005. Anyway I had a timeout problem that went away with SQL
>2005 sp1. I think sp1 fixed a lot of issues with the ad-hoc report builder
>too.
> Steve MunLeeuw|||Modifying the timeout doesn't stop it from timing out. The max in 600
seconds and that isn't long enough for large sets of data. These report
models are pretty much useless unless you have trivial amounts of data.
Pointless...
"Tarun Mistry" wrote:
> Alternatively, If you go to
> Start -> All Programs -> Ms SQL Server 2005 -> Configuration Tools ->
> Reporting Services Configuration
> You can alter the timeout value in there.
> Taz
> "Steve MunLeeuw" <smunson@.clearwire.net> wrote in message
> news:%23Kncke10GHA.1040@.TK2MSFTNGP06.phx.gbl...
> >I didn't think you could make report models in SQL 2000, I thought this was
> >new to SQL 2005. Anyway I had a timeout problem that went away with SQL
> >2005 sp1. I think sp1 fixed a lot of issues with the ad-hoc report builder
> >too.
> >
> > Steve MunLeeuw
>
>