.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

ReportingServices will not start after 2008 to 2008R2 upgrade

Posted By:      Posted Date: September 25, 2010    Points: 0   Category :Sql Server

Hello, A server was recently upgraded to 2008R2 from 2008. Before upgrade reportingservices was running. After upgrade, I cannot start ReportingServices from rsconfig, I receive this 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)

 If I look into the Windows Application log I see this error.

Service cannot be started. System.Exception: Default appdomain failed to initialize.
   at Microsoft.ReportingServices.Library.ServiceAppDomainController.Start()
   at Microsoft.ReportingServices.Library.ReportService.OnStart(String[] args)
   at System.ServiceProcess.ServiceBase.ServiceQueuedMainCallback(Object state)

Any idea where to look at? Thanks

Thanks/Regards, Philippe Cand

View Complete Post

More Related Resource Links

SQL 2008 eval expired, ran maintenance Edition upgrade but still can't start services


We unknowingly installed a MSDN evaluation copy of SQL 2008 on a production server.  The evaluation period expired and we're no longer able to access the database.  We have purchased SQL 2008 and have run the Maintenence Edition Upgrade, it completed successfully but the SQL services will not start, event logs for the various SQL services reference 'evaluation period has expired'.  We have modified the CommonFiles DWORD value to 3 in the HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\100\ConfiguratioState key as noted in other posts and tried rerunning the the upgrade. We've also tried running the install on just the shared tools as referenced on another post, the install ran successfully but still not allowing the SQL services to start.

We don't want to lose our database if at all possible.  Any assistance is greatly appreciated.

SQL 2008 SP2 succefull but instance start fails - Script level upgrade for database 'master' faile


after installing SP2 instance starts and stops with error:

Script level upgrade for database 'master' failed because upgrade step 'sqlagent100_msdb_upgrade.sql' encountered error 5831, state 1, severity 16. This is a serious error condition which might interfere with regular operation and the database will be taken offline. If the error happened during upgrade of the 'master' database, it will prevent the entire SQL Server instance from starting. Examine the previous errorlog entries for errors, take the appropriate corrective actions and re-start the database so that the script upgrade steps run to completion.

Already tried without success:
- enabled SA account (was disabled) http://support.microsoft.com/kb/960781/en-us
- uninstalled SP2 -> other error, but same problems with running the script



VS Studio WorkFlow Failed on Start in MOSS 2007 ON Windows Server 2008 64 Bit


I have created a sequential sharepoint workflow in WSP Builder in my Sharepoint Server and Deployed it.

But the workflows says Failed on start and retrying ans stops there forever says couldn't start the workflow.

I repaired .NET Framework 3.5sp1 installed

 tried this

 1. I tried again, in C Prompt:  Lodctr "c:\Windows\Microsoft.Net\Framework\v3.0\Windows Workflow Foundation\perfcounters.ini"  it says initiation file cannot be found

2   i again tried this C prompt Lodctr /R "c:\Windows\Microsoft.Net\Framework\v3.0\Windows Workflow Foundation\perfcounters.ini"

it says reloaded  from the system restored

i am still getting the same error.

When i manually go to my  C:\Windows\Microsoft.NET\Framework\v3.0\Windows Workflow Foundation i can see a folder for SQL that's it nothing more than that..

I dont know what is happening i am trying it from 2 days and still no solution.

any ideas would be real great help for me.

My system is 64 bit , Window server 2008, MOSS SP2, Visual Studio 2008 Version 9.0.30729.

.Net Framework 3.5 sp1

and WSP builder the one from Codeplex for 64 bit machines

SQL 2008 Upgrade Replication failure

we upgraded to Sql 2008 standard edition last night from 2000 and our replication is now failing, cannot delete it or enter new ones.   I found one article saying the following stored procedures need to be run to upgrade the replcation:   exec sp_vupgrade_replication  exec sp_vupgrade_repl_metadata   however the first one throws and error and the second one seems not to exists.  does anyone have any insight into this. or how to delete the replications?   the error from the stored proc sp_vupgrade_replication  is :   Upgrading subscription settings and system objects in database [SoxAuditSystem]. Attempting to copy article resolvers from SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10.MSSQLSERVER\Replication\ArticleResolver Msg 25026, Level 16, State 1, Procedure sp_registercustomresolver, Line 82 The proc sp_registercustomresolver cannot proceed because it is not run in the context of the distribution database, or the distribution database is not properly upgraded.  

Upgrade SQL server 2008 R2 from Evaluation Edition to Enterprise Edition

Hello SQL Support group, I have SQl server 2008 R2 installed on a Win 2003 R2 and it is for our SharePoint and Project server 2007 environment. Today I noticed that we have only 75 days left! Seems like we installed it on evaluation mode. Here what we have on Helpàabout : Microsoft SQL Server Management Studio Complete (expires in 75 days)    10.50.1352.12 We do have MSDN account, and we have the KEY that comes with the SQL server 2008 R2 enterprise. We would like to assign the key to our SQl server ( we want to have enterprise edition). It is in a production environment now. I would like to know how we can do it  with minimum of down time. I found this link: http://blogs.technet.com/b/sqlman/archive/2010/03/16/sql-server-2008-upgrading-to-standard-enterprise-edition-from-evaluation-edition.aspx On the internet, but doesn’t say anything that we are losing any data after upgrade or not. Please let us know the best way to assign the key, and if it has any impact in our data. Thanks Bahram  

Why upgrade is required from SQL Server 2000 to SQl Server 2008

Hi all Can some body share with information about "Why upgrade is required from SQL Server 2000 to SQl Server 2008?"   This question was raised by my Boss why upgrade is required.   I stared saying   My: there is no more   support for SQL Server 2000 from Microsoft   Boss: what you will do  as DBA, Why Required Microsoft support   My: 2008 having very good features where 2000 not have...like Compression, resource governing. .Etc..   Boss: do you mean Database backup compression take full backup and compresse it using ZIP   Finally He (Boss) told me that give document proof why I have go for SQL Server 2008 and what down time you required?   Some body help me why really SQLServer 2008 is required and what are benefits   I have a link; please provide your greatest ideas so that I can convince my Boss.   http://www.mssqltips.com/tip.asp?tip=1462   share your greate Ideas please....   Thanks in Advance     SNIVAS

sql server 2008 - sqlserver(mssqlserver) services can't start

Sorry i need help, i have instal and reinstal sql 2008 over and over but always failed the problem is the services can't start and when i cek error log this written: http%3a%2f%2fgo.microsoft.com%2ffwlink%3fLinkId%3d20476%26ProdName%3dMicrosoft%2bSQL%2bServer%26EvtSrc%3dsetup.rll%26EvtID%3d50000%26ProdVer%3d10.0.1600.22%26EvtType%3d0xE53883A0%400xBE03358B%401306%4024

SQL Server 2008 Agent Fails to start in a Win 2008 Cluster

When I try to bring SQLAGENT Online, I get the following errors: EventID:53 [sqagtres] StartResourceService: Failed to start SQLSERVERAGENT service.  CurrentState: 1 [sqagtres] OnlineThread: ResUtilsStartResourceService failed (status 435) [sqagtres] OnlineThread: Error 435 bringing resource online.   I just did a fresh SQL Cluster install as well.  When I installed the cluster, the service account was good to go.  I cant figure out what is going on.  SQL Server Engine starts fine.  Any ideas?

Upgrade to SQL 2008 R2 Enterprise fails

Trying to upgrade one of my SQL 2008 SP1 Enterprise (v 10.0.2531.0) edition to SQL 2008 R2 Enterprise, the OS is Windows Server 2008 (x64) SP1.  The process fails with no explanation beyond this:   Description:   SQL Server 2008 R2 Setup has encountered an error.   Problem signature:   Problem Event Name: SQL100MSI   Problem Signature 01: 10.50.1600.1   Problem Signature 02: Unknown   Problem Signature 03: SqlSupport.msi   Problem Signature 04: 0x162A16FE   Problem Signature 05: 0x1645   Problem Signature 06: Install_SqlSupport   OS Version:      6.0.6001.   Locale ID:           1033   Additional information about the problem:   LCID:    1033 I tried running the installation through Remote Desktops with Administrator login and also through Remote Desktop Connection with Administrator login, I got the same error each time.  There are no users connected to the database.  The installation is English. I have viewed the thread on Connect and it is not applicable as I'm running an English installation, not Italian and I am using the Administrator login. I saw another on another thread where they

SQL 2008 R2 clustered instance does not start in single user mode

Hi I am testing the startup of a SQL 2008 R2 clustered instance (Windows 2008 R2) using single user mode but it fails with : Error: 17058, Severity: 16, State: 1. initerrlog: Could not open error log file ''. Operating system error = 3(The system cannot find the path specified.) - I am running the following command from the default sql installation : C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQL01\MSSQL\Binn>sqlservr.exe -c -m -s SQL01 - The cluster service on the passive node has been shutdown. - The SQL Server and SQL Agent services have been set to offline in Failover Cluster Manager. Any assistance greatly appreciated. Regards, PK    

Moving a Copy of SQL Report Server 2005 and Upgrade to 2008

Hello, We have SQL 2005 Report Server in a Windows 2003 64 bit server box. We want to create a copy of this report server database somewhere in the domain, so that we can access it for a different purpose. My question is, will there be any complications with this? I'm thinking about the encryption key that's needed to access the database. If we are successful with this, we might also want to upgrade to SQL 2008. Thanks for your help,   Elizabeth K.

After repair windows,I cannot start sql server 2008.help me please!

I cannot start sql server 2008 after repair windows. I open even log (control panel >> administration >> event viewer) find error log with sql server it notice Could not open error log file 'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Log\ERRORLOG'. Operating system error = 5(failed to retrieve text for this error. Reason: 1815) I open file ERRORLOG.5 but I don't understand where I should fix?  I copy errorlog.5 on this webboard  Please help me! thank you 2010-08-20 08:16:52.89 Server      Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (Intel X86)  Jul  9 2008 14:43:34  Copyright (c) 1988-2008 Microsoft Corporation  Standard Edition on Windows NT 5.1 <X86> (Build 2600: Service Pack 3) 2010-08-20 08:16:52.89 Server      (c) 2005 Microsoft Corporation. 2010-08-20 08:16:52.89 Server      All rights reserved. 2010-08-20 08:16:52.89 Server      Server process ID is 2248. 2010-08-20 08:16:52.89 Server      Authentication mode is MIXED. 2010-08-20 08:16:52.89 Server      Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Log\ERRORLOG'. 2010-08-20 08:16:52.89 Server    &nbs

SQL 2008 Upgrade Standard to Enterprise: Fail

I'm trying to upgrade an existing SQL Server 2008 SP1 Standard Edition to Enterprise.  Running the enterprise edition maintenance->Upgrade Edition wizard first got me the dreaded "Invoke or BeginInvoke cannot be called on a control until the window handle has been created." Eventually, I found an entry on Connect that mentioned closing all other windows and ensuring that the installer has the focus and this got me past that error.  Now that I can run the edition upgrade through to successful completion, it's not actually doing anything. Edition still reports as "Standard" and enterprise features such as "Compress Backups" do not work. I've run the upgrade twice and restarted the system to no effect. Before I do a "Rip and Replace" does anyone have any ideas on how to actually get the edition upgrade to work? Steve G. OS:    Windows Server 2008 R2 DB:    Product: SQL Server Standard Edition (64-bit)   Version: 10.0.2531.0 P.S. Just in case someone asks, yes, I did follow the instructions located here.

upgrade to SQL server 2008 SP1 x64 IA

guys, I have upgraded my Databases from SQL Server 2000 SP4 to SQL Server 2008 SP1 x64 on Itanuim and used most common best practices but my queries was running on 2000 in shap now running very slow in SQL 2008 keeping in mind my current HW is very good and can't even comparing with 2000 server HW pls Advice , thanks in advance

Upgrade from SQL 2005 EXPRESS to SQL 2008 EXPRESS

Hello friends, I restored My database in SQL 2005 of size more than 4 GB but it creates problem when i save picture (image data) in database.i.e i can't save it.So i searched for that problem and came to know that SQL Express 2005 has database size limit of 4 GB. i upgraded it to SQL EXPRESS 2008 and restored it to there.Still it has the same prblem means i can't able to save data.. So what may be the problem. Thanks in advance. RAHUL PATEL. rahulpatel112@live.in

SQL Server 2008 express SQL Server Service won't start

Could really use some help. Am running XP Pro SP3.  Had 2005 Express running fine previously.  Installed 2008 Express but cannot get the SQL Server service to start.  SQL Server Agent does start though.  In log (below) it seems to be trying to access an E:\ drive that doesn't exist (did default install to C:\Program Files) - plus other issues.  Have 5gig+ free, so not sure why it's saying not enough space.  Have RTFMd the problem for a whole day with no luck.  Any advice much appreciated.   Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (Intel X86)  Apr  2 2010 15:53:02  Copyright (c) Microsoft Corporation Express Edition with Advanced Services on Windows NT 5.1 <X86> (Build 2600: Service Pack 3) (Hypervisor)   Error: 17054, Severity: 16, State: 1. The current event was not reported to the Windows Events log. Operating system error = 1502(The event log file is full.). You may need to clear the Windows Events log if it is full. (c) Microsoft Corporation. All rights reserved. Server process ID is 4988. Authentication mode is WINDOWS-ONLY. Logging SQL Server messages in file 'c:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\Log\ERRORLOG'. This instance of SQL Server last reported using a process ID of 3232 at 9/4/2010 9:36:12 AM (local) 9/4/2010 1:36:12 PM (UTC). This is an informational

Upgrade SQL Server 2000 to SQL Server 2008 in Cluster--Recomendations

Hi all I have   6 cluster environments and 10 standalone servers and mix  of  32 bit  64 bit. As I know In place Upgrade not possible SQL2k 32 bit to SQL2008 64 bit. What I want to know is……… 1. If I purchase SQL Server 2008 Ent edition that will have both 64 bit and 32 bit edition or I have purchase separately ? 2. How to do side by side upgrade in Cluster environment I mean I can’t ask my company to provide other cluster to do side by side upgrade. If I do installation in same cluster machines, I can’t provide same Instance name for SQL Server 2008 Instance.hance it is very difficulty for application connectivity Please some body provides me best approach to drive in Upgrade from SQL2k to SQL2008. Thanks in Advance      SNIVAS
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend