Report Server Service Stopping Unexpectedly

we run ssrs 2005 sp2 hotfix applied - how do we troubleshoot a problem where the report server service is stopping unexpectedly several times a day.  When this happens please tell me what happens to the reports that are currently running.  I believe that

 

1)  a current subscription that is running will fail - not sure if it will try to restart itself 3 times or not

2)  connection to the report server db cannot be made when that occurs

 

this is a huge problem for us and we dont know what is causing it or how to fix it.  Any suggestions would help.  I can tell you that our customers flood the server with subscriptions

View Replies


ADVERTISEMENT

Stopping Cancelling Report Execution Reporting Services Ssrs 2005 Using The Web Service Api

Hello,
How can I stop a report I started by using:
ReportExecutionService rs = new ReportExecutionService()
.
.
.
rs.Render(...)
 

I need to stop the report when a user clicks a button in my aspx page.
 
TIA
gad

View Replies View Related

MSSQLSERVER Service Terminated Unexpectedly

HII have server MSDE 2000 SP3frequently server stopped, and print in log file information:1)17310 :SqlDumpExceptionHandler: Process 1984 generated fatal exception c0000005EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.2)17311 :SQL Server is aborting. Fatal exception c0000005 caught.3)The MSSQLSERVER service terminated unexpectedly.

View Replies View Related

MSSQLSERVER Service Terminated Unexpectedly

Hi

For 15 days now my SQL server service is terminating with the following error

MSSQLSERVER service terminated unexpectedly. It has done this 2 Time(s).
This service terminates and restarts automatically and sometimes doesnt restart we have to mannuly start it again.
Event ID: 7034.

Version Details

Version: MSSQL Server 2000
Service Pack: 3a
Build: 8.0.0.760

I have checked many forums most of them suggest to apply the latest service pack. But the same error has been reported by sites having SP4 also.
Kindly help.

Thank you
wasim

View Replies View Related

"The MSSQLServer Service Terminated Unexpectedly. "

MSSQLService terminated by itself, and autorestart successfully,however, there is no dmp files, no other msg on SQL errorlogs, SQLagent logs and NT event viewer logs.
it is SQL 7.0(sp3) Standard Edition on NT 4(sp6a).
It happens a few times today.
Rebooting both the web and databse server did not help.
Anyone has any suggestion or experience ???

View Replies View Related

ReportServer Service Terminated Unexpectedly

I have been looking for some information regarding an error I have gotten several times on my production SQL Server 2000 box. Operating System is Windows Server 2003.  The Reporting Services version is 8.00.878.00

Error is as follows:
The ReportServer service terminated unexpectedly. It has done this 3 time(s). The following corrective action will be taken in 60000 milliseconds: Restart the service.  

The service restarts normally, or at least seems to, and Reporting Services work with no other issues.  Received the error this morning (11/14); last time was on 10/31.

What can I do to prevent this from happening?

Thanks,
Cecily

View Replies View Related

MSSQLServer Service Terminated Unexpectedly MS-SQL 2000 With SP4

MSSQLServer service terminated unexpectedly

We are running SQL Server 2000 with SP4. This server has been running for the past six months with no SQL server problems. A Max of 10 users have access to the application running on this server.

The Event Viewer Log shows the
Source: MSSQLServer
Category: (2)
Type: Error
EventID: 17052
Description: The MSSQLSERVER service terminated unexpectedly.

No other error messages were seen in the SQL server log or windows event viewer.
The time when it terminated was not during peak load/activity.

The server is Windows 2003 with SP1. Any help would be appreciated.

View Replies View Related

Stopping A Service In A Script

How do you start/stop a service within a sql script?

View Replies View Related

Problems Stopping SQL6.5 Service

Has anyone got any clues for me about problems I'm having stopping 6.5 mssql service? It happens when our backup software calls a batch file to stop the sql services. Sometimes (1 or 2 times a week) the mssql service will fail to stop. It just tries indefinately till we come in and kill it. Has anyone had problems like this before? The NT event logs hold no clues nor the sql logs. Is there any extra logging I can turn on to reveal the problem it has stopping this service?

net stop mssqlserver

Thanks,

Simon

View Replies View Related

Stopping And Starting SQL Service On A Cluster

hello everyone,

I wonder if you can help me with a problem I have trying to support a web based application that uses SQL 2005.

The problem is that the application developers tell me that it is neccessary to stop and restart the SQL service as part of the troubleshooting process when their application stops working. Unfortunately, the customer has our application database on a clustered SQL instance that is used by other applications so they cannot just stop and restart the SQL service because this will have a major impact on all the other instances...

Is there another way that would effectively do the same thing as stopping and restarting the SQL service? I have read that dettaching and re-attaching might do the same but application developers say onlt stopping/restarting services is sufficient to break the connection with the application.

Any advice would be really welcome as I am completely new to SQL and struggling with this!

Many thanks, Nick.

View Replies View Related

Stopping A Run-away Service Broker Process

 

I have a service broker process that's in run-away mode and I cannot figure out how to stop it.
 
Here's the situation:
 
The stored procedure named in the activation queue is opening a transaction but not closing it.  The receive loop has a timeout of 3 seconds, with MAX_QUEUE_READERS set to 5 so every 3 seconds I'm getting 15 new records in

sys.dm_tran_locks.
 
The server is at 99% CPU with no users on it.
 
 
The problem is I can't stop it.  Here's what I have tried:
 
Reboot the box                                                                          Clears the lock table and runs away again
ALTER QUEUE <Queue Name> WITH STATUS=OFF                  Just sits there forever
Drop the Service, Drop the Queue                                               Just sits there forever
Dropped the stored procedure itself (!)                                         It's still running like crazy
 
