Showing posts with label home. Show all posts
Showing posts with label home. Show all posts

Monday, March 12, 2012

Error when connecting for the first time

Hi, I get the below error (after clicking login in my home page, so home page works well) when I open my website for the first time after I restart my server or my client machine.

" Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding."

From the next time onwards it is connecting without any problems.

can anyone figure out what could be the problem here?

Are you running SqlExpress?

Did you set the service to start when the server starts? Otherwise it may be getting started on first call and that adds overhead (time) and may be the issue.

|||

Yes I use SQLExpress.

Services are fine. It is in autostart mode and so running automatically everytime i restart.

|||

Hmm... more then likely either some service or some precompilation is in need of being done.

If you leave your site untouched for an hour and come back, does it timeout again? Trying to see if it's a service or simply the first-hit drain on the system thats causing the issue.

|||

this happens only when i use for the first timewww.XXXXXX.com...

I missed the below in my first post and added now

"after clicking login in my home page, so home page works well"

|||

Sounds like that's the first call to the DB... so that's most likely the issue.

You may want to hit up the SqlExpress forum...perhaps someone who watches that one will know more but I know I've had it happen in the past but not with regularity... try prefiring a call to the DB from the Application_Start in the global.asax perhaps, to take that initial hit...

Friday, February 24, 2012

error to run reporting service

When I try to run the web page which host the report, I am not able to reach the home page and following error show up.

" The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content and then restart the service. Check the documentation for more information. (rsReportServerDisabled) Get Online Help
Bad Data."

I then went to Reporting Services Configuration Manager -> Encryption Keys

then I clicked the Change button

after all these I can get back to the reporting service home page. Any one can tell me the reason of this error? thanks

when I tried to open the reporting service web site. The following error pop up

The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content and then restart the service. Check the documentation for more information. (rsReportServerDisabled) Get Online Help
Bad Data.

Then I go to Reporting Service Manager-> Encryption keys. After I changed the encryption keys; the reporting service works again. Could anyone explain the reason behind this? ans is that the right way to reslove the error?

Thanks

|||Reporting Services data is encrypted. Did you restore the database or change the service account not through the Condifguration manager ? After changing / deleting the key 8and the encrypted content) the database was empty, you had a new key and you could start all over.

Jens K. Suessmeyer.

http://www.sqlserver2005.de