Couldn't start sqlagent service

I found the sqlagent stopped, I try to start it from
service window, it return a message: couldn't start
sqlagent$instance on local computer, the service didn't
return a error, this could by a internal windows error or
internal service error. The sqlagent use domain admin
account, and when I use my local EM, I can open the node,
database. But when I use terminal service to login in to
that server, then I can't use the server's EM to connect
that instance. The message said: a connection can't be
established. Reason: SQL server doesn't exist or access
denied. Can anyone give me a hint? Thanks in advance.
HarryWe had similar problem when the registry of a machine was messed up with a
restore of a drive image. Your problem sounds also like a registry or
Advanced Directory problem. Check with your sysadmin.
Quentin
"Harry Guo" <anonymous@.discussions.microsoft.com> wrote in message
news:2d79c01c46a75$98d28d70$a401280a@.phx
.gbl...
> I found the sqlagent stopped, I try to start it from
> service window, it return a message: couldn't start
> sqlagent$instance on local computer, the service didn't
> return a error, this could by a internal windows error or
> internal service error. The sqlagent use domain admin
> account, and when I use my local EM, I can open the node,
> database. But when I use terminal service to login in to
> that server, then I can't use the server's EM to connect
> that instance. The message said: a connection can't be
> established. Reason: SQL server doesn't exist or access
> denied. Can anyone give me a hint? Thanks in advance.
> Harrysql

Couldn't start sqlagent service

I found the sqlagent stopped, I try to start it from
service window, it return a message: couldn't start
sqlagent$instance on local computer, the service didn't
return a error, this could by a internal windows error or
internal service error. The sqlagent use domain admin
account, and when I use my local EM, I can open the node,
database. But when I use terminal service to login in to
that server, then I can't use the server's EM to connect
that instance. The message said: a connection can't be
established. Reason: SQL server doesn't exist or access
denied. Can anyone give me a hint? Thanks in advance.
HarryWe had similar problem when the registry of a machine was messed up with a
restore of a drive image. Your problem sounds also like a registry or
Advanced Directory problem. Check with your sysadmin.
Quentin
"Harry Guo" <anonymous@.discussions.microsoft.com> wrote in message
news:2d79c01c46a75$98d28d70$a401280a@.phx.gbl...
> I found the sqlagent stopped, I try to start it from
> service window, it return a message: couldn't start
> sqlagent$instance on local computer, the service didn't
> return a error, this could by a internal windows error or
> internal service error. The sqlagent use domain admin
> account, and when I use my local EM, I can open the node,
> database. But when I use terminal service to login in to
> that server, then I can't use the server's EM to connect
> that instance. The message said: a connection can't be
> established. Reason: SQL server doesn't exist or access
> denied. Can anyone give me a hint? Thanks in advance.
> Harry

Couldn't start sqlagent service

I found the sqlagent stopped, I try to start it from
service window, it return a message: couldn't start
sqlagent$instance on local computer, the service didn't
return a error, this could by a internal windows error or
internal service error. The sqlagent use domain admin
account, and when I use my local EM, I can open the node,
database. But when I use terminal service to login in to
that server, then I can't use the server's EM to connect
that instance. The message said: a connection can't be
established. Reason: SQL server doesn't exist or access
denied. Can anyone give me a hint? Thanks in advance.
Harry
We had similar problem when the registry of a machine was messed up with a
restore of a drive image. Your problem sounds also like a registry or
Advanced Directory problem. Check with your sysadmin.
Quentin
"Harry Guo" <anonymous@.discussions.microsoft.com> wrote in message
news:2d79c01c46a75$98d28d70$a401280a@.phx.gbl...
> I found the sqlagent stopped, I try to start it from
> service window, it return a message: couldn't start
> sqlagent$instance on local computer, the service didn't
> return a error, this could by a internal windows error or
> internal service error. The sqlagent use domain admin
> account, and when I use my local EM, I can open the node,
> database. But when I use terminal service to login in to
> that server, then I can't use the server's EM to connect
> that instance. The message said: a connection can't be
> established. Reason: SQL server doesn't exist or access
> denied. Can anyone give me a hint? Thanks in advance.
> Harry

couldn't see some of the database in the object explorer window of Management Studio

hey guys,
I have one question. But it is not related with the Reporting Service. I got my computer set up with SQL Server 2005 version yesterday. When I connect to the database engine, I can see only system databases(master,model,msdb and tempdb) under the system database folder. I couldn't see other databases(like pubs,northwind) in the object explorer window of Management Studio. Do you have any idea how to solve this difficulty?

Thanks.

Amde

Hi,

no problem there. These databases aren′t installed by default. There are scripts to build up the database from scratch:

http://www.microsoft.com/downloads/details.aspx?FamilyID=06616212-0356-46A0-8DA2-EEBC53A68034&displaylang=en

Or you use the Adventureworks sample database:

http://www.microsoft.com/downloads/details.aspx?FamilyID=e719ecf7-9f46-4312-af89-6ad8702e4e6e&DisplayLang=en

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||

Thanks a lot. I will work on that.

Amde

Couldn't see some databases in the object explorer window of Mangement Studio

hey guys,
I have one question. But it is not related with the Reporting Service. I got my computer set up with SQL Server 2005 version yesterday. When I connect to the database engine, I can see only system databases(master,model,msdb and tempdb) under the system database folder. I couldn't see other databases(like pubs,northwind) in the object explorer window of Management Studio. Do you have any idea how to solve this difficulty?

Thanks.

Amde

Pubs and northwind are no longer installed by default.|||

How about the other databases like Adventurework db? If you have some idea how to configure the database engine, please let me know.

I appreciate your response.

Amde

|||

Adventureworks is not installed by default either. Your questions are more appropriately suited for the "SQL Server Tools General" forum. http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=84&SiteID=1.

An easy test is to simply create a new database, refresh the object explorer, and you should see it there.

I am not certain what the best way to install the sample databases is post-installation. You should ask that question either in the tools forum or the setup forum (http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=95&SiteID=1).

|||

Thank you for your advise. I will post this question on the appropriate form discussion board.

|||

Hi, Amde --

This content will be available in the next version of BOL --

Before you can use SQL Server 2005 samples, you must install them. Installing the samples is a two-step process. Samples are not installed by default and SQL Server Setup does not run the sample installation program for you. First, when running setup, on the Features Component page, select Samples. This will copy the samples installation program to your computer during setup. Second, to run the samples installation program, point to the Start menu, point to All Programs, point to Microsoft SQL Server 2005, point to Documentation and Samples, point to Samples, and click Microsoft SQL Server 2005 Samples. To get the most recent samples, uninstall your current samples, and download and install the latest SQL Server 2005 samples from the Microsoft download Web site. To uninstall the current version of samples, point to the Start menu, point to Control Panel, and click Add or Remove Programs. Click Microsoft SQL Server 2005 Samples, and then click Remove. To find the most current samples, search http://www.microsoft.com/downloads/ for “SQL Server 2005 Samples and Sample Databases”. Choose the edition that matches your Reporting Services installation.

-- Mary

Couldn't see some databases in the object explorer window of Mangement Studio

hey guys,
I have one question. But it is not related with the Reporting Service. I got my computer set up with SQL Server 2005 version yesterday. When I connect to the database engine, I can see only system databases(master,model,msdb and tempdb) under the system database folder. I couldn't see other databases(like pubs,northwind) in the object explorer window of Management Studio. Do you have any idea how to solve this difficulty?

Thanks.

Amde

Pubs and northwind are no longer installed by default.|||

How about the other databases like Adventurework db? If you have some idea how to configure the database engine, please let me know.

I appreciate your response.

Amde

|||

Adventureworks is not installed by default either. Your questions are more appropriately suited for the "SQL Server Tools General" forum. http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=84&SiteID=1.

An easy test is to simply create a new database, refresh the object explorer, and you should see it there.

I am not certain what the best way to install the sample databases is post-installation. You should ask that question either in the tools forum or the setup forum (http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=95&SiteID=1).

|||

Thank you for your advise. I will post this question on the appropriate form discussion board.

|||

Hi, Amde --

This content will be available in the next version of BOL --

Before you can use SQL Server 2005 samples, you must install them. Installing the samples is a two-step process. Samples are not installed by default and SQL Server Setup does not run the sample installation program for you. First, when running setup, on the Features Component page, select Samples. This will copy the samples installation program to your computer during setup. Second, to run the samples installation program, point to the Start menu, point to All Programs, point to Microsoft SQL Server 2005, point to Documentation and Samples, point to Samples, and click Microsoft SQL Server 2005 Samples. To get the most recent samples, uninstall your current samples, and download and install the latest SQL Server 2005 samples from the Microsoft download Web site. To uninstall the current version of samples, point to the Start menu, point to Control Panel, and click Add or Remove Programs. Click Microsoft SQL Server 2005 Samples, and then click Remove. To find the most current samples, search http://www.microsoft.com/downloads/ for “SQL Server 2005 Samples and Sample Databases”. Choose the edition that matches your Reporting Services installation.

-- Mary

sql

Could not start the SQL Server Reporting Services (REPORTS) service on local computer.

Error 1069. The service did not start due to login failure.

I can't get a domain login account with domain admin rights to start the service. The only way I can start the service is with the LocalSystem account, which isn't a good solution because it's not networkable.

Thank you for any advice you have.

Does your domain account has "Log on as a service" right?|||Yes. My domain account has it in Active Directory and on the server under Local Security Policy.|||Interesting ... can you run any other service with your domain account? Is this problem specific to RS service?|||I just tested stopping and starting another service with the same domain account and it ran that service successfully. It appears that the problem is just related to SQL Server Reporting Services.|||Perhaps the password changed and your RS service still has the old password? Sorry I can't think of anything else.|||

How do I know what password the RS Service has or should be? I know the password hasn't changed for our domain account. I verified it works for other services.

Here is more information:

I have two servers:

One database server: SQL Server 2005 SP1

One web server with IIS running multiple websites with ASP 1.1 and ASP 2.0 and SQL Server 2005 Reporting Services. I configured Reporting Services from my web server where my SQL Server Reporting Services account is that won't login as a domain administrator account with administrator rights and log on as a service rights.

Is there some other type of rights that may be missing related to SQL Server Reporting services?

|||Also, I found that the WebServiceAccount was not set in the RSreportserver.config file in Program Fiels\Microsoft SQL Servre\MSSQL.1\Reporting Services\ReportManager so I set it to IWAM_ComputerName with the ComputerName as the name of my computer. Then I tried restarted the Reporting Services service, but it didn't start. I also can't get the ASP.NET service to start. I tried to start it using the IWAM_ComputerName account, but I need to figure out what the password is for that account to start the service.|||

rsreportserver.config file should be in ...\MSSQL.1\Reporting Services\ReportServer directory. To set web service account, please use the configuration tool. Setting it to IWAM_ account is incorrect. On XP/Win2K, the web service account is by default <MachineName>\ASPNET. On Win2K3 it is the app pool identity of your report server virtual directory.

When you say you can't get ASP.NET to start, what did you try? You shouldn't do anything. The ASP.NET worker process should start when the first request is received.

|||

The configuration tool doesn't grab the ASP.NET account web service. It won't pick it up or let me type it in. The service is listed in Services, but wasn't started. The only way it would start was with a login of LocalSystem.

In another website, http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=17756&SiteID=1, a Microsoft Lead Reporting Services person, Tudor Trufinescu, recommended added the Web Service Account if it was missing in the config file.

I'll remove it though.

The article also said that if I'm using IIS 5, which I assume I'm using since I have Windows 2000 Advanced Server, that the ASP.NET account should login using MACHINE\ASPNET account. This never worked. I had to change it to the LocalSystem login to work. I thought this problem may be related to the Reporting Services problem since it's an option in the Configuration Tools that isn't configured.

Thank you.

|||

The configuration tool should pick up ASP.NET account from machine.config file. It will not let you type in if you are on IIS5. Are you seeing blank "ASP.NET service account" box?

I am still confused when you talk about "starting the service". Which service is this? (What is the name of the service in service controller manager?) RS has a windows service that is named "SQL Server Reporting Services". On IIS side, you don't control ASP.NET worker process identity since you are on Win2K/IIS5.

|||

Yes. I am seeing a blank ASP.NET service account box.

The two services I was referencing were:

SQL Server Rerporting Service - will only start with a logon of LocalSystem account - not a good solution because I need to use a domain account that will login across the network into a database.