So my immediate question is how do I stop this crazy thing?  And the follow up question is when a programmer makes a mistake, do we have to reformat our DEV box to recover from it (that's a joke) -- seriously how do you stop a run away service broker process?
 
 
 

View Replies View Related

The Report Server Windows Service 'ReportServer' Is Not Running. The Service Must Be Running To Use Report Server

Hello Reporting Services 2005 users or Reporting Services Team,
                                     I have done everything to get pass this error but no luck.
My setup is :- WIndows 2003 Standared Edition SP1
Sql Server :-
Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86)   Oct 14 2005 00:33:37   Copyright (c) 1988-2005 Microsoft Corporation  Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 1)
Reporting Services starting SKU: Standard.
From the Reporting Services Configuration  Manager:
I can see all other things configured except Encryption Keys(blue sign)
Initialization(Grey sign) and Execution Acct(Yellow sign)
My windows Service Identity is using :
NT AuthorityNetworkService
Builtin Acct :NetworkService

Web Service Identity :-
ASP.NET Service Acct :- NT AuthorityNetworkService

DataBase Setup :- Credentials Type :- Service Credentials

I have also done everything from here thanks to Göran
  http://stevenharman.net/blog/archive/2007/03/21/Avoiding-the-401-Unauthorized-Error-when-Using-the-ReportViewer-in.aspx

and

 http://support.microsoft.com/default.aspx?scid=kb;en-us;896861
  and

http://forum.k2workflow.com/viewtopic.php?t=619&


If you guys any solution for this please let me know.
I was wondering could this be  a scale-out deployment issue ?

I also get the error when setting up the DataBase Setup :
Although saving the database connection info succeeded the The report server cannot access internal info about this deployment to determine whetherthe current con fig is valid for this editionThis could be a scale-out deployment and that the feature is not supported by this editionTo continue use a diff report server database or remove the encription keys


 
My Error log file is below:-
w3wp!webserver!5!16/05/2007-14:52:46:: i INFO: Reporting Web Server started
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing ConnectionType to '0'  as specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing IsSchedulingService to 'True'  as specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing IsNotificationService to 'True'  as specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing IsEventService to 'True'  as specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing WindowsServiceUseFileShareStorage to 'False'  as specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing MemoryLimit to '60' percent as specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing MaximumMemoryLimit to '80' percent as specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing IsWebServiceEnabled to 'True'  as specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing ProcessRecycleOptions to '0'  as specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing WatsonFlags to '1064'  as specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing WatsonDumpOnExceptions to 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException'  as specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException'  as specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing SecureConnectionLevel to '0'  as specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing DisplayErrorLink to 'True'  as specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing WebServiceUseFileShareStorage to 'False'  as specified in Configuration file.
w3wp!resourceutilities!5!16/05/2007-14:52:46:: i INFO: Reporting Services starting SKU: Standard
w3wp!resourceutilities!5!16/05/2007-14:52:46:: i INFO: Evaluation copy: 0 days left
w3wp!resourceutilities!5!16/05/2007-14:52:46:: i INFO: Running on 1 physical processors, 2 logical processors
w3wp!runningjobs!5!16/05/2007-14:52:46:: i INFO: Database Cleanup (Web Service) timer enabled: Next Event: 600 seconds.  Cycle: 600 seconds
w3wp!runningjobs!5!16/05/2007-14:52:46:: i INFO: Running Requests Scavenger timer enabled: Next Event: 60 seconds.  Cycle: 60 seconds
w3wp!runningjobs!5!16/05/2007-14:52:46:: i INFO: Running Requests DB timer enabled: Next Event: 60 seconds.  Cycle: 60 seconds
w3wp!runningjobs!5!16/05/2007-14:52:46:: i INFO: Memory stats update timer enabled: Next Event: 60 seconds.  Cycle: 60 seconds
w3wp!library!5!05/16/2007-14:52:48:: i INFO: Call to GetPermissions:/
w3wp!library!5!05/16/2007-14:52:48:: i INFO: Catalog SQL Server Edition = Standard
w3wp!library!5!05/16/2007-14:52:48:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerServiceUnavailableException: The Report Server Windows service 'ReportServer' is not running. The service must be running to use Report Server., ;
 Info: Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerServiceUnavailableException: The Report Server Windows service 'ReportServer' is not running. The service must be running to use Report Server.
w3wp!library!5!05/16/2007-14:52:48:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerServiceUnavailableException: The Report Server Windows service 'ReportServer' is not running. The service must be running to use Report Server., ;
 Info: Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerServiceUnavailableException: The Report Server Windows service 'ReportServer' is not running. The service must be running to use Report Server.
w3wp!library!5!05/16/2007-14:52:49:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerServiceUnavailableException: The Report Server Windows service 'ReportServer' is not running. The service must be running to use Report Server., ;
 Info: Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerServiceUnavailableException: The Report Server Windows service 'ReportServer' is not running. The service must be running to use Report Server.
w3wp!library!5!05/16/2007-14:52:49:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerServiceUnavailableException: The Report Server Windows service 'ReportServer' is not running. The service must be running to use Report Server., ;
 Info: Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerServiceUnavailableException: The Report Server Windows service 'ReportServer' is not running. The service must be running to use Report Server.

View Replies View Related

Report Service Cannot Find Report Server

Hello, everyone:

I have SQL 2k and V .NET 2003 installed. I build a SQL Server Report from .NET 2003, and configure TargetServerURL by default http://localhost/ReportServer. When I deploy report, there is error message,

A connection could not made to the report server http://localhost/ReportServer

Can I deploy the report from local computer?

Any help will be great appreciated.

ZYT

View Replies View Related

Event 107 &&"Report Server Windows Service (MSSQLSERVER) Cannot Connect To The Report Server Database.&&"

