Got to be something wrong... http://myserver/reports REALLY slow

Is anyone experiencing the folder.aspx taking a really long time to render
the list of reports? On our server, all other web sites a very quick, but:
opening http://myserver/reports/Pages/Folder.aspx can take as long as 40
seconds to list a few reports!
Thinking it must be an install or configuration issue... any idea?
All comments appreciated.
ThanksThere was a whole thread awhile back that may help you understand the issue:
http://www.msdn.microsoft.com/newsgroups/managed/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=3031983d-75f9-466c-ad3a-3d76f0bebdc5
--
Adrian M.
MCP
"Rick Matthys" <RickMatthys@.discussions.microsoft.com> wrote in message
news:7B0FF73B-4295-4B3E-AFBA-4B0DF11E9722@.microsoft.com...
> Is anyone experiencing the folder.aspx taking a really long time to render
> the list of reports? On our server, all other web sites a very quick,
> but:
> opening http://myserver/reports/Pages/Folder.aspx can take as long as 40
> seconds to list a few reports!
> Thinking it must be an install or configuration issue... any idea?
> All comments appreciated.
> Thanks|||Try re-starting IIS or ASPNET. I had that problem too, and I
re-started IIS and it helped quite a bit.|||thanks for the response Adrian and John... changed the IIS recycle setting,
restarted IIS, and presto, page comes up a lot faster!
"Adrian M." wrote:
> There was a whole thread awhile back that may help you understand the issue:
> http://www.msdn.microsoft.com/newsgroups/managed/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=3031983d-75f9-466c-ad3a-3d76f0bebdc5
> --
> Adrian M.
> MCP
>
> "Rick Matthys" <RickMatthys@.discussions.microsoft.com> wrote in message
> news:7B0FF73B-4295-4B3E-AFBA-4B0DF11E9722@.microsoft.com...
> > Is anyone experiencing the folder.aspx taking a really long time to render
> > the list of reports? On our server, all other web sites a very quick,
> > but:
> >
> > opening http://myserver/reports/Pages/Folder.aspx can take as long as 40
> > seconds to list a few reports!
> >
> > Thinking it must be an install or configuration issue... any idea?
> >
> > All comments appreciated.
> >
> > Thanks
>
>sql

Good old Login failed for user

I had to re-install Sql Server and now I can't log on. I get...

Login failed for user 'JobsWeekly_Login'.

I can't see anything wrong with the connection string. It used to work.Might re-installing Sql Server have got its knickers in a twist?

Cheers, WT.

When you re-installed SQL Server, did you re-add that user with the same password and give it the correct permissions on the database that you're trying to access.|||

As far as I know I've done it all.

I deleted the user, added a new login, assigned the db to the login and added all the permissions. Then using this logon I was then able to log onto the database with Management Studio and browse the tables.

|||So, does that mean it's working now?|||No, the web app I'm working on can't log on to the db.|||To rule out the obvious, is everything in your connection string perfect (server address, username, password, database. etc.)?|||

I haven't touched it since it was working...

"data source=TEST;User ID=JobsWeekly_Login;Password=password;"

The default database is set on the login. The db and ISS are both on my local machine by the way.

|||Ahh, its working. I changed the password to 'pass'. I think having the password as 'password;' confused the connection string parser. Perhaps it interpreted the ';' as a delimiter instead of part of the password. Still, it worked before! Thanks for your help.