ASPNET service - will only start with the LocalSystem account. I just mentioned this to note it. Wasn't sure if it also needed to start using some other type of login.

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_A
uthenticationExtension()
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://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.Reportin
gServices.Diagnostics.Utilities.ErrorStrings&EvtID=rsServerConfigurationErro
r& ProdName=Microsoft%20SQL%20Server%20Repo
rting%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_AuthenticateReque
st(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: 8p
t;
> 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:#FF330
0;
> 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.Report
ingServices.Diagnostics.Utilities.ErrorStrings&EvtID=rsServerConfigurationEr
ror& ProdName=Microsoft%20SQL%20Server%20Repo
rting%20Services&ProdVer=9.00.13
99.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_AuthenticateReque
st(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: 8p
t;
> 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:#FF330
0;
> 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.Report
ingServices.Diagnostics.Utilities.ErrorStrings&EvtID=rsServerConfigurationEr
ror& ProdName=Microsoft%20SQL%20Server%20Repo
rting%20Services&ProdVer=9.00.13
99.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 Pane
l
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.sql

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 not start the MSSQLServer Service on local computer. Error: 1068: the dependency ser

We installed SQL Server 2000 on a Win2000 server (call it serverA). This
Win2000 server used to be a member server of a Domain Controller (call it
serverDC with domain name DCName). We had a problem with that Domain
Controller today, so we took out serverA from the domain controller. Now, we
cannot start the SQL Server Service Manager. It gave us an error that says
"Dependency service or group failed to start. Error 1068 (Dependency service
or group failed to start) occured while performing this service operation on
the MSSQLServer Service.".
When I tried to srtart the MSSQLServer Service, it gave me an error "Could
not start the MSSQLServer Service on local computer. Error: 1068: the
dependency service or group failed to start". When I clicked on the tab
"Dependencies", there is no dependency for this service.
On the "Log On" tab of MSSQLServer Service, the user name used to say
"DCName\Administrator", and after we took out serverA from the domain
controller, we changed the user name to "\Administrator".
How can I fix this problem ? Thank you.Try changing the services (SQL Server, SQL Agent, etc) to
run under Local System - from the Log On tab of the service.
You wouldn't necessarily want to keep it set to this but you
can see if it's starts up with the services running under
local system.
-Sue
On Tue, 7 Sep 2004 14:49:06 -0500, "Fie Fie Niles"
<fniles@.wincitesystems.com> wrote:
>We installed SQL Server 2000 on a Win2000 server (call it serverA). This
>Win2000 server used to be a member server of a Domain Controller (call it
>serverDC with domain name DCName). We had a problem with that Domain
>Controller today, so we took out serverA from the domain controller. Now, we
>cannot start the SQL Server Service Manager. It gave us an error that says
>"Dependency service or group failed to start. Error 1068 (Dependency service
>or group failed to start) occured while performing this service operation on
>the MSSQLServer Service.".
>When I tried to srtart the MSSQLServer Service, it gave me an error "Could
>not start the MSSQLServer Service on local computer. Error: 1068: the
>dependency service or group failed to start". When I clicked on the tab
>"Dependencies", there is no dependency for this service.
>On the "Log On" tab of MSSQLServer Service, the user name used to say
>"DCName\Administrator", and after we took out serverA from the domain
>controller, we changed the user name to "\Administrator".
>How can I fix this problem ? Thank you.
>

could not start the database engine service in Sql Server 2005

Dear All,

I am not able to start the sql server 2005 database engine services...

Sql server 2005 server is installed in one machine(SERVER) and we have 10 client machine connecting to the server

When i try to start the service from the Service.msc in the SERVER i am getting the following error

===================================

Cannot connect to KEYSKILL.

===================================

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (.Net SqlClient Data Provider)

Error Number: 2
Severity: 20
State: 0

Program Location:

at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject)
at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject)
at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart)
at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.ValidateConnection(UIConnectionInfo ci, IServerType server)
at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()

Could any one help me to resolve the error

Thanks in Advance

Lalitha

Look in the Windows event log, there might be a hardware failure which is described in the event log. If you are not sure what to do with the log, send them over for investigation.

Jens K. Suessmeyer.

http://www.sqlserver2005.de
|||Could you post Errorlog & Event log information which will provide more info to sort out the problem.|||

HI Vidya,

This is the ERROR LOG information

2007-07-17 10:28:38.56 Server Microsoft SQL Server 2005 - 9.00.1406.00 (Intel X86)
Mar 3 2007 18:40:02
Copyright (c) 1988-2005 Microsoft Corporation
Developer Edition on Windows NT 5.2 (Build 3790: Service Pack 1)