every 1 hour my server's computer is restarting !
when the windows finish restarting i open the Event viewer and see that what coused it is the error :
 

"Report Server Windows Service (MSSQLSERVER) cannot connect to the report server database."
Event 107
source : "Report Server Windows Service (MSSQLSERVER)"
 
How can i solve it ?
 

View Replies View Related

Event 107 &&"Report Server Windows Service (MSSQLSERVER) Cannot Connect To The Report Server Database.&&"

 
every 1 hour my server's computer is restarting !
when the windows finish restarting i open the Event viewer and see that what coused it is the error :
 

"Report Server Windows Service (MSSQLSERVER) cannot connect to the report server database."
Event 107
source : "Report Server Windows Service (MSSQLSERVER)"
 
How can i solve it ?

View Replies View Related

Reporting Server Down Unexpectedly

Hi All,

We have a server which has Sql Server 2005 and the reporting server running on it. Now it happens sometimes that the reporting server stops working. We get the following errors randomly whenever we try generating a report

1) Report item not found
2) Transaction error - this is a long error, which has some transaction number and some other stuff


We looked the application Event viewer for the exact problem. It said the "Report Server (MSSQLSERVER) cannot connect to the report server database".
We then opened the reporting Service configuration tool and under the database setup, connected to the database again and applied changes so as to grant rights to the DB again.
After this the reporting server worked fine and reorts were getting generated.
This problem comes has come a number of times already and we can't be expected to do the above fix everytime.
If anybody knows why this issue comes and how it can be resolved please let me know

Regards,
Japjit

View Replies View Related

SQL Server Setup Unexpectedly Failed ... Again, And Again, And Again

I'm trying to install SQL Server 2005 Express SP1 on my Windows XP Laptop and keep getting "SQL Server Setup unexpectedly failed.  For more information, review the setup summary log file."  I've pasted it in below.    I'm not very computer literate but I've tried to follow the directions on the Microsoft site regarding Windows Installer and dotNet 2.0.  There were no previous versions of  SQL on this laptop.  I have administrative rights on the laptop.  Any help would be greatly appreciated.
 
Microsoft SQL Server 2005 Setup beginning at Sun Mar 30 08:54:25 2008
Process ID      : 2112
c:f6cf225c4f4b5a77a820923894457csetup.exe Version: 2005.90.2047.0
Running: LoadResourcesAction at: 2008/2/30 8:54:25
Complete: LoadResourcesAction at: 2008/2/30 8:54:25, returned true
Running: ParseBootstrapOptionsAction at: 2008/2/30 8:54:25
Loaded DLL:c:f6cf225c4f4b5a77a820923894457cxmlrw.dll Version:2.0.3609.0
Complete: ParseBootstrapOptionsAction at: 2008/2/30 8:54:25, returned false
Error: Action "ParseBootstrapOptionsAction" failed during execution.  Error information reported during run:
Could not parse command line due to datastore exception.
  Source File Name: utillibpersisthelpers.cpp
Compiler Timestamp: Wed Oct 26 16:38:20 2005
     Function Name: writeEncryptedString
Source Line Number: 124
----------------------------------------------------------
writeEncryptedString() failed
   Source File Name: utillibpersisthelpers.cpp
 Compiler Timestamp: Wed Oct 26 16:38:20 2005
      Function Name: writeEncryptedString
 Source Line Number: 123
 ----------------------------------------------------------
         Error Code: 0x80070002 (2)
Windows Error Text: The system cannot find the file specified.
  Source File Name: cryptohelpercryptsameusersamemachine.cpp
Compiler Timestamp: Wed Oct 26 16:37:25 2005
     Function Name: sqls::CryptSameUserSameMachine:rotectData
Source Line Number: 50
2
Could not skip Component update due to datastore exception.
  Source File Name: datastorecachedpropertycollection.cpp
Compiler Timestamp: Wed Oct 26 16:37:20 2005
     Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
----------------------------------------------------------
Failed to find property "InstallMediaPath" {"SetupBootstrapOptionsScope", "", "2112"} in cache
   Source File Name: datastorepropertycollection.cpp
 Compiler Timestamp: Wed Oct 26 16:37:21 2005
      Function Name: SetupBootstrapOptionsScope.InstallMediaPath
 Source Line Number: 44
 ----------------------------------------------------------
 No collector registered for scope: "SetupBootstrapOptionsScope"
Running: ValidateWinNTAction at: 2008/2/30 8:54:25
Complete: ValidateWinNTAction at: 2008/2/30 8:54:25, returned true
Running: ValidateMinOSAction at: 2008/2/30 8:54:25
Complete: ValidateMinOSAction at: 2008/2/30 8:54:25, returned true
Running: PerformSCCAction at: 2008/2/30 8:54:25
Complete: PerformSCCAction at: 2008/2/30 8:54:25, returned true
Running: ActivateLoggingAction at: 2008/2/30 8:54:25
Error: Action "ActivateLoggingAction" threw an exception during execution.  Error information reported during run:
Datastore exception while trying to write logging properties.
  Source File Name: datastorecachedpropertycollection.cpp
Compiler Timestamp: Wed Oct 26 16:37:20 2005
     Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
----------------------------------------------------------
Failed to find property "primaryLogFiles" {"SetupStateScope", "", ""} in cache
   Source File Name: datastorepropertycollection.cpp
 Compiler Timestamp: Wed Oct 26 16:37:21 2005
      Function Name: SetupStateScope.primaryLogFiles
 Source Line Number: 44
 ----------------------------------------------------------
 No collector registered for scope: "SetupStateScope"
00DACFC0Unable to proceed with setup, there was a command line parsing error. : 2
        Error Code: 0x80070002 (2)
