can't start SQL Server Analysis Services

Hi I am using SQL 2005 but when I go to the SQL Server Configuration manager
and try to start the SQL Server Analysis Services, I get the error message
Requiest failed or the service did not respond in a timely fashion.
In the event log it looks like there was a problem with login,
The SQL Server Analysis Services (MSSQLSERVER) service failed to start due
to the following error:
The service did not start due to a logon failure.
I currently have the logon as domain\username. Anyhow just wondering how to
fix this?
thanks Paul.
--
Paul G
Software engineer.got it working, for some reason the password was not set correctly, so just
used the properties box to correct it.
--
Paul G
Software engineer.
"Paul" wrote:
> Hi I am using SQL 2005 but when I go to the SQL Server Configuration manager
> and try to start the SQL Server Analysis Services, I get the error message
> Requiest failed or the service did not respond in a timely fashion.
> In the event log it looks like there was a problem with login,
> The SQL Server Analysis Services (MSSQLSERVER) service failed to start due
> to the following error:
> The service did not start due to a logon failure.
> I currently have the logon as domain\username. Anyhow just wondering how to
> fix this?
> thanks Paul.
> --
> Paul G
> Software engineer.sql

can't start SQL Server Analysis Services

Hi I am using SQL 2005 but when I go to the SQL Server Configuration manager
and try to start the SQL Server Analysis Services, I get the error message
Requiest failed or the service did not respond in a timely fashion.
In the event log it looks like there was a problem with login,
The SQL Server Analysis Services (MSSQLSERVER) service failed to start due
to the following error:
The service did not start due to a logon failure.
I currently have the logon as domain\username. Anyhow just wondering how to
fix this?
thanks Paul.
Paul G
Software engineer.
got it working, for some reason the password was not set correctly, so just
used the properties box to correct it.
Paul G
Software engineer.
"Paul" wrote:

> Hi I am using SQL 2005 but when I go to the SQL Server Configuration manager
> and try to start the SQL Server Analysis Services, I get the error message
> Requiest failed or the service did not respond in a timely fashion.
> In the event log it looks like there was a problem with login,
> The SQL Server Analysis Services (MSSQLSERVER) service failed to start due
> to the following error:
> The service did not start due to a logon failure.
> I currently have the logon as domain\username. Anyhow just wondering how to
> fix this?
> thanks Paul.
> --
> Paul G
> Software engineer.

can't start SQL Server Analysis Services

Hi I am using SQL 2005 but when I go to the SQL Server Configuration manager
and try to start the SQL Server Analysis Services, I get the error message
Requiest failed or the service did not respond in a timely fashion.
In the event log it looks like there was a problem with login,
The SQL Server Analysis Services (MSSQLSERVER) service failed to start due
to the following error:
The service did not start due to a logon failure.
I currently have the logon as domain\username. Anyhow just wondering how to
fix this?
thanks Paul.
--
Paul G
Software engineer.got it working, for some reason the password was not set correctly, so just
used the properties box to correct it.
--
Paul G
Software engineer.
"Paul" wrote:

> Hi I am using SQL 2005 but when I go to the SQL Server Configuration manag
er
> and try to start the SQL Server Analysis Services, I get the error message
> Requiest failed or the service did not respond in a timely fashion.
> In the event log it looks like there was a problem with login,
> The SQL Server Analysis Services (MSSQLSERVER) service failed to start due
> to the following error:
> The service did not start due to a logon failure.
> I currently have the logon as domain\username. Anyhow just wondering how
to
> fix this?
> thanks Paul.
> --
> Paul G
> Software engineer.

Can't start RS2005

Hi,
I am new and just installed SS2005 Developer Edition on a server.
I can see the following services on Configuration Manager -> Services
Integration Services - Running
FullText Search - Running
SQL Server - Running
Analysis Service - Running
Reporting Service - Stopped
Browser - Running
Agent - Running
I tried to start RS, it ends up with error:
The request failed or the service did not respond in a timely fashion.
Consult the event log or other applicable error logs for details.
Checked the event log:
- The Remote Procedure Call (RPC) service failed to start
- Service cannot be started.
Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException:
=E7=84=A1=E6=B3=95=E8=BE=A8=E8=AD=98=E4=BD=BF=E7=94=A8=E8=80=85=E6=88=96=E7= =BE=A4=E7=B5=84=E5=90=8D=E7=A8=B1 'TPEW2KDM\ASPNET'=E3=80=82
at Microsoft.ReportingServices.Library.Native.NameToSid(String name)
at
Microsoft.ReportingServices.Library.ServiceAppDomainController.StartRPCServ= er(Boolean
firstTime)
at
Microsoft.ReportingServices.Library.ServiceAppDomainController.Start(Boolean
firstTime)
at
Microsoft.ReportingServices.NTService.ReportService.OnStart(String[]
args)
at
System.ServiceProcess.ServiceBase.ServiceQueuedMainCallback(Object
state)
- The report server database is an invalid version.
I am wondering why reporting service is the only service that's not
running.
Any comments are highly appreciated.Still waiting for advice anyone? tks|||did you find a solution to this problem ?
From http://www.developmentnow.com/g/115_2006_1_0_0_679705/Cant-start-RS2005.ht
Posted via DevelopmentNow.com Group
http://www.developmentnow.com

Cant start report server

Hey all. I'm using SQL server Express and I've installed the Report service. When I go into the reporting services configuration manager and I want to start the service, the system won't let me. Here is the error

System.ServiceProcess.TimeoutException: Time out has expired and the operation has not been completed.
at System.ServiceProcess.ServiceController.WaitForStatus(ServiceControllerStatus desiredStatus, TimeSpan timeout)
at ReportServicesConfigUI.Panels.ServerInformationPanel.StartStopServiceTask(Boolean start)

I just can't seem to be able to start the service.

Can you plz help?

Thanks

Hi,

Based on my understanding, this error message is caused by the permission issue. You should take a look at the Report Server logs, and make sure you are configuring locally and you are administrator on the machine. And re-modify your reporting service configuration in the following way:

1. Created ReportService database using Report Service Configuration
2. Edited your personal account to Web Service Account in rsreportserver.config
3. Used rsconfig utility to encrypt the connection and account information
4. Edited your personal account to <processModel userName=" " >

If the problem still exists, you should try the following methods.

Set the Report Server Web service and Report Manager to use the same application pool.

|||

Thank you for your answer. But how can I create a reportservice database if I can't connect to the service?

++ Where do I go to

Set the Report Server Web service and Report Manager to use the same application pool.

Add the security account to the SQLServer2005ReportingServicesWebServiceUser$InstanceName group that you use for the application pool identity.

|||

Hi,

Set the Report Server Web service and Report Manager to use the same application pool.

Add the security account to the SQLServer2005ReportingServicesWebServiceUser$InstanceName group that you use for the application pool identity.

can't start mssqlserver

I installed a copy of SQL server 2005 on a Win 2003 machine. I connected remotely from another machine and started Sql Server Configuration manager. The MSSQLServer is stopped. So, I click to start and it failed. The error it gave me was that it time out. I am new to SQL 2005 and I thought the next step after installing was to configure. Can anyone help me please.

Check in the SQL Server log file for any info. If SQL received the startup request, the log will show why the timeout occurred. Presumably there was a configuration problem that caused startup to fail.

Also check the network configuration. I believe local connections require shared memory to be enabled.

|||Hi, in addition to the aother post, try to make a snapshot of your event log if you can't figure out the problem and send the appropiate parts (like starting the service which breaks) to this forum again.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

Can''t install Reporting Services on Vista x64

When I try to install Reporting Services on my Vista x64 machine, the following happens:
Firstly, the System Configuration Check shows a "ASP.Net Version Registration Requirement" warning. Clicking on the error message gives the extra details "Failed to find the ASP.Net Version Registration with Microsoft Internet Information Services (IIS)."On the next section, Reporting Services is greyed out and so I can't attempt to install it.I have seen many other posts on this topic, and all seem to suggest that various IIS7 features need to be enabled in the "Turn Windows Features On or Off" section. I have already tried this, and in fact now have every possible IIS7 feature turned on. No change though.

I have also installed SQL 2005 SP2. But again going back to the install disk to add Reporting Services led to the same story.

So I'm pretty much completely stuck. Can anyone help?

Hi Fagster,

It seems that these workarounds worked for other people. Could you try it, please, and let me know how is working?

For install 32 bit Reporting Services on Vista run this script before the Reporting Services installation:

cscript %SystemDrive%\inetpub\AdminScripts\adsutil.vbs set w3svc/AppPools/Enable32bitAppOnWin64 1

For install 64 bit Reporting Services on Vista run this script before the Reporting Services installation:

cscript %SystemDrive%\inetpub\AdminScripts\adsutil.vbs set w3svc/AppPools/Enable32bitAppOnWin64 0

Mihaela

|||This did indeed work. I managed to post this twice so I may well be the "other people".

Thanks anyway.

RichardF
|||Worked for me to after spending a lot of time trying to get around this problem - Woo Hoo - Thanks|||

I get the error:

Input Error: Can not find script file "C:\inetpub\AdminScripts\adsutil.vbs"

When I run this script, anyone help?

|||

Turn UAC off: http://windowshelp.microsoft.com/Windows/en-US/Help/58b3b879-924d-4e08-9358-c316055d3eae1033.mspx

Follow this KB: http://support.microsoft.com/default.aspx/kb/934164

I now have SSRS on Windows Vista Ultimate. Woohhoo.