2007-07-17 10:28:38.56 Server (c) 2005 Microsoft Corporation.
2007-07-17 10:28:38.56 Server All rights reserved.
2007-07-17 10:28:38.56 Server Server process ID is 3332.
2007-07-17 10:28:38.56 Server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG'.
2007-07-17 10:28:38.56 Server This instance of SQL Server last reported using a process ID of 6000 at 7/17/2007 10:28:33 AM (local) 7/17/2007 4:58:33 AM (UTC). This is an informational message only; no user action is required.
2007-07-17 10:28:38.56 Server Registry startup parameters:
2007-07-17 10:28:38.56 Server -d C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf
2007-07-17 10:28:38.56 Server -e C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG
2007-07-17 10:28:38.56 Server -l C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf
2007-07-17 10:28:38.57 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2007-07-17 10:28:38.57 Server Detected 2 CPUs. This is an informational message; no user action is required.
2007-07-17 10:28:38.75 Server Using dynamic lock allocation. Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node. This is an informational message only. No user action is required.
2007-07-17 10:28:38.76 Server Attempting to initialize Microsoft Distributed Transaction Coordinator (MS DTC). This is an informational message only. No user action is required.
2007-07-17 10:28:39.79 Server Attempting to recover in-doubt distributed transactions involving Microsoft Distributed Transaction Coordinator (MS DTC). This is an informational message only. No user action is required.
2007-07-17 10:28:39.79 Server Database Mirroring Transport is disabled in the endpoint configuration.
2007-07-17 10:28:39.81 spid5s Starting up database 'master'.
2007-07-17 10:28:39.93 spid5s SQL Trace ID 1 was started by login "sa".
2007-07-17 10:28:39.95 spid5s Starting up database 'mssqlsystemresource'.
2007-07-17 10:28:39.98 spid5s Error: 17207, Severity: 16, State: 1.
2007-07-17 10:28:39.98 spid5s FCB:pen: Operating system error 21(The device is not ready.) occurred while creating or opening file 'E:\sql\MSSQL.1\MSSQL\DATA\mssqlsystemresource.mdf'. Diagnose and correct the operating system error, and retry the operation.
2007-07-17 10:28:39.98 spid5s Error: 17204, Severity: 16, State: 1.
2007-07-17 10:28:39.98 spid5s FCB:pen failed: Could not open file E:\sql\MSSQL.1\MSSQL\DATA\mssqlsystemresource.mdf for file number 1. OS error: 21(The device is not ready.).
2007-07-17 10:28:39.98 spid5s Error: 5120, Severity: 16, State: 101.
2007-07-17 10:28:39.98 spid5s Unable to open the physical file "E:\sql\MSSQL.1\MSSQL\DATA\mssqlsystemresource.mdf". Operating system error 21: "21(The device is not ready.)".
2007-07-17 10:28:40.00 spid5s Error: 17207, Severity: 16, State: 1.
2007-07-17 10:28:40.00 spid5s FileMgr:tartLogFiles: Operating system error 2(The system cannot find the file specified.) occurred while creating or opening file 'E:\sql\MSSQL.1\MSSQL\DATA\mssqlsystemresource.ldf'. Diagnose and correct the operating system error, and retry the operation.
2007-07-17 10:28:40.00 spid5s File activation failure. The physical file name "E:\sql\MSSQL.1\MSSQL\DATA\mssqlsystemresource.ldf" may be incorrect.
2007-07-17 10:28:40.00 spid5s Error: 945, Severity: 14, State: 2.
2007-07-17 10:28:40.00 spid5s Database 'mssqlsystemresource' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details.
2007-07-17 10:28:40.00 spid5s SQL Trace was stopped due to server shutdown. Trace ID = '1'. This is an informational message only; no user action is required.

and i didnt find the event log file....

could u please tell me the path...

Regards

Lalitha

|||

Examine the location

E:\sql\MSSQL.1\MSSQL\DATA\mssqlsystemresource.*"

Does the file exist ?
Does the service account have the appropiate permissions to access it ?
Does the directory exists ?
is the directory on a shared network drive ?

Jens K. Suessmeyer

http://www.sqlserver2005.de

Could not start the ASP.NET service on local computer.

Error 1069. The service did not start due to login failure.

I can't get a domain login account with domain admin rights to start the service. The only way I can start the service is with the LocalSystem account, which isn't a good solution because it's not networkable.

Thank you for any advice you have.

Does your domain account has "Log on as a service" right?|||Yes. My domain account has it in Active Directory and on the server under Local Security Policy.|||Interesting ... can you run any other service with your domain account? Is this problem specific to RS service?|||I just tested stopping and starting another service with the same domain account and it ran that service successfully. It appears that the problem is just related to SQL Server Reporting Services.|||Perhaps the password changed and your RS service still has the old password? Sorry I can't think of anything else.|||

How do I know what password the RS Service has or should be? I know the password hasn't changed for our domain account. I verified it works for other services.

Here is more information:

I have two servers:

One database server: SQL Server 2005 SP1

One web server with IIS running multiple websites with ASP 1.1 and ASP 2.0 and SQL Server 2005 Reporting Services. I configured Reporting Services from my web server where my SQL Server Reporting Services account is that won't login as a domain administrator account with administrator rights and log on as a service rights.

Is there some other type of rights that may be missing related to SQL Server Reporting services?

|||Also, I found that the WebServiceAccount was not set in the RSreportserver.config file in Program Fiels\Microsoft SQL Servre\MSSQL.1\Reporting Services\ReportManager so I set it to IWAM_ComputerName with the ComputerName as the name of my computer. Then I tried restarted the Reporting Services service, but it didn't start. I also can't get the ASP.NET service to start. I tried to start it using the IWAM_ComputerName account, but I need to figure out what the password is for that account to start the service.|||

rsreportserver.config file should be in ...\MSSQL.1\Reporting Services\ReportServer directory. To set web service account, please use the configuration tool. Setting it to IWAM_ account is incorrect. On XP/Win2K, the web service account is by default <MachineName>\ASPNET. On Win2K3 it is the app pool identity of your report server virtual directory.

