Could not start the SQL Server Reporting Services

I am running SQL Server 2005 Enterprise and cannot get the Reporting
Service to start. When trying to start the Reporting Service from the
Control Pannel/Administrative Tools/Services I get the following error:
[ERROR]
Microsoft Management Console
Could not start the SQL Server Reporting Services (MSSQLSERVER) service
on Local Computer. The service did not return an error. This could be
an internal Windows error or an internal service error. If the problem
persists, contact your system administrator.
[/ERROR]
When I try to connect to the service from the Microsoft SQL Server
Management Studio, I get the following error (In an attempt to seperate
error msg, using <error> tags):
[ERROR]
TITLE: Connect to Server
--
Cannot connect to YAMHILL.
--
ADDITIONAL INFORMATION:
Client found response content type of 'text/html; charset=utf-8', but
expected 'text/xml'.
The request failed with the error message:
--
<html>
<head>
<title>
SQL Server Reporting Services
</title><meta name="Generator" content="Microsoft SQL Server
Reporting Services 9.00.1399.00" />
<meta name="HTTP Status" content="500" />
<meta name="ProductLocaleID" content="9" />
<meta name="CountryLocaleID" content="1033" />
<meta name="StackTrace" content=" at
Microsoft.ReportingServices.Diagnostics.AuthenticationExtensionFactory.get_AuthenticationExtension()
at
Microsoft.ReportingServices.Diagnostics.UserUtil.GetUserNameFromExtension()
at
Microsoft.ReportingServices.Diagnostics.UserUtil.GetCurrentUserName()
at
Microsoft.ReportingServices.WebServer.Global.ShouldRejectAntiDos()
at
Microsoft.ReportingServices.WebServer.Global.Application_AuthenticateRequest(Object
sender, EventArgs e)" />
<style>
BODY {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE: 8pt;
COLOR:black}
H1 {FONT-FAMILY:Verdana; FONT-WEIGHT:700; FONT-SIZE:15pt}
LI {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE:8pt;
DISPLAY:inline}
.ProductInfo {FONT-FAMILY:Verdana; FONT-WEIGHT:bold; FONT-SIZE: 8pt;
COLOR:gray}
A:link {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC;
TEXT-DECORATION:none}
A:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#FF3300;
TEXT-DECORATION:underline}
A:visited {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC;
TEXT-DECORATION:none}
A:visited:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; color:#FF3300;
TEXT-DECORATION:underline}
</style>
</head><body bgcolor="white">
<h1>
Reporting Services Error<hr width="100%" size="1" color="silver" />
</h1><ul>
<li>The report server has encountered a configuration error. See the
report server log files for more information.
(rsServerConfigurationError) <a
href="http://links.10026.com/?link=http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&EvtID=rsServerConfigurationError&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=9.00.1399.00"
target="_blank">Get Online Help</a></li>
</ul><hr width="100%" size="1" color="silver" /><span
class="ProductInfo">SQL Server Reporting Services</span>
</body>
</html>
--. (Microsoft.SqlServer.Management.UI.RSClient)
--
BUTTONS:
OK
--
[/ERROR]
Thanks in advance...Any help is appreciated.
AntoineHi Antoine.
Were you able to get around this? I have having the same problem.
Thanks.
"jonathan_antoine@.excite.com" wrote:
> I am running SQL Server 2005 Enterprise and cannot get the Reporting
> Service to start. When trying to start the Reporting Service from the
> Control Pannel/Administrative Tools/Services I get the following error:
> [ERROR]
> Microsoft Management Console
> Could not start the SQL Server Reporting Services (MSSQLSERVER) service
> on Local Computer. The service did not return an error. This could be
> an internal Windows error or an internal service error. If the problem
> persists, contact your system administrator.
> [/ERROR]
> When I try to connect to the service from the Microsoft SQL Server
> Management Studio, I get the following error (In an attempt to seperate
> error msg, using <error> tags):
> [ERROR]
> TITLE: Connect to Server
> --
> Cannot connect to YAMHILL.
> --
> ADDITIONAL INFORMATION:
> Client found response content type of 'text/html; charset=utf-8', but
> expected 'text/xml'.
> The request failed with the error message:
> --
> <html>
> <head>
> <title>
> SQL Server Reporting Services
> </title><meta name="Generator" content="Microsoft SQL Server
> Reporting Services 9.00.1399.00" />
> <meta name="HTTP Status" content="500" />
> <meta name="ProductLocaleID" content="9" />
> <meta name="CountryLocaleID" content="1033" />
> <meta name="StackTrace" content=" at
> Microsoft.ReportingServices.Diagnostics.AuthenticationExtensionFactory.get_AuthenticationExtension()
> at
> Microsoft.ReportingServices.Diagnostics.UserUtil.GetUserNameFromExtension()
> at
> Microsoft.ReportingServices.Diagnostics.UserUtil.GetCurrentUserName()
> at
> Microsoft.ReportingServices.WebServer.Global.ShouldRejectAntiDos()
> at
> Microsoft.ReportingServices.WebServer.Global.Application_AuthenticateRequest(Object
> sender, EventArgs e)" />
> <style>
> BODY {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE: 8pt;
> COLOR:black}
> H1 {FONT-FAMILY:Verdana; FONT-WEIGHT:700; FONT-SIZE:15pt}
> LI {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE:8pt;
> DISPLAY:inline}
> .ProductInfo {FONT-FAMILY:Verdana; FONT-WEIGHT:bold; FONT-SIZE: 8pt;
> COLOR:gray}
> A:link {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC;
> TEXT-DECORATION:none}
> A:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#FF3300;
> TEXT-DECORATION:underline}
> A:visited {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC;
> TEXT-DECORATION:none}
> A:visited:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; color:#FF3300;
> TEXT-DECORATION:underline}
> </style>
> </head><body bgcolor="white">
> <h1>
> Reporting Services Error<hr width="100%" size="1" color="silver" />
> </h1><ul>
> <li>The report server has encountered a configuration error. See the
> report server log files for more information.
> (rsServerConfigurationError) <a
> href="http://links.10026.com/?link=http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&EvtID=rsServerConfigurationError&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=9.00.1399.00"
> target="_blank">Get Online Help</a></li>
> </ul><hr width="100%" size="1" color="silver" /><span
> class="ProductInfo">SQL Server Reporting Services</span>
> </body>
> </html>
> --. (Microsoft.SqlServer.Management.UI.RSClient)
> --
> BUTTONS:
> OK
> --
> [/ERROR]
> Thanks in advance...Any help is appreciated.
> Antoine
>|||"jonathan_antoine@.excite.com" wrote:
> I am running SQL Server 2005 Enterprise and cannot get the Reporting
> Service to start. When trying to start the Reporting Service from the
> Control Pannel/Administrative Tools/Services I get the following error:
> [ERROR]
> Microsoft Management Console
> Could not start the SQL Server Reporting Services (MSSQLSERVER) service
> on Local Computer. The service did not return an error. This could be
> an internal Windows error or an internal service error. If the problem
> persists, contact your system administrator.
> [/ERROR]
> When I try to connect to the service from the Microsoft SQL Server
> Management Studio, I get the following error (In an attempt to seperate
> error msg, using <error> tags):
> [ERROR]
> TITLE: Connect to Server
> --
> Cannot connect to YAMHILL.
> --
> ADDITIONAL INFORMATION:
> Client found response content type of 'text/html; charset=utf-8', but
> expected 'text/xml'.
> The request failed with the error message:
> --
> <html>
> <head>
> <title>
> SQL Server Reporting Services
> </title><meta name="Generator" content="Microsoft SQL Server
> Reporting Services 9.00.1399.00" />
> <meta name="HTTP Status" content="500" />
> <meta name="ProductLocaleID" content="9" />
> <meta name="CountryLocaleID" content="1033" />
> <meta name="StackTrace" content=" at
> Microsoft.ReportingServices.Diagnostics.AuthenticationExtensionFactory.get_AuthenticationExtension()
> at
> Microsoft.ReportingServices.Diagnostics.UserUtil.GetUserNameFromExtension()
> at
> Microsoft.ReportingServices.Diagnostics.UserUtil.GetCurrentUserName()
> at
> Microsoft.ReportingServices.WebServer.Global.ShouldRejectAntiDos()
> at
> Microsoft.ReportingServices.WebServer.Global.Application_AuthenticateRequest(Object
> sender, EventArgs e)" />
> <style>
> BODY {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE: 8pt;
> COLOR:black}
> H1 {FONT-FAMILY:Verdana; FONT-WEIGHT:700; FONT-SIZE:15pt}
> LI {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE:8pt;
> DISPLAY:inline}
> .ProductInfo {FONT-FAMILY:Verdana; FONT-WEIGHT:bold; FONT-SIZE: 8pt;
> COLOR:gray}
> A:link {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC;
> TEXT-DECORATION:none}
> A:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#FF3300;
> TEXT-DECORATION:underline}
> A:visited {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC;
> TEXT-DECORATION:none}
> A:visited:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; color:#FF3300;
> TEXT-DECORATION:underline}
> </style>
> </head><body bgcolor="white">
> <h1>
> Reporting Services Error<hr width="100%" size="1" color="silver" />
> </h1><ul>
> <li>The report server has encountered a configuration error. See the
> report server log files for more information.
> (rsServerConfigurationError) <a
> href="http://links.10026.com/?link=http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&EvtID=rsServerConfigurationError&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=9.00.1399.00"
> target="_blank">Get Online Help</a></li>
> </ul><hr width="100%" size="1" color="silver" /><span
> class="ProductInfo">SQL Server Reporting Services</span>
> </body>
> </html>
> --. (Microsoft.SqlServer.Management.UI.RSClient)
> --
> BUTTONS:
> OK
> --
> [/ERROR]
> Thanks in advance...Any help is appreciated.
> Antoine
I'm having a similar problem, I can't get the Reporting Service to run (SQL
2K5, Win2K Server). Trying to start the service with the configuration tool
throws a timeout error, trying to start the service through the Control Panel
throws essentially the same error you posted. I've checked the service
login, it's LocalSystem. Is there a config file where I can change the
timeout? I have had no luck on Google, these message boards, or MS SQL help.
This is very frustrating! I never had any problems like this with MySQL.
OK, I know MySQL doesn't have a reporting module, but installation was much
quicker and smoother, there's one file with all configuration parameters,
it's well-documented, and oh yeah faster, lower-impact, and free.
Any advice is appreciated! I don't know what to try.

Could I use SQL "Select Case .. When..." in ADODB.Recordset().open

Is there any SQL Error?

Or I have to use Select case in VB code to control SQL instead.

Thank you for any ans.

NunoNuno (ranocha@.chula.com) writes:
> Is there any SQL Error?
> Or I have to use Select case in VB code to control SQL instead.
>
> Thank you for any ans.

I'm afraid that the question you have posted provides far too little
of information to be useful. Please post the code you are having problem
with.

--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||
Thank you Erland Sommarskog. I use VS.net webservice to connect SQL
server. Could I try with the following code (I'm not sure that I can use
"SELECT CASE" sql with this or not)
'Dim objADORS_ As New ADODB.Recordset()
'objADORS_.Open("SELECT CASE
DateDiff('d',[tblHeader].[start_Weekend]," & to_date & ")" & _
' " WHEN 0 THEN sum([tblTimeSheet].[sat]) +
sum[tblMiscellenous].[sat]" & _
' " WHEN 1 THEN sum([tblTimeSheet].[sun]) +
sum[tblMiscellenous].[sun]" & _
' " WHEN 2 THEN sum([tblTimeSheet].[mon]) +
sum[tblMiscellenous].[mon]" & _
' " WHEN 3 THEN sum([tblTimeSheet].[tue]) +
sum[tblMiscellenous].[tue]" & _
' " WHEN 4 THEN sum([tblTimeSheet].[wed]) +
sum[tblMiscellenous].[wed]" & _
' " WHEN 5 THEN sum([tblTimeSheet].[thu]) +
sum[tblMiscellenous].[thu]" & _
' " WHEN 6 THEN sum([tblTimeSheet].[fri]) +
sum[tblMiscellenous].[fri]" & _
' " ELSE 0 " & _
'" END as HrsUsed" & _
'" FROM(tblHeader, tblTimeSheet, tblMiscellenous)" & _
'" WHERE(tblHeader.HID = tblTimeSheet.HID and
tblHeader.HID=tblMiscellenous.HID) " & _
'" and ('" & to_date & "' between
[tblHeader].[start_weekend] and [tblHeader].[end_weekend])" & _
'" and tblHeader.initial = '" & ini & "'" & _
'" GROUP BY [tblHeader].[start_Weekend]")

thank you for your kindness ans.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!|||A Rugchatjaroen (ranocha@.chula.com) writes:
> Thank you Erland Sommarskog. I use VS.net webservice to connect SQL
> server. Could I try with the following code (I'm not sure that I can use
> "SELECT CASE" sql with this or not)
> 'Dim objADORS_ As New ADODB.Recordset()
> 'objADORS_.Open("SELECT CASE
> DateDiff('d',[tblHeader].[start_Weekend]," & to_date & ")" & _
> ' " WHEN 0 THEN sum([tblTimeSheet].[sat]) +
> sum[tblMiscellenous].[sat]" & _
> ' " WHEN 1 THEN sum([tblTimeSheet].[sun]) +
> sum[tblMiscellenous].[sun]" & _
> ' " WHEN 2 THEN sum([tblTimeSheet].[mon]) +
> sum[tblMiscellenous].[mon]" & _
> ' " WHEN 3 THEN sum([tblTimeSheet].[tue]) +
> sum[tblMiscellenous].[tue]" & _
> ' " WHEN 4 THEN sum([tblTimeSheet].[wed]) +
> sum[tblMiscellenous].[wed]" & _
> ' " WHEN 5 THEN sum([tblTimeSheet].[thu]) +
> sum[tblMiscellenous].[thu]" & _
> ' " WHEN 6 THEN sum([tblTimeSheet].[fri]) +
> sum[tblMiscellenous].[fri]" & _
> ' " ELSE 0 " & _
> ' " END as HrsUsed" & _
> '" FROM(tblHeader, tblTimeSheet, tblMiscellenous)" & _
> '" WHERE(tblHeader.HID = tblTimeSheet.HID and
> tblHeader.HID=tblMiscellenous.HID) " & _
> '" and ('" & to_date & "' between
> [tblHeader].[start_weekend] and [tblHeader].[end_weekend])" & _
> '" and tblHeader.initial = '" & ini & "'" & _
> '" GROUP BY [tblHeader].[start_Weekend]")