Can't install Reporting Services on Vista x64

When I try to install Reporting Services on my Vista x64 machine, the following happens:
Firstly, the System Configuration Check shows a "ASP.Net Version Registration Requirement" warning. Clicking on the error message gives the extra details "Failed to find the ASP.Net Version Registration with Microsoft Internet Information Services (IIS)."On the next section, Reporting Services is greyed out and so I can't attempt to install it.I have seen many other posts on this topic, and all seem to suggest that various IIS7 features need to be enabled in the "Turn Windows Features On or Off" section. I have already tried this, and in fact now have every possible IIS7 feature turned on. No change though.

I have also installed SQL 2005 SP2. But again going back to the install disk to add Reporting Services led to the same story.

So I'm pretty much completely stuck. Can anyone help?

Hi Fagster,

It seems that these workarounds worked for other people. Could you try it, please, and let me know how is working?

For install 32 bit Reporting Services on Vista run this script before the Reporting Services installation:

cscript %SystemDrive%\inetpub\AdminScripts\adsutil.vbs set w3svc/AppPools/Enable32bitAppOnWin64 1

For install 64 bit Reporting Services on Vista run this script before the Reporting Services installation:

cscript %SystemDrive%\inetpub\AdminScripts\adsutil.vbs set w3svc/AppPools/Enable32bitAppOnWin64 0

Mihaela

|||This did indeed work. I managed to post this twice so I may well be the "other people".

Thanks anyway.

RichardF|||Worked for me to after spending a lot of time trying to get around this problem - Woo Hoo - Thanks|||

I get the error:

Input Error: Can not find script file "C:\inetpub\AdminScripts\adsutil.vbs"

When I run this script, anyone help?

|||

Turn UAC off: http://windowshelp.microsoft.com/Windows/en-US/Help/58b3b879-924d-4e08-9358-c316055d3eae1033.mspx

Follow this KB: http://support.microsoft.com/default.aspx/kb/934164

I now have SSRS on Windows Vista Ultimate. Woohhoo.

Can't install Reporting Services on Vista x64

When I try to install Reporting Services on my Vista x64 machine, the following happens:
Firstly, the System Configuration Check shows a "ASP.Net Version Registration Requirement" warning. Clicking on the error message gives the extra details "Failed to find the ASP.Net Version Registration with Microsoft Internet Information Services (IIS)."On the next section, Reporting Services is greyed out and so I can't attempt to install it.I have seen many other posts on this topic, and all seem to suggest that various IIS7 features need to be enabled in the "Turn Windows Features On or Off" section. I have already tried this, and in fact now have every possible IIS7 feature turned on. No change though.

I have also installed SQL 2005 SP2. But again going back to the install disk to add Reporting Services led to the same story.

So I'm pretty much completely stuck. Can anyone help?

Hi Fagster,

It seems that these workarounds worked for other people. Could you try it, please, and let me know how is working?

For install 32 bit Reporting Services on Vista run this script before the Reporting Services installation:

cscript %SystemDrive%\inetpub\AdminScripts\adsutil.vbs set w3svc/AppPools/Enable32bitAppOnWin64 1

For install 64 bit Reporting Services on Vista run this script before the Reporting Services installation:

cscript %SystemDrive%\inetpub\AdminScripts\adsutil.vbs set w3svc/AppPools/Enable32bitAppOnWin64 0

Mihaela

|||This did indeed work. I managed to post this twice so I may well be the "other people".

Thanks anyway.

RichardF
|||Worked for me to after spending a lot of time trying to get around this problem - Woo Hoo - Thanks|||

I get the error:

Input Error: Can not find script file "C:\inetpub\AdminScripts\adsutil.vbs"

When I run this script, anyone help?

|||

Turn UAC off: http://windowshelp.microsoft.com/Windows/en-US/Help/58b3b879-924d-4e08-9358-c316055d3eae1033.mspx

Follow this KB: http://support.microsoft.com/default.aspx/kb/934164

I now have SSRS on Windows Vista Ultimate. Woohhoo.

Can't install Reporting Services on Vista x64

When I try to install Reporting Services on my Vista x64 machine, the following happens:
In the System Configuration Check, there is a "ASP.Net Version Registration Requirement" warning.
On the following section, Reporting Services is greyed out so cannot be installed.I have found many posts on this matter and all of them suggest going into "Turn Windows Features on / off" and enabling various IIS7 features. However, even though I have ticked every possible IIS7 feature the problem remained.

I have also installed SP2, but again this didn't help when I returned to the original installation.

Can anybody please help?

Could you try run the below script and install again.

For install 32 bit Reporting Services

cscript %SystemDrive%\inetpub\AdminScripts\adsutil.vbs set w3svc/AppPools/Enable32bitAppOnWin64 1|||Worked a treat - thanks very much!