October 23, 2012 at 4:39 am
Hi All,
Really in big trouble I am. This is new prod box and already missed my SLA. I unistall SQL serevr default instance only DB engine and thought let RS be there after installtion of new instance I will link the RS to it.
Now the issue is after installation of this new instance Iam not able to start the RS. which was failing with below error. Then I tried to remove it from control pannel add/remove program the it is not listed in the instance as i have already unistall the old one.
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)
so after googling I found, I removed registry for HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\Instance Name\RS and from services and tried to install the new RS but that it fails with the following error
MSI (s) (54:BC) [11:06:42:728]: Machine policy value 'TransformsSecure' is 1
MSI (s) (54:BC) [11:06:42:729]: Machine policy value 'DisableUserInstalls' is 0
MSI (s) (54:BC) [11:06:42:729]: Specified instance {2453DBC8-ACC4-4711-BD03-0C15353AA3D8} via transform :InstID01.mst;:InstName01.mst is already installed. MSINEWINSTANCE requires a new instance that is not installed.
MSI (s) (54:BC) [11:06:42:729]: MainEngineThread is returning 1639
MSI (s) (54:E0) [11:06:42:730]: User policy value 'DisableRollback' is 0
MSI (s) (54:E0) [11:06:42:730]: Machine policy value 'DisableRollback' is 0
MSI (s) (54:E0) [11:06:42:730]: Incrementing counter to disable shutdown. Counter after increment: 0
MSI (s) (54:E0) [11:06:42:731]: Note: 1: 1402 2: HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\Installer\Rollback\Scripts 3: 2
MSI (s) (54:E0) [11:06:42:731]: Note: 1: 1402 2: HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\Installer\Rollback\Scripts 3: 2
MSI (s) (54:E0) [11:06:42:732]: Note: 1: 1402 2: HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\Installer\InProgress 3: 2
MSI (s) (54:E0) [11:06:42:732]: Note: 1: 1402 2: HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\Installer\InProgress 3: 2
MSI (s) (54:E0) [11:06:42:732]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (s) (54:E0) [11:06:42:732]: Restoring environment variables
MSI (c) (5C:1C) [11:06:42:734]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (c) (5C:1C) [11:06:42:735]: MainEngineThread is returning 1639
=== Verbose logging stopped: 10/23/2012 11:06:42 ===
Please help.
Cheers,
Got an idea..share it !!
DBA_Vishal
October 23, 2012 at 5:12 am
Your post is a little confusing. In the first part you sound like you uninstalled the database engine but left Reporting Services, but in the second part you are deleting a registry key that is pointing to a Reporting Services instance. Why?
Do you have backups of your databases and report definitions? I hope you backed up the registry before deleting that key, because you may need to restore it.
Joie Andrew
"Since 1982"
October 26, 2012 at 4:19 am
Yes I have backedup the registry key.
1. I did unintall DB engine and reinstall it , this was done to change the collation. After reinstalling the DB Engine I am not able to configure reporting service. The service does not come up.
2. I tried to remove the existing RS thinking it might be linked to the earlier default instance, but not able to find it in the Add / remove progra, --> remove program.
3. I tried to add the feature RS to the new existing new default instance but The RS installation fails with error I have shared.
Any input.
Cheers,
Got an idea..share it !!
DBA_Vishal
October 26, 2012 at 5:00 am
Can you share the setup logs from when you tried to install a new instance of SSRS?
Joie Andrew
"Since 1982"
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply