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...

Error when browsing the page http://localhost/reports

I have installed SQL Server Reporting service 2005 and when I am trying to
browse the page http://localhost/reports, it is giving me following error:
System.Web.Services.Protocols.SoapException: Server was unable to process
request. --> System.IO.FileNotFoundException:
C:\WINDOWS\assembly\GAC_32\Microsoft.ReportingServices.Diagnostics\9.0.242.0__89845dcd8080cc91\ReportingServicesNativeServer.dll
at System.Diagnostics.FileVersionInfo.GetVersionInfo(String fileName) at
Microsoft.ReportingServices.Diagnostics.RSConfiguration.GetNativeProductVersion()
at
Microsoft.ReportingServices.Diagnostics.RSConfiguration.get_NativeServerProductVersion()
at
Microsoft.ReportingServices.WebServer.ReportingService2005.ServerInfoHeader..ctor()
at
Microsoft.ReportingServices.WebServer.ReportingService2005.get_ServerInfoHeaderValue() -- End of inner exception stack trace --
SQL Server 2005 is installed on different machine. I am installing SQL
Server Reporting service 2005 on CRM server. I have install/uninstall for a
number of times. Previously, it was working properly and after some
installaion/uninstallation, it has started giving the above error.Just to be sure where is can be the problem (network config, or installation
issue), have you tried to use the IP Address of the machine instead of
localhost?
http://yourip/reports
or
http://127.0.0.1/Reports
Good luck
Braulio
/// --
/// Braulio Diez
///
/// http://www.tipsdotnet.com
/// --
"Bhumit" wrote:
> I have installed SQL Server Reporting service 2005 and when I am trying to
> browse the page http://localhost/reports, it is giving me following error:
> System.Web.Services.Protocols.SoapException: Server was unable to process
> request. --> System.IO.FileNotFoundException:
> C:\WINDOWS\assembly\GAC_32\Microsoft.ReportingServices.Diagnostics\9.0.242.0__89845dcd8080cc91\ReportingServicesNativeServer.dll
> at System.Diagnostics.FileVersionInfo.GetVersionInfo(String fileName) at
> Microsoft.ReportingServices.Diagnostics.RSConfiguration.GetNativeProductVersion()
> at
> Microsoft.ReportingServices.Diagnostics.RSConfiguration.get_NativeServerProductVersion()
> at
> Microsoft.ReportingServices.WebServer.ReportingService2005.ServerInfoHeader..ctor()
> at
> Microsoft.ReportingServices.WebServer.ReportingService2005.get_ServerInfoHeaderValue() -- End of inner exception stack trace --
> SQL Server 2005 is installed on different machine. I am installing SQL
> Server Reporting service 2005 on CRM server. I have install/uninstall for a
> number of times. Previously, it was working properly and after some
> installaion/uninstallation, it has started giving the above error.
>|||Another thing to do is go to your Reporting Services Configuration Tool and
make sure all your Settings are pointing to the correct location. I found
this area to be extremely sensitive.
"Braulio Diez" wrote:
> Just to be sure where is can be the problem (network config, or installation
> issue), have you tried to use the IP Address of the machine instead of
> localhost?
> http://yourip/reports
> or
> http://127.0.0.1/Reports
> Good luck
> Braulio
> /// --
> /// Braulio Diez
> ///
> /// http://www.tipsdotnet.com
> /// --
>
>
> "Bhumit" wrote:
> > I have installed SQL Server Reporting service 2005 and when I am trying to
> > browse the page http://localhost/reports, it is giving me following error:
> >
> > System.Web.Services.Protocols.SoapException: Server was unable to process
> > request. --> System.IO.FileNotFoundException:
> > C:\WINDOWS\assembly\GAC_32\Microsoft.ReportingServices.Diagnostics\9.0.242.0__89845dcd8080cc91\ReportingServicesNativeServer.dll
> > at System.Diagnostics.FileVersionInfo.GetVersionInfo(String fileName) at
> > Microsoft.ReportingServices.Diagnostics.RSConfiguration.GetNativeProductVersion()
> > at
> > Microsoft.ReportingServices.Diagnostics.RSConfiguration.get_NativeServerProductVersion()
> > at
> > Microsoft.ReportingServices.WebServer.ReportingService2005.ServerInfoHeader..ctor()
> > at
> > Microsoft.ReportingServices.WebServer.ReportingService2005.get_ServerInfoHeaderValue() -- End of inner exception stack trace --
> >
> > SQL Server 2005 is installed on different machine. I am installing SQL
> > Server Reporting service 2005 on CRM server. I have install/uninstall for a
> > number of times. Previously, it was working properly and after some
> > installaion/uninstallation, it has started giving the above error.
> >
> >

error using Analysis Sevices in Web

Hi, i have question when i'm publishig a web page with a cube inside, the component displays the next error:

the html element at line 1, column6 (namespache) cannot appear under

then i log on into my server to the analysys Services and i can browse my cube without any problems, but the page just cannot show it, any suggestions?

thnks!!!

right... i should've been more especific. the problem was the conexion..i'm usign a web service to achieve this.. somehow.. this component caused some errors in the server...so i added a new one and changed the mappings in the web page...this solved the problem correctly

thanks anyway.. hope this helps to some of you!!

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

Error SQL 7.0

Hi,
I got this error in the error log:
2004-05-30 06:58:23.85 spid6 Table Corrupt: Object ID 0, index ID 0, page ID (1:1074103). The PageId in the page header = (0:0).
2004-05-30 06:58:24.54 spid6 Error: 823, Severity: 24, State: 1
2004-05-30 06:58:24.54 spid6 I/O error (bad page ID) detected during read of BUF pointer = 0x11efe2c0, page ptr = 0x2d016000, pageid = (0x1:0x1063b7), dbid = 9, status = 0x801, file = e:\MSSQL7\data\pruebas_Data.MDF..
2
2004-06-01 22:04:15.15 spid6 Table Corrupt: Object ID 0, index ID 0, page ID (1:76799). The PageId in the page header = (0:0).
Does anyone can tell me what that it means? Or if it is important and the way to solve
The engine has not service packs intalled
Thanks in advance
this is normally indicative of data corruption due to some hardware or
driver problem with the I/O subsystem as per below. Also would recommend
upgrading to Service Pack 4 for SQL Server
http://msdn.microsoft.com/library/de...err_1_2a0j.asp
more articles.
http://search.microsoft.com/search/r...u=Error%3a+823
Andy.
"Lomu" <anonymous@.discussions.microsoft.com> wrote in message
news:1D80669D-95F6-4903-9447-63DEB80DEDD1@.microsoft.com...
> Hi,
> I got this error in the error log:
> 2004-05-30 06:58:23.85 spid6 Table Corrupt: Object ID 0, index ID 0,
page ID (1:1074103). The PageId in the page header = (0:0).
> 2004-05-30 06:58:24.54 spid6 Error: 823, Severity: 24, State: 1
> 2004-05-30 06:58:24.54 spid6 I/O error (bad page ID) detected during
read of BUF pointer = 0x11efe2c0, page ptr = 0x2d016000, pageid =
(0x1:0x1063b7), dbid = 9, status = 0x801, file =
e:\MSSQL7\data\pruebas_Data.MDF..
> 2
>
> 2004-06-01 22:04:15.15 spid6 Table Corrupt: Object ID 0, index ID 0, page
ID (1:76799). The PageId in the page header = (0:0).
> Does anyone can tell me what that it means? Or if it is important and the
way to solve
> The engine has not service packs intalled
> Thanks in advance
|||I suggest you download and install the latest update for SQL Server 2000 Books Online. It has details
suggestions for most of the corruption errors. I know you are on 7.0, but these things applies. Also, you
might want to read below article:
http://tibdell/SQLServer/info_corrupt_suspect_db.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Lomu" <anonymous@.discussions.microsoft.com> wrote in message
news:1D80669D-95F6-4903-9447-63DEB80DEDD1@.microsoft.com...
> Hi,
> I got this error in the error log:
> 2004-05-30 06:58:23.85 spid6 Table Corrupt: Object ID 0, index ID 0, page ID (1:1074103). The PageId in
the page header = (0:0).
> 2004-05-30 06:58:24.54 spid6 Error: 823, Severity: 24, State: 1
> 2004-05-30 06:58:24.54 spid6 I/O error (bad page ID) detected during read of BUF pointer = 0x11efe2c0,
page ptr = 0x2d016000, pageid = (0x1:0x1063b7), dbid = 9, status = 0x801, file =
e:\MSSQL7\data\pruebas_Data.MDF..
> 2
>
> 2004-06-01 22:04:15.15 spid6 Table Corrupt: Object ID 0, index ID 0, page ID (1:76799). The PageId in the
page header = (0:0).
> Does anyone can tell me what that it means? Or if it is important and the way to solve
> The engine has not service packs intalled
> Thanks in advance