When you say you can't get ASP.NET to start, what did you try? You shouldn't do anything. The ASP.NET worker process should start when the first request is received.

|||

The configuration tool doesn't grab the ASP.NET account web service. It won't pick it up or let me type it in. The service is listed in Services, but wasn't started. The only way it would start was with a login of LocalSystem.

In another website, http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=17756&SiteID=1, a Microsoft Lead Reporting Services person, Tudor Trufinescu, recommended added the Web Service Account if it was missing in the config file.

I'll remove it though.

The article also said that if I'm using IIS 5, which I assume I'm using since I have Windows 2000 Advanced Server, that the ASP.NET account should login using MACHINE\ASPNET account. This never worked. I had to change it to the LocalSystem login to work. I thought this problem may be related to the Reporting Services problem since it's an option in the Configuration Tools that isn't configured.

Thank you.

|||

The configuration tool should pick up ASP.NET account from machine.config file. It will not let you type in if you are on IIS5. Are you seeing blank "ASP.NET service account" box?

I am still confused when you talk about "starting the service". Which service is this? (What is the name of the service in service controller manager?) RS has a windows service that is named "SQL Server Reporting Services". On IIS side, you don't control ASP.NET worker process identity since you are on Win2K/IIS5.

|||

Yes. I am seeing a blank ASP.NET service account box.

The two services I was referencing were:

SQL Server Rerporting Service - will only start with a logon of LocalSystem account - not a good solution because I need to use a domain account that will login across the network into a database.

ASPNET service - will only start with the LocalSystem account. I just mentioned this to note it. Wasn't sure if it also needed to start using some other type of login.

sql

Could not start the ASP.NET service on local computer.

Error 1069. The service did not start due to login failure.

I can't get a domain login account with domain admin rights to start the service. The only way I can start the service is with the LocalSystem account, which isn't a good solution because it's not networkable.

Thank you for any advice you have.

Does your domain account has "Log on as a service" right?|||Yes. My domain account has it in Active Directory and on the server under Local Security Policy.|||Interesting ... can you run any other service with your domain account? Is this problem specific to RS service?|||I just tested stopping and starting another service with the same domain account and it ran that service successfully. It appears that the problem is just related to SQL Server Reporting Services.|||Perhaps the password changed and your RS service still has the old password? Sorry I can't think of anything else.|||

How do I know what password the RS Service has or should be? I know the password hasn't changed for our domain account. I verified it works for other services.

Here is more information:

I have two servers:

One database server: SQL Server 2005 SP1

One web server with IIS running multiple websites with ASP 1.1 and ASP 2.0 and SQL Server 2005 Reporting Services. I configured Reporting Services from my web server where my SQL Server Reporting Services account is that won't login as a domain administrator account with administrator rights and log on as a service rights.

Is there some other type of rights that may be missing related to SQL Server Reporting services?

|||Also, I found that the WebServiceAccount was not set in the RSreportserver.config file in Program Fiels\Microsoft SQL Servre\MSSQL.1\Reporting Services\ReportManager so I set it to IWAM_ComputerName with the ComputerName as the name of my computer. Then I tried restarted the Reporting Services service, but it didn't start. I also can't get the ASP.NET service to start. I tried to start it using the IWAM_ComputerName account, but I need to figure out what the password is for that account to start the service.|||

rsreportserver.config file should be in ...\MSSQL.1\Reporting Services\ReportServer directory. To set web service account, please use the configuration tool. Setting it to IWAM_ account is incorrect. On XP/Win2K, the web service account is by default <MachineName>\ASPNET. On Win2K3 it is the app pool identity of your report server virtual directory.

When you say you can't get ASP.NET to start, what did you try? You shouldn't do anything. The ASP.NET worker process should start when the first request is received.

|||

The configuration tool doesn't grab the ASP.NET account web service. It won't pick it up or let me type it in. The service is listed in Services, but wasn't started. The only way it would start was with a login of LocalSystem.

In another website, http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=17756&SiteID=1, a Microsoft Lead Reporting Services person, Tudor Trufinescu, recommended added the Web Service Account if it was missing in the config file.

I'll remove it though.

The article also said that if I'm using IIS 5, which I assume I'm using since I have Windows 2000 Advanced Server, that the ASP.NET account should login using MACHINE\ASPNET account. This never worked. I had to change it to the LocalSystem login to work. I thought this problem may be related to the Reporting Services problem since it's an option in the Configuration Tools that isn't configured.

Thank you.

|||

The configuration tool should pick up ASP.NET account from machine.config file. It will not let you type in if you are on IIS5. Are you seeing blank "ASP.NET service account" box?

I am still confused when you talk about "starting the service". Which service is this? (What is the name of the service in service controller manager?) RS has a windows service that is named "SQL Server Reporting Services". On IIS side, you don't control ASP.NET worker process identity since you are on Win2K/IIS5.

|||

Yes. I am seeing a blank ASP.NET service account box.

The two services I was referencing were:

SQL Server Rerporting Service - will only start with a logon of LocalSystem account - not a good solution because I need to use a domain account that will login across the network into a database.

ASPNET service - will only start with the LocalSystem account. I just mentioned this to note it. Wasn't sure if it also needed to start using some other type of login.

Could not start SQL Agent

Hello.
I have SQL Server MSDE running Windows 2000.
When I start SQL Agent gives me the following error:"Could not start
the SQLAgent$SPSQL service on Local Computer. The service did not
return an error..."
An
Can anyone help me?
Thanks.
ticha
Posted via http://www.webservertalk.com
View this thread: http://www.webservertalk.com/message930459.html
Hi
Look in the Windows Event Log and the Agent log file in the LOGs directory.
You may get more information there.
Regards
Mike
"ticha" wrote:

> Hello.
> I have SQL Server MSDE running Windows 2000.
> When I start SQL Agent gives me the following error:"Could not start
> the SQLAgent$SPSQL service on Local Computer. The service did not
> return an error..."
> An
> Can anyone help me?
> Thanks.
>
> --
> ticha
> Posted via http://www.webservertalk.com
> View this thread: http://www.webservertalk.com/message930459.html
>

Could not start DTS services in SQL SERVER 2005 developper edition

Hello,

I tried to use the SQL SERVER DTS on SQL SERVER 2005, but when I wan't to start the service i have the next error :

The SQL Network Interface library was unable to register SPN. Error: 0x54b.

Coul you help me please.

Thanks

DraganPlease check the following post for the answer:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=76142

Could not start DTS services in SQL SERVER 2005 developper edition

Hello,

I tried to use the SQL SERVER DTS on SQL SERVER 2005, but when I wan't to start the service i have the next error :

The SQL Network Interface library was unable to register SPN. Error: 0x54b.

Coul you help me please.

Thanks

Dragan

Please check the following post for the answer:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=76142

Could not setup Web Service Identity --> Error Code 80070003

Hello!
I′m trying to setup a Report Server on my SQL 2005 server. In Reporting Services Configuration Manager I get an error when i try to create the Web Sevice Identity

ReportServicesConfigUI.WMIProvider.WMIProviderException: An unknown error has occurred in the WMI Provider. Error Code 80070003
at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.SetWebServiceIdentity(String applicationPool)

The default website contains an office sharepoint 2007 beta solution if that could cause the error..

Would be real grateful for some hints...

Regards

Erik B

Have you found a solution to this? I'm getting the same error after moving the Identities from one Website to another.|||

8007003 is ERROR_PATH_NOT_FOUND. Are you on Win2K3? I suspect this has something to do with ASP.NET setup. Either the WMI provider could not open the ASP.NET registry keys, or it could not find the machine.config file. Make sure you have run aspnet_regiis -i -enable.

If it doesn't work, I would start using regmon and filemon to looks for suspicious errors that could lead to 8007003. Unfortunately at this point the error code is too general to provide any clue.

|||

Hi... I reinstalled SQL 2005 and then it worked fine.. However I think it had to do something with the Encryption Keys... Gwired if I were you I′d delete those from the Reporting Services Configuration Manager, create new ones and then setup a Web Service Identity.

Have a nice day

/Erk

|||

I ran into the same problem, and discovered the issue had to do with the fact that I installed SQL Server 2005, SP1, SP2 and THEN installed Reporting Services. Because I had installed SP2 before Reporting Services, SP2 was not applied to Reporting Services.

The only other thing of note that happened was that when I tried to run the User Provisioning Tool after installing SP2 I got a 'object not set to an instance of an object error'. I didn't really think anything about it at the time, but I think it was only because I figured I'd find the problem down the road. I guess you can say that I did.

Could not setup Web Service Identity --> Error Code 80070003

Hello!
I′m trying to setup a Report Server on my SQL 2005 server. In Reporting Services Configuration Manager I get an error when i try to create the Web Sevice Identity

ReportServicesConfigUI.WMIProvider.WMIProviderException: An unknown error has occurred in the WMI Provider. Error Code 80070003
at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.SetWebServiceIdentity(String applicationPool)

The default website contains an office sharepoint 2007 beta solution if that could cause the error..

Would be real grateful for some hints...

Regards

Erik B

Have you found a solution to this? I'm getting the same error after moving the Identities from one Website to another.|||