Windows Error Text: The system cannot find the file specified.
  Source File Name: datastorepropertycollection.cpp
Compiler Timestamp: Wed Oct 26 16:37:21 2005
     Function Name: SetupBootstrapOptionsScope.InstallMediaPath
Source Line Number: 44
Class not registered.
Failed to create CAB file due to datastore exception
  Source File Name: datastorecachedpropertycollection.cpp
Compiler Timestamp: Wed Oct 26 16:37:20 2005
     Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
----------------------------------------------------------
Failed to find property "HostSetup" {"SetupBootstrapOptionsScope", "", "2112"} in cache
   Source File Name: datastorepropertycollection.cpp
 Compiler Timestamp: Wed Oct 26 16:37:21 2005
      Function Name: SetupBootstrapOptionsScope.HostSetup
 Source Line Number: 44
 ----------------------------------------------------------
 No collector registered for scope: "SetupBootstrapOptionsScope"
Message pump returning: 2

View Replies View Related

SQL Server Setup Unexpectedly Failed

While trying to download SQL Server 2005 Express SP2 I receive the following error message: 'SQL server Setup Unexpectedly dailed. For more information review the Setup memory log file in %Program Files%Microsoft SQL Server90Setup BootstrapLOGSummary.txt'.
 
That log file simply contains the text:
 
  Microsoft SQL Server 2005 9.00.3042.00
==============================
OS Version      : Microsoft Windows XP Professional Service Pack 2 (Build 2600)
 
In the Files folder under log, a text file has been created with the following data:
 
 

Microsoft SQL Server 2005 Setup beginning at Mon Nov 19 20:30:29 2007
Process ID      : 4648
c:fc359db69b5e5a0ff927be3c2esetup.exe Version: 2005.90.3042.0
Running: LoadResourcesAction at: 2007/10/19 20:30:28
Complete: LoadResourcesAction at: 2007/10/19 20:30:28, returned true
Running: ParseBootstrapOptionsAction at: 2007/10/19 20:30:28
Loaded DLL:c:fc359db69b5e5a0ff927be3c2exmlrw.dll Version:2.0.3609.0
Complete: ParseBootstrapOptionsAction at: 2007/10/19 20:30:29, returned false
Error: Action "ParseBootstrapOptionsAction" failed during execution.  Error information reported during run:
Could not parse command line due to datastore exception.
  Source File Name: utillibpersisthelpers.cpp
Compiler Timestamp: Wed Jun 14 16:30:14 2006
     Function Name: writeEncryptedString
Source Line Number: 124
----------------------------------------------------------
writeEncryptedString() failed
   Source File Name: utillibpersisthelpers.cpp
 Compiler Timestamp: Wed Jun 14 16:30:14 2006
      Function Name: writeEncryptedString
 Source Line Number: 123
 ----------------------------------------------------------
         Error Code: -2146893813
Windows Error Text: Key not valid for use in specified state.

  Source File Name: cryptohelpercryptsameusersamemachine.cpp
Compiler Timestamp: Wed Jun 14 16:28:04 2006
     Function Name: sqls::CryptSameUserSameMachine:rotectData
Source Line Number: 50

2148073483
Could not skip Component update due to datastore exception.
  Source File Name: datastorecachedpropertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:27:59 2006
     Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
----------------------------------------------------------
Failed to find property "InstallMediaPath" {"SetupBootstrapOptionsScope", "", "4648"} in cache
   Source File Name: datastorepropertycollection.cpp
 Compiler Timestamp: Wed Jun 14 16:28:01 2006
      Function Name: SetupBootstrapOptionsScope.InstallMediaPath
 Source Line Number: 44
 ----------------------------------------------------------
 No collector registered for scope: "SetupBootstrapOptionsScope"
Running: ValidateWinNTAction at: 2007/10/19 20:30:29
Complete: ValidateWinNTAction at: 2007/10/19 20:30:29, returned true
Running: ValidateMinOSAction at: 2007/10/19 20:30:29
Complete: ValidateMinOSAction at: 2007/10/19 20:30:29, returned true
Running: PerformSCCAction at: 2007/10/19 20:30:29
Complete: PerformSCCAction at: 2007/10/19 20:30:29, returned true
Running: ActivateLoggingAction at: 2007/10/19 20:30:29
Error: Action "ActivateLoggingAction" threw an exception during execution.  Error information reported during run:
Datastore exception while trying to write logging properties.
  Source File Name: datastorecachedpropertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:27:59 2006
     Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
----------------------------------------------------------
Failed to find property "primaryLogFiles" {"SetupStateScope", "", ""} in cache
   Source File Name: datastorepropertycollection.cpp
 Compiler Timestamp: Wed Jun 14 16:28:01 2006
      Function Name: SetupStateScope.primaryLogFiles
 Source Line Number: 44
 ----------------------------------------------------------
 No collector registered for scope: "SetupStateScope"
00DFCFC0Unable to proceed with setup, there was a command line parsing error. : 2
        Error Code: 0x80070002 (2)
Windows Error Text: The system cannot find the file specified.

  Source File Name: datastorepropertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:28:01 2006
     Function Name: SetupBootstrapOptionsScope.InstallMediaPath
Source Line Number: 44

Class not registered.

 
Can anyone give me some advice on what I need to correct in order to be able to install SQl server Express? Thanks very much in advance.

View Replies View Related

SQL Server Setup Unexpectedly Failed

Hi,
I am having the same problem as Cherley Vasconcelos mentioned.

   I checked for the 2 below mentioned Registery entries as suggested and they are present.

System:

       HKEY_USERSS-1-5-18SoftwareMicrosoftWindowsCurrentVersionExplorerUser Shell Folders

   User:

     HKEY_CURRENT_USERSoftwareMicrosoftWindowsCurrentVersionExplorerUser Shell Folders

AppData entry is present under the above registry entries with the value of "%USERPROFILE%Application Data

But the problem still exists.

Please Help,
Thanks in advance,     
Sonia

The log file is as follows

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

Microsoft SQL Server 2005 Setup beginning at Mon Jun 19 10:43:41 2006
Process ID      : 3476
c:c8e46d550eeabd55d7setup.exe Version: 2005.90.2047.0
Running: LoadResourcesAction at: 2006/5/19 10:43:40
Complete: LoadResourcesAction at: 2006/5/19 10:43:40, returned true
Running: ParseBootstrapOptionsAction at: 2006/5/19 10:43:40
Loaded DLL:c:c8e46d550eeabd55d7xmlrw.dll Version:2.0.3609.0
Complete: ParseBootstrapOptionsAction at: 2006/5/19 10:43:41, returned false
Error: Action "ParseBootstrapOptionsAction" failed during execution.  Error information reported during run:
Could not parse command line due to datastore exception.
  Source File Name: utillibpersisthelpers.cpp
Compiler Timestamp: Wed Oct 26 16:38:20 2005
     Function Name: writeEncryptedString
Source Line Number: 124
----------------------------------------------------------
writeEncryptedString() failed
   Source File Name: utillibpersisthelpers.cpp
 Compiler Timestamp: Wed Oct 26 16:38:20 2005
      Function Name: writeEncryptedString
 Source Line Number: 123
 ----------------------------------------------------------
         Error Code: -2146893813
Windows Error Text: Key not valid for use in specified state.

  Source File Name: cryptohelpercryptsameusersamemachine.cpp
Compiler Timestamp: Wed Oct 26 16:37:25 2005
     Function Name: sqls::CryptSameUserSameMachine::ProtectData
Source Line Number: 50

2148073483
Could not skip Component update due to datastore exception.
  Source File Name: datastorecachedpropertycollection.cpp
Compiler Timestamp: Wed Oct 26 16:37:20 2005
     Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
----------------------------------------------------------
Failed to find property "InstallMediaPath" {"SetupBootstrapOptionsScope", "", "3476"} in cache
   Source File Name: datastorepropertycollection.cpp
 Compiler Timestamp: Wed Oct 26 16:37:21 2005
      Function Name: SetupBootstrapOptionsScope.InstallMediaPath
 Source Line Number: 44
 ----------------------------------------------------------
 No collector registered for scope: "SetupBootstrapOptionsScope"
Running: ValidateWinNTAction at: 2006/5/19 10:43:41
Complete: ValidateWinNTAction at: 2006/5/19 10:43:41, returned true
Running: ValidateMinOSAction at: 2006/5/19 10:43:41
Complete: ValidateMinOSAction at: 2006/5/19 10:43:41, returned true
Running: PerformSCCAction at: 2006/5/19 10:43:41
Complete: PerformSCCAction at: 2006/5/19 10:43:41, returned true
Running: ActivateLoggingAction at: 2006/5/19 10:43:41
Error: Action "ActivateLoggingAction" threw an exception during execution.  Error information reported during run:
Datastore exception while trying to write logging properties.
  Source File Name: datastorecachedpropertycollection.cpp
Compiler Timestamp: Wed Oct 26 16:37:20 2005
     Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
----------------------------------------------------------
Failed to find property "primaryLogFiles" {"SetupStateScope", "", ""} in cache
   Source File Name: datastorepropertycollection.cpp
 Compiler Timestamp: Wed Oct 26 16:37:21 2005
      Function Name: SetupStateScope.primaryLogFiles
 Source Line Number: 44
 ----------------------------------------------------------
 No collector registered for scope: "SetupStateScope"
00F8CFC0Unable to proceed with setup, there was a command line parsing error. : 2
        Error Code: 0x80070002 (2)
Windows Error Text: The system cannot find the file specified.

  Source File Name: datastorepropertycollection.cpp
Compiler Timestamp: Wed Oct 26 16:37:21 2005
     Function Name: SetupBootstrapOptionsScope.InstallMediaPath
Source Line Number: 44

Class not registered.
Failed to create CAB file due to datastore exception
  Source File Name: datastorecachedpropertycollection.cpp
Compiler Timestamp: Wed Oct 26 16:37:20 2005
     Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
----------------------------------------------------------
Failed to find property "HostSetup" {"SetupBootstrapOptionsScope", "", "3476"} in cache
   Source File Name: datastorepropertycollection.cpp
 Compiler Timestamp: Wed Oct 26 16:37:21 2005
      Function Name: SetupBootstrapOptionsScope.HostSetup
 Source Line Number: 44
 ----------------------------------------------------------
 No collector registered for scope: "SetupBootstrapOptionsScope"
Message pump returning: 2


 

View Replies View Related

SQL Server Setup Unexpectedly Failed (again)

I´m running WinXP SP2 with 1GB RAM, dotNET 2.0. and a previous install of SQL Server 2000. I have tried to install SQL Server 2005 Express and it fails early in the installation: "SQL Server Setup unexpectedly failed. For more information, review the Setup summary log file...". The log file is: (!)

Microsoft SQL Server 2005 9.00.1399.06
==============================
OS Version      : Microsoft Windows XP Professional Service Pack 2 (Build 2600)
Time            : Wed Jun 14 10:27:51 2006

I have tried named instances, reinstall SQL Server 2000, search readme, kb, forums about the problem....nothing

Help, please.

View Replies View Related

Difference In Starting Rep Service Vs. Stopping And Starting The Rep Job?

When our rep distribution services time-out (several times a day) some dba's just restart the service while others restart the rep job which starts the service.  Are there any differences between  these two methods?  Does restarting the service inherit any changes made to the job's attributes?

 

Thanks!

View Replies View Related