Error SQL 7.0

Hi
I got this error in the error log
2004-05-30 06:58:23.85 spid6 Table Corrupt: Object ID 0, index ID 0, page ID (1:1074103). The PageId in the page header = (0:0)
2004-05-30 06:58:24.54 spid6 Error: 823, Severity: 24, State:
2004-05-30 06:58:24.54 spid6 I/O error (bad page ID) detected during read of BUF pointer = 0x11efe2c0, page ptr = 0x2d016000, pageid = (0x1:0x1063b7), dbid = 9, status = 0x801, file = e:\MSSQL7\data\pruebas_Data.MDF.
2004-06-01 22:04:15.15 spid6 Table Corrupt: Object ID 0, index ID 0, page ID (1:76799). The PageId in the page header = (0:0)
Does anyone can tell me what that it means? Or if it is important and the way to solv
The engine has not service packs intalle
Thanks in advancethis is normally indicative of data corruption due to some hardware or
driver problem with the I/O subsystem as per below. Also would recommend
upgrading to Service Pack 4 for SQL Server
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/trblsql/tr_reslsyserr_1_2a0j.asp
more articles.
http://search.microsoft.com/search/results.aspx?st=b&na=88&View=en-us&qu=Error%3a+823
Andy.
"Lomu" <anonymous@.discussions.microsoft.com> wrote in message
news:1D80669D-95F6-4903-9447-63DEB80DEDD1@.microsoft.com...
> Hi,
> I got this error in the error log:
> 2004-05-30 06:58:23.85 spid6 Table Corrupt: Object ID 0, index ID 0,
page ID (1:1074103). The PageId in the page header = (0:0).
> 2004-05-30 06:58:24.54 spid6 Error: 823, Severity: 24, State: 1
> 2004-05-30 06:58:24.54 spid6 I/O error (bad page ID) detected during
read of BUF pointer = 0x11efe2c0, page ptr = 0x2d016000, pageid =(0x1:0x1063b7), dbid = 9, status = 0x801, file =e:\MSSQL7\data\pruebas_Data.MDF..
> 2
>
> 2004-06-01 22:04:15.15 spid6 Table Corrupt: Object ID 0, index ID 0, page
ID (1:76799). The PageId in the page header = (0:0).
> Does anyone can tell me what that it means? Or if it is important and the
way to solve
> The engine has not service packs intalled
> Thanks in advance|||I suggest you download and install the latest update for SQL Server 2000 Books Online. It has details
suggestions for most of the corruption errors. I know you are on 7.0, but these things applies. Also, you
might want to read below article:
http://tibdell/SQLServer/info_corrupt_suspect_db.asp
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Lomu" <anonymous@.discussions.microsoft.com> wrote in message
news:1D80669D-95F6-4903-9447-63DEB80DEDD1@.microsoft.com...
> Hi,
> I got this error in the error log:
> 2004-05-30 06:58:23.85 spid6 Table Corrupt: Object ID 0, index ID 0, page ID (1:1074103). The PageId in
the page header = (0:0).
> 2004-05-30 06:58:24.54 spid6 Error: 823, Severity: 24, State: 1
> 2004-05-30 06:58:24.54 spid6 I/O error (bad page ID) detected during read of BUF pointer = 0x11efe2c0,
page ptr = 0x2d016000, pageid = (0x1:0x1063b7), dbid = 9, status = 0x801, file =e:\MSSQL7\data\pruebas_Data.MDF..
> 2
>
> 2004-06-01 22:04:15.15 spid6 Table Corrupt: Object ID 0, index ID 0, page ID (1:76799). The PageId in the
page header = (0:0).
> Does anyone can tell me what that it means? Or if it is important and the way to solve
> The engine has not service packs intalled
> Thanks in advance

Error SQL 7.0

Hi,
I got this error in the error log:
2004-05-30 06:58:23.85 spid6 Table Corrupt: Object ID 0, index ID 0, page
ID (1:1074103). The PageId in the page header = (0:0).
2004-05-30 06:58:24.54 spid6 Error: 823, Severity: 24, State: 1
2004-05-30 06:58:24.54 spid6 I/O error (bad page ID) detected during read
of BUF pointer = 0x11efe2c0, page ptr = 0x2d016000, pageid = (0x1:0x1063b7)
, dbid = 9, status = 0x801, file = e:\MSSQL7\data\pruebas_Data.MDF..
2
2004-06-01 22:04:15.15 spid6 Table Corrupt: Object ID 0, index ID 0, page ID
(1:76799). The PageId in the page header = (0:0).
Does anyone can tell me what that it means? Or if it is important and the wa
y to solve
The engine has not service packs intalled
Thanks in advancethis is normally indicative of data corruption due to some hardware or
driver problem with the I/O subsystem as per below. Also would recommend
upgrading to Service Pack 4 for SQL Server
serr_1_2a0j.asp" target="_blank">http://msdn.microsoft.com/library/d...serr_1_2a0j.asp
more articles.
823" target="_blank">http://search.microsoft.com/search/...%3a+
823
Andy.
"Lomu" <anonymous@.discussions.microsoft.com> wrote in message
news:1D80669D-95F6-4903-9447-63DEB80DEDD1@.microsoft.com...
> Hi,
> I got this error in the error log:
> 2004-05-30 06:58:23.85 spid6 Table Corrupt: Object ID 0, index ID 0,
page ID (1:1074103). The PageId in the page header = (0:0).
> 2004-05-30 06:58:24.54 spid6 Error: 823, Severity: 24, State: 1
> 2004-05-30 06:58:24.54 spid6 I/O error (bad page ID) detected during
read of BUF pointer = 0x11efe2c0, page ptr = 0x2d016000, pageid =
(0x1:0x1063b7), dbid = 9, status = 0x801, file =
e:\MSSQL7\data\pruebas_Data.MDF..
> 2
>
> 2004-06-01 22:04:15.15 spid6 Table Corrupt: Object ID 0, index ID 0, page
ID (1:76799). The PageId in the page header = (0:0).
> Does anyone can tell me what that it means? Or if it is important and the
way to solve
> The engine has not service packs intalled
> Thanks in advance|||I suggest you download and install the latest update for SQL Server 2000 Boo
ks Online. It has details
suggestions for most of the corruption errors. I know you are on 7.0, but th
ese things applies. Also, you
might want to read below article:
http://tibdell/SQLServer/info_corrupt_suspect_db.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Lomu" <anonymous@.discussions.microsoft.com> wrote in message
news:1D80669D-95F6-4903-9447-63DEB80DEDD1@.microsoft.com...
> Hi,
> I got this error in the error log:
> 2004-05-30 06:58:23.85 spid6 Table Corrupt: Object ID 0, index ID 0, page ID (1
:1074103). The PageId in
the page header = (0:0).
> 2004-05-30 06:58:24.54 spid6 Error: 823, Severity: 24, State: 1
> 2004-05-30 06:58:24.54 spid6 I/O error (bad page ID) detected during read of BU
F pointer = 0x11efe2c0,
page ptr = 0x2d016000, pageid = (0x1:0x1063b7), dbid = 9, status = 0x801, fi
le =
e:\MSSQL7\data\pruebas_Data.MDF..
> 2
>
> 2004-06-01 22:04:15.15 spid6 Table Corrupt: Object ID 0, index ID 0, page ID (1:76
799). The PageId in the
page header = (0:0).
> Does anyone can tell me what that it means? Or if it is important and the
way to solve
> The engine has not service packs intalled
> Thanks in advance

Error running script: sp1_serv_uni.sql(1), while installing SP3(sql2ksp3)

Thanks for the reply.
The link which you have given me, I went to that page but
the solution they gave is to install the latest service
pack or a work around solution, I was trying to install
the latest service pack itself not the service pack 1,the
solution they gave is for servive pack 1 not for service
pack 3, so do you have any idea what I should do.
Please mail me a response.
Regards,
Jyotshna.
--Original Message--
this error may occur if the master database files have
been moved from the
orignal installation location.
check the following link:
http://support.microsoft.com/default.aspx?scid=kb;en-
us;Q308753
regards,
Harsh.
"Jyotshna Vonguru" <jyotshna.vonguru@.icn.siemens.com>
wrote in message
news:568701c3e51c$aefe4410$a401280a@.phx.gbl...
Hello,
I am getting an error called:
Error running script: sp1_serv_uni.sql(1), while
installing service pack 3(sql2ksp3).
Could anybody tell me, how to correct this.
Is there anyway.
Please give me a quick solution.
Thank you,
Jyotshna.Please find the corresponding *.out file to see a detailed error mesage.
Thanks,
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.|||I too am getting the same problem.
The *.out file says (1 row affected)
Thats it.
This is driving me made, as I have 3 x 2003 Servers I am building with SQL 2000 on them, and am getting exactly the same error on all 3.|||I'm having the exact same problem.
No one has been able to help me.
Would I be correct in guessing that this is on a Windows 2003 Server, and
its a fresh install of SQL 2000.
Dave.|||What does the sqlstp.log say?
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.

Error running script: sp1_serv_uni.sql(1), while installing SP3(sql2ksp3)

Thanks for the reply.
The link which you have given me, I went to that page but
the solution they gave is to install the latest service
pack or a work around solution, I was trying to install
the latest service pack itself not the service pack 1,the
solution they gave is for servive pack 1 not for service
pack 3, so do you have any idea what I should do.
Please mail me a response.
Regards,
Jyotshna.
--Original Message--
this error may occur if the master database files have
been moved from the
orignal installation location.
check the following link:
http://support.microsoft.com/default.aspx?scid=kb;en-
us;Q308753
regards,
Harsh.
"Jyotshna Vonguru" <jyotshna.vonguru@.icn.siemens.com>
wrote in message
news:568701c3e51c$aefe4410$a401280a@.phx.gbl...
Hello,
I am getting an error called:
Error running script: sp1_serv_uni.sql(1), while
installing service pack 3(sql2ksp3).
Could anybody tell me, how to correct this.
Is there anyway.
Please give me a quick solution.
Thank you,
Jyotshna.Please find the corresponding *.out file to see a detailed error mesage.
Thanks,
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.|||I'm having the exact same problem.
No one has been able to help me.
Would I be correct in guessing that this is on a Windows 2003 Server, and
its a fresh install of SQL 2000.
Dave.|||I too am getting the same problem.
The *.out file says (1 row affected)
Thats it.
This is driving me made, as I have 3 x 2003 Servers I am building with SQL 2
000 on them, and am getting exactly the same error on all 3.|||What does the sqlstp.log say?
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.