8007003 is ERROR_PATH_NOT_FOUND. Are you on Win2K3? I suspect this has something to do with ASP.NET setup. Either the WMI provider could not open the ASP.NET registry keys, or it could not find the machine.config file. Make sure you have run aspnet_regiis -i -enable.

If it doesn't work, I would start using regmon and filemon to looks for suspicious errors that could lead to 8007003. Unfortunately at this point the error code is too general to provide any clue.

|||

Hi... I reinstalled SQL 2005 and then it worked fine.. However I think it had to do something with the Encryption Keys... Gwired if I were you I′d delete those from the Reporting Services Configuration Manager, create new ones and then setup a Web Service Identity.

Have a nice day

/Erk

|||

I ran into the same problem, and discovered the issue had to do with the fact that I installed SQL Server 2005, SP1, SP2 and THEN installed Reporting Services. Because I had installed SP2 before Reporting Services, SP2 was not applied to Reporting Services.

The only other thing of note that happened was that when I tried to run the User Provisioning Tool after installing SP2 I got a 'object not set to an instance of an object error'. I didn't really think anything about it at the time, but I think it was only because I figured I'd find the problem down the road. I guess you can say that I did.

Could not Re-index !

My company has 5 SQL Servers, their configurations are : SQL Server 7.0 +
Service Pack 3.
But I could not do DBCC DBREINDEX on one of them and got the following error
:
DBCC DBREINDEX('dbo.SA_TRN_DTL', ' ', 0)
The error was :
Server: Msg 1105, Level 17, State 2, Line 1
Could not allocate space for object 'SA_TRN_DTL' in database 'rmsdb_prd'
because the
'PRIMARY' filegroup is full.
Index (ID = 1) is being rebuilt.
Index (ID = 3) is being rebuilt.
Index (ID = 4) is being rebuilt.
But I don't think the error came from insufficient hard disk space because I
could execute the same command successfully on another machine that has even
less free hard disk space.
Can anybodies help me ?
Sometimes autogrow doesn't grow fast enough. The only way I know to handle this is to pre-allocate storage.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"cpchan" <cpchaney@.netvigator.com> wrote in message news:c97flr$rtl1@.imsp212.netvigator.com...
> My company has 5 SQL Servers, their configurations are : SQL Server 7.0 +
> Service Pack 3.
> But I could not do DBCC DBREINDEX on one of them and got the following error
> :
> DBCC DBREINDEX('dbo.SA_TRN_DTL', ' ', 0)
> The error was :
> Server: Msg 1105, Level 17, State 2, Line 1
> Could not allocate space for object 'SA_TRN_DTL' in database 'rmsdb_prd'
> because the
> 'PRIMARY' filegroup is full.
> Index (ID = 1) is being rebuilt.
> Index (ID = 3) is being rebuilt.
> Index (ID = 4) is being rebuilt.
> But I don't think the error came from insufficient hard disk space because I
> could execute the same command successfully on another machine that has even
> less free hard disk space.
> Can anybodies help me ?
>
>
>

Could not Re-index !

My company has 5 SQL Servers, their configurations are : SQL Server 7.0 +
Service Pack 3.
But I could not do DBCC DBREINDEX on one of them and got the following error
:
DBCC DBREINDEX('dbo.SA_TRN_DTL', ' ', 0)
The error was :
Server: Msg 1105, Level 17, State 2, Line 1
Could not allocate space for object 'SA_TRN_DTL' in database 'rmsdb_prd'
because the
'PRIMARY' filegroup is full.
Index (ID = 1) is being rebuilt.
Index (ID = 3) is being rebuilt.
Index (ID = 4) is being rebuilt.
But I don't think the error came from insufficient hard disk space because I
could execute the same command successfully on another machine that has even
less free hard disk space.
Can anybodies help me ?
Have you checked the settings of you data / log files to see if they have
reached there max size ?
J
"cpchan" <cpchaney@.netvigator.com> wrote in message
news:c9c7sj$j5r1618@.imsp212.netvigator.com...
> My company has 5 SQL Servers, their configurations are : SQL Server 7.0 +
> Service Pack 3.
> But I could not do DBCC DBREINDEX on one of them and got the following
error
> :
> DBCC DBREINDEX('dbo.SA_TRN_DTL', ' ', 0)
> The error was :
> Server: Msg 1105, Level 17, State 2, Line 1
> Could not allocate space for object 'SA_TRN_DTL' in database 'rmsdb_prd'
> because the
> 'PRIMARY' filegroup is full.
> Index (ID = 1) is being rebuilt.
> Index (ID = 3) is being rebuilt.
> Index (ID = 4) is being rebuilt.
> But I don't think the error came from insufficient hard disk space because
I
> could execute the same command successfully on another machine that has
even
> less free hard disk space.
> Can anybodies help me ?
>