Unexpectedly Failed Installation Of SQL Server Express Edition

Pls help me on this issue...

The min reqt olny says Windows XP Service Pack 2.  So, whether it is Pro or Home I assume this Edition will run.  MY system is XP Home SP2 with 2GB RAM and Dual Core Intel Processor.  Is this the problem?  There is no error displayed on the summary.txt and I do not know how to read the log file.  Pls help... Or do I need to upgrade to XP Pro?
 
This is the log file details:
 
Microsoft SQL Server 2005 Setup beginning at Wed Aug 08 17:15:25 2007
Process ID      : 3956
c:d9bc063efa643d3b71e3setup.exe Version: 2005.90.1399.0
Running: LoadResourcesAction at: 2007/7/8 17:15:24
Complete: LoadResourcesAction at: 2007/7/8 17:15:24, returned true
Running: ParseBootstrapOptionsAction at: 2007/7/8 17:15:24
Loaded DLL:c:d9bc063efa643d3b71e3xmlrw.dll Version:2.0.3604.0
Complete: ParseBootstrapOptionsAction at: 2007/7/8 17:15:25, returned false
Error: Action "ParseBootstrapOptionsAction" failed during execution.  Error information reported during run:
Could not parse command line due to datastore exception.
  Source File Name: utillibpersisthelpers.cpp
Compiler Timestamp: Fri Jul 29 01:13:55 2005
     Function Name: writeEncryptedString
Source Line Number: 124
----------------------------------------------------------
writeEncryptedString() failed
   Source File Name: utillibpersisthelpers.cpp
 Compiler Timestamp: Fri Jul 29 01:13:55 2005
      Function Name: writeEncryptedString
 Source Line Number: 123
 ----------------------------------------------------------
         Error Code: 0x80070002 (2)
Windows Error Text: The system cannot find the file specified.
  Source File Name: cryptohelpercryptsameusersamemachine.cpp
Compiler Timestamp: Mon Jun 13 14:30:00 2005
     Function Name: sqls::CryptSameUserSameMachine:rotectData
Source Line Number: 50
2
Could not skip Component update due to datastore exception.
  Source File Name: datastorecachedpropertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:49 2005
     Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
----------------------------------------------------------
Failed to find property "InstallMediaPath" {"SetupBootstrapOptionsScope", "", "3956"} in cache
   Source File Name: datastorepropertycollection.cpp
 Compiler Timestamp: Fri Jul 29 01:13:50 2005
      Function Name: SetupBootstrapOptionsScope.InstallMediaPath
 Source Line Number: 44
 ----------------------------------------------------------
 No collector registered for scope: "SetupBootstrapOptionsScope"
Running: ValidateWinNTAction at: 2007/7/8 17:15:25
Complete: ValidateWinNTAction at: 2007/7/8 17:15:25, returned true
Running: ValidateMinOSAction at: 2007/7/8 17:15:25
Complete: ValidateMinOSAction at: 2007/7/8 17:15:25, returned true
Running: PerformSCCAction at: 2007/7/8 17:15:25
Complete: PerformSCCAction at: 2007/7/8 17:15:25, returned true
Running: ActivateLoggingAction at: 2007/7/8 17:15:25
Error: Action "ActivateLoggingAction" threw an exception during execution.  Error information reported during run:
Datastore exception while trying to write logging properties.
  Source File Name: datastorecachedpropertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:49 2005
     Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
----------------------------------------------------------
Failed to find property "primaryLogFiles" {"SetupStateScope", "", ""} in cache
   Source File Name: datastorepropertycollection.cpp
 Compiler Timestamp: Fri Jul 29 01:13:50 2005
      Function Name: SetupStateScope.primaryLogFiles
 Source Line Number: 44
 ----------------------------------------------------------
 No collector registered for scope: "SetupStateScope"
02AFCFC4Unable to proceed with setup, there was a command line parsing error. : 2
        Error Code: 0x80070002 (2)
Windows Error Text: The system cannot find the file specified.
  Source File Name: datastorepropertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:50 2005
     Function Name: SetupBootstrapOptionsScope.InstallMediaPath
Source Line Number: 44
Class not registered.
Failed to create CAB file due to datastore exception
  Source File Name: datastorecachedpropertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:49 2005
     Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
----------------------------------------------------------
Failed to find property "HostSetup" {"SetupBootstrapOptionsScope", "", "3956"} in cache
   Source File Name: datastorepropertycollection.cpp
 Compiler Timestamp: Fri Jul 29 01:13:50 2005
      Function Name: SetupBootstrapOptionsScope.HostSetup
 Source Line Number: 44
 ----------------------------------------------------------
 No collector registered for scope: "SetupBootstrapOptionsScope"
Message pump returning: 2

View Replies View Related

Unexpectedly Failed Installation Of SQL Server Express Edition

 

Hi, until now nobody's helping me regarding installing SQL Server Express Ed...  Here is the error log ive been getting... Pls help...  Anybody Microsoft expert out there...  If I call Microsoft Support and pay the hourly support, can they help me?  Or is there a local Microsoft Office I can go to so they can see my unit and install this system for me?  Pls help...
 
I checked a lot of things already.
 
1. Services for Cryptographic Services and Protected Storage
2. I repaired the cryptAPI
3. and a lot of things...
 
Microsoft SQL Server 2005 Setup beginning at Wed Sep 19 00:13:03 2007
Process ID      : 4888
C:Documents and SettingsVicMy DocumentsInstallersqlserver2005expressServerssetup.exe Version: 2005.90.3042.0
Running: LoadResourcesAction at: 2007/8/19 0:13:3
Complete: LoadResourcesAction at: 2007/8/19 0:13:3, returned true
Running: ParseBootstrapOptionsAction at: 2007/8/19 0:13:3
Loaded DLL:C:Documents and SettingsVicMy DocumentsInstallersqlserver2005expressServersxmlrw.dll Version:2.0.3609.0
Complete: ParseBootstrapOptionsAction at: 2007/8/19 0:13:3, returned false
Error: Action "ParseBootstrapOptionsAction" failed during execution.  Error information reported during run:
Could not parse command line due to datastore exception.
  Source File Name: utillibpersisthelpers.cpp