SELECT CASE is OK, but it seems you have an error with to_date. It's
not quoted in the SQL string.

I would suggest that it is better to use a parameterized query instead,
because then you don't have to bother about nested quotes, and the
embedded SQL code becomes cleaner.

I'm only an occassional ADO programmer, so this syntax may not be
entirely correct, but would do something like:

Dim cmd AS new ADODB.Command
cmd.CommandText = _
" SELECT CASE DateDiff('d', h.[start_Weekend], ?)" & _
" WHEN 0 THEN SUM(ts.[sat]) + ? " & _
" WHEN 1 THEN SUM(ts.[sun]) + ? " & _
" WHEN 2 THEN SUM(ts.[mon]) + ? " & _
" WHEN 3 THEN SUM(ts.[tue]) + ? " & _
" WHEN 4 THEN SUM(ts.[wed]) + ? " & _
" WHEN 5 THEN SUM(ts.[thu]) + ? " & _
" WHEN 6 THEN SUM(ts.[fre]) + ? " &_
" ELSE 0 " & _
" END as HrsUsed" & _
" FROM tblHeader h, tblTimeSheet ts, tblMiscellenous m " & _
" WHERE h.HID = ts.HID " & _
" AND h.HID = m.HID " & _
" AND ? between th.[start_weekend] AND th.[end_weekend] " & _
" AND h.initial = ? " & _
" GROUP BY h.[start_Weekend]"
cmd.Parameters.Append cmd.CreateParameter(, adDateTime,,, to_date)
cmd.Parameters.Append cmd.CreateParameter(, adInteger,,, & _
sum[tblMiscellenous].[sat])
...
cmd.Parameters.Append cmd.CreateParameter(, adDateTime,,, to_date)
cmd.Parameters.Append cmd.CreateParameter(, adChar,, 1, ini)
rs.Open(cmd)

In the SQL I have also introduced aliases to make it less verbose.

I should add that the query looks a little funny, but since I don't
what result you are looking for, I cannot tell whether it returns
the desired result or not.

--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||Erland Sommarskog,

That's so cool. Thank you so much.... ^_^

Nuno