Compiler Timestamp: Wed Jun 14 16:30:14 2006
     Function Name: writeEncryptedString
Source Line Number: 124
----------------------------------------------------------
writeEncryptedString() failed
   Source File Name: utillibpersisthelpers.cpp
 Compiler Timestamp: Wed Jun 14 16:30:14 2006
      Function Name: writeEncryptedString
 Source Line Number: 123
 ----------------------------------------------------------
         Error Code: 0x80070002 (2)
Windows Error Text: The system cannot find the file specified.
  Source File Name: cryptohelpercryptsameusersamemachine.cpp
Compiler Timestamp: Wed Jun 14 16:28:04 2006
     Function Name: sqls::CryptSameUserSameMachine:rotectData
Source Line Number: 50
2
Could not skip Component update due to datastore exception.
  Source File Name: datastorecachedpropertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:27:59 2006
     Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
----------------------------------------------------------
Failed to find property "InstallMediaPath" {"SetupBootstrapOptionsScope", "", "4888"} in cache
   Source File Name: datastorepropertycollection.cpp
 Compiler Timestamp: Wed Jun 14 16:28:01 2006
      Function Name: SetupBootstrapOptionsScope.InstallMediaPath
 Source Line Number: 44
 ----------------------------------------------------------
 No collector registered for scope: "SetupBootstrapOptionsScope"
Running: ValidateWinNTAction at: 2007/8/19 0:13:3
Complete: ValidateWinNTAction at: 2007/8/19 0:13:3, returned true
Running: ValidateMinOSAction at: 2007/8/19 0:13:3
Complete: ValidateMinOSAction at: 2007/8/19 0:13:3, returned true
Running: PerformSCCAction at: 2007/8/19 0:13:3
Complete: PerformSCCAction at: 2007/8/19 0:13:3, returned true
Running: ActivateLoggingAction at: 2007/8/19 0:13:3
Error: Action "ActivateLoggingAction" threw an exception during execution.  Error information reported during run:
Datastore exception while trying to write logging properties.
  Source File Name: datastorecachedpropertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:27:59 2006
     Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
----------------------------------------------------------
Failed to find property "primaryLogFiles" {"SetupStateScope", "", ""} in cache
   Source File Name: datastorepropertycollection.cpp
 Compiler Timestamp: Wed Jun 14 16:28:01 2006
      Function Name: SetupStateScope.primaryLogFiles
 Source Line Number: 44
 ----------------------------------------------------------
 No collector registered for scope: "SetupStateScope"
02B0CFC0Unable to proceed with setup, there was a command line parsing error. : 2
        Error Code: 0x80070002 (2)
Windows Error Text: The system cannot find the file specified.
  Source File Name: datastorepropertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:28:01 2006
     Function Name: SetupBootstrapOptionsScope.InstallMediaPath
Source Line Number: 44
Class not registered.
Failed to create CAB file due to datastore exception
  Source File Name: datastorecachedpropertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:27:59 2006
     Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
----------------------------------------------------------
Failed to find property "HostSetup" {"SetupBootstrapOptionsScope", "", "4888"} in cache
   Source File Name: datastorepropertycollection.cpp
 Compiler Timestamp: Wed Jun 14 16:28:01 2006
      Function Name: SetupBootstrapOptionsScope.HostSetup
 Source Line Number: 44
 ----------------------------------------------------------
 No collector registered for scope: "SetupBootstrapOptionsScope"
Message pump returning: 2

 
 

View Replies View Related

SQL Server Express 2005 Setup Unexpectedly Failed

When i try to install, the filed are extracted and then i get this error message:

SQL Server Setup unexpectedly failed. For more information, review the Setup summery log file in %ProgramFiles%Microsoft SQL Server90Setup BootstrapLOGSummary.txt

I open the file and this is all i get:

Microsoft SQL Server 2005 9.00.3042.00
==============================
OS Version      : Microsoft Windows XP Professional

Service Pack 2 (Build 2600)
Time            : Mon Apr 02 15:31:10 2007
 
I looked in this forum at others peoples threads and it seems as if they all have a lot larger Summary.txt file.  I never had any other verson of SQL Server installed on this computer and i just uninstalled .net 2.0 framework and reinstalled it.

My computer runs Windows XP Pro with SP 2, AMD Athlon 64 Processor 3500+ 2.20 GHz, 1.00GB of RAM.

Anyone have any clue why the installation wont even start?

View Replies View Related

SQL Server Unexpectedly Failed. For More Info... Review The Setup Summary Log File

 

I reviewed the summary log file (summary.txt) and it doesnt say anything about the error.  What should i do? Or do you need this log file instead:
 
Microsoft SQL Server 2005 Setup beginning at Mon Aug 13 16:33:44 2007
Process ID      : 1152
c:73c84d3c7b67051226cca30bsetup.exe Version: 2005.90.3042.0
Running: LoadResourcesAction at: 2007/7/13 16:33:44
Complete: LoadResourcesAction at: 2007/7/13 16:33:44, returned true
Running: ParseBootstrapOptionsAction at: 2007/7/13 16:33:44
Loaded DLL:c:73c84d3c7b67051226cca30bxmlrw.dll Version:2.0.3609.0
Complete: ParseBootstrapOptionsAction at: 2007/7/13 16:33:44, returned false
Error: Action "ParseBootstrapOptionsAction" failed during execution.  Error information reported during run:
Could not parse command line due to datastore exception.
  Source File Name: utillibpersisthelpers.cpp
Compiler Timestamp: Wed Jun 14 16:30:14 2006
     Function Name: writeEncryptedString
Source Line Number: 124
----------------------------------------------------------
writeEncryptedString() failed
   Source File Name: utillibpersisthelpers.cpp
 Compiler Timestamp: Wed Jun 14 16:30:14 2006
      Function Name: writeEncryptedString
 Source Line Number: 123
 ----------------------------------------------------------
         Error Code: 0x80070002 (2)
Windows Error Text: The system cannot find the file specified.
  Source File Name: cryptohelpercryptsameusersamemachine.cpp
Compiler Timestamp: Wed Jun 14 16:28:04 2006
     Function Name: sqls::CryptSameUserSameMachine:rotectData
Source Line Number: 50
2
Could not skip Component update due to datastore exception.
  Source File Name: datastorecachedpropertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:27:59 2006
     Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
----------------------------------------------------------
Failed to find property "InstallMediaPath" {"SetupBootstrapOptionsScope", "", "1152"} in cache
   Source File Name: datastorepropertycollection.cpp
 Compiler Timestamp: Wed Jun 14 16:28:01 2006
      Function Name: SetupBootstrapOptionsScope.InstallMediaPath
 Source Line Number: 44
 ----------------------------------------------------------
 No collector registered for scope: "SetupBootstrapOptionsScope"
Running: ValidateWinNTAction at: 2007/7/13 16:33:44
Complete: ValidateWinNTAction at: 2007/7/13 16:33:44, returned true
Running: ValidateMinOSAction at: 2007/7/13 16:33:44
Complete: ValidateMinOSAction at: 2007/7/13 16:33:44, returned true
Running: PerformSCCAction at: 2007/7/13 16:33:44
Complete: PerformSCCAction at: 2007/7/13 16:33:44, returned true
Running: ActivateLoggingAction at: 2007/7/13 16:33:44
Error: Action "ActivateLoggingAction" threw an exception during execution.  Error information reported during run:
Datastore exception while trying to write logging properties.
  Source File Name: datastorecachedpropertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:27:59 2006
     Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
----------------------------------------------------------
Failed to find property "primaryLogFiles" {"SetupStateScope", "", ""} in cache
   Source File Name: datastorepropertycollection.cpp
 Compiler Timestamp: Wed Jun 14 16:28:01 2006
      Function Name: SetupStateScope.primaryLogFiles
 Source Line Number: 44
 ----------------------------------------------------------
 No collector registered for scope: "SetupStateScope"
02B0CFC0Unable to proceed with setup, there was a command line parsing error. : 2
        Error Code: 0x80070002 (2)
Windows Error Text: The system cannot find the file specified.
  Source File Name: datastorepropertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:28:01 2006
     Function Name: SetupBootstrapOptionsScope.InstallMediaPath
Source Line Number: 44
Class not registered.

View Replies View Related

Configuring SQL Server Report Service

SQL Server 2005 Sp2

Windows Server 2003 Sp2

When i open the Reporting Services Configuration Manager on our newly installed SQL 2005 box i get a red X on "Web Service Identity".

The window in question states that "The Web Service runs under the ASP .NET Machine account under IIS 5 or ..."  with what looks to be a text entry box that is grayed out with the label "ASP .NET Service Account. The text entry box that is grayed out is blank.

When the Apply button is pressed a Task Status box opens at the bottom that states "There was an error setting the identity for the web service. The previously set identity will still be used."

When the option for "Tell me more about the problem and how to resolve it." is pressed i get a dialog box that has two lines of text reading:

"ReportServicesConfigUI.WMIProvider.WMIProviderException: An unknown error has occured in the WMI provider. Error Code 80070005"

"at Report ServicesConfigUI.RSReportSErverAdmin.SetWebServiceIdentity(StringapplicationPool)"

 

I have the same question as http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=295080&SiteID=1

but hte difference is I my operation system is windows 2003.

 

 

View Replies View Related

Uninstall SQL2k5 Report Server/service

How do you uninstall SQL 2k5 report service/server? Thanks.

View Replies View Related

Uninstall SQL2k5 Report Server/service

How do you uninstall SQL 2k5 report service/server? Thanks.

View Replies View Related

Err: Report Server Windows Service (MSSQLSERVER)

Hi
I am in weired move kindly help me out..I created report using sql server 2005 Reporting services..At one stage it is working fine with proper parameter but due to bad input parameter my report goes in hang mode..so i went to my DB server and restart my reporting service and then MSSQLSERVER I dont remember sequence (may be vice versa) now I am not able to get report when i am passing right parameter..I went to google and only I came to know that due to sequence of restart of services will cause this error..

error like..Application error:
Report Server Windows Service (MSSQLSERVER) cannot connect to the report server database.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

Syste error:
The SQL Server Integration Services service failed to start due to the following error:
The service did not respond to the start or control request in a timely fashion.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

Kindly help me out.

T.I.A

View Replies View Related

Report Server Windows Service (MSSQLSERVER)

This error is being displayed in the eventlog every minute.  Any ideas on what it is referring too?  I reviewed some posts but most point to specific problems of report server not running, or receiving this error during a run.  We are receiving no errors at all.  However this is jamming up the event viewer to make troubleshooting other issues very diffucult.

 

Event Type: Error
Event Source: Report Server Windows Service (MSSQLSERVER)
Event Category: Management
Event ID: 107
Date:  3/23/2007
Time:  8:20:16 AM
User:  N/A
Computer: SPECTRUM_DB2B
Description:
Report Server Windows Service (MSSQLSERVER) cannot connect to the report server database.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

View Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved