Inserting Null Value: setup

Showing posts with label setup. Show all posts

Friday, March 30, 2012

Install reporting services after SQL sp2

Hello,
our customer tried to update his existing SQL Server 64 Bit Enterprise
Edition with reporting services to SP2. During Setup there was an error with
the reporting services. So the customer decided to uninstall the reporting
services and applied SP2 successfully after that.
Now he needs the reporting services for a new application. Can i install the
reporting services from the original media and then upgrade that reporting
services installation to sp2?What do i have to take care of?
My plan was to install reporting services via software. Change SQL Server
Installation and add reporting services.
I tried that but the setup then comes up with the warning that there is a
version change. I think that is because the sql server has another
patchlevel than the original installation media. Can i ignore that?
thanks in advance
thomasHi Thomas
Although I haven't tried what you are doing, there is not really any
alternative as there is no slipstreamed releases of SQL Server that will go
straight in as SP2, so I guess you have to ignore the error and continue. It
is probably better to install this by hand!
John
"Thomas Oeser" wrote:
> Hello,
> our customer tried to update his existing SQL Server 64 Bit Enterprise
> Edition with reporting services to SP2. During Setup there was an error with
> the reporting services. So the customer decided to uninstall the reporting
> services and applied SP2 successfully after that.
> Now he needs the reporting services for a new application. Can i install the
> reporting services from the original media and then upgrade that reporting
> services installation to sp2?What do i have to take care of?
> My plan was to install reporting services via software. Change SQL Server
> Installation and add reporting services.
> I tried that but the setup then comes up with the warning that there is a
> version change. I think that is because the sql server has another
> patchlevel than the original installation media. Can i ignore that?
> thanks in advance
> thomas
>

install Reporting service problem on SQL 2005 Express advanced Help please

Hi All,
I try to install reporting services with a french version of SQL 2005
Express Advanced on W2003 std SP1
Install of SQL2005 OK
When setup programm reach reporting service installation, i get an error
message( in french) :
"Le programme d'installation de SQL Server n'a pas pu récupérer le nom du
certificat SSL"
in English from my own translation : "SQL server installation program has
not been able to find SSL certificate"
This stop installation
detail of error give :
Linkid 20476
Nom du produit Microsoft sql Server
Version du Produit 9.00.2047.00
Source du mesage setup.rll
ID du message 29561
evtType
sqlca\sqlrsguica.cpp@.CheckRSSetupRequirements@.CheckRSSetupRequirements@.x7379
I try to install anyway reporting services via RSConfigTool
Install seems ok . Reporting services start ok
but http://mydomain/reports/Pages/folder.aspx give : Red cross Error
and message : "The request failed with HTTP status 400: Bad Request."
That we can find in C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting
Services\LogFiles:
----
w3wp!ui!1!17/02/2007-12:02:13:: e ERROR: The request failed with HTTP status
400: Bad Request.
w3wp!ui!1!17/02/2007-12:02:13:: e ERROR: HTTP status code --> 500
--Details--
System.Net.WebException: The request failed with HTTP status 400: Bad
Request.
at
Microsoft.SqlServer.ReportingServices2005.RSConnection.GetSecureMethods()
at
Microsoft.ReportingServices.UI.Global.RSWebServiceWrapper.GetSecureMethods()
at
Microsoft.SqlServer.ReportingServices2005.RSConnection.IsSecureMethod(String
methodname)
at
Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection()
at
Microsoft.ReportingServices.UI.ReportingPage.EnsureHttpsLevel(HttpsLevel
level)
at Microsoft.ReportingServices.UI.ReportingPage.ReportingPage_Init(Object
sender, EventArgs args)
at System.EventHandler.Invoke(Object sender, EventArgs e)
at System.Web.UI.Control.OnInit(EventArgs e)
at System.Web.UI.Page.OnInit(EventArgs e)
at System.Web.UI.Control.InitRecursive(Control namingContainer)
at System.Web.UI.Page.ProcessRequestMain(Boolean
includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
w3wp!ui!1!17/02/2007-12:02:13:: e ERROR: Exception in ShowErrorPage:
System.Threading.ThreadAbortException: Thread was being aborted.
at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean
preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String
errMsg) at at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean
preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String
errMsg)
-----
Any idea '
MERCI beaucoup
Philippe
C.I.A ITI work around by desintalling IIS et re_install.
In fact i had installed a certificate via selfssl prior install reporting
services, as i have no option to remove this cerificate, the only way i
found, was to uninstall IIS
Philippe
"Philippe" <ph.boussaroque@.Espace-NTIC.com> a écrit dans le message de news:
ecmCyToUHHA.1364@.TK2MSFTNGP06.phx.gbl...
> Hi All,
> I try to install reporting services with a french version of SQL 2005
> Express Advanced on W2003 std SP1
> Install of SQL2005 OK
> When setup programm reach reporting service installation, i get an error
> message( in french) :
> "Le programme d'installation de SQL Server n'a pas pu récupérer le nom du
> certificat SSL"
> in English from my own translation : "SQL server installation program has
> not been able to find SSL certificate"
> This stop installation
> detail of error give :
> Linkid 20476
> Nom du produit Microsoft sql Server
> Version du Produit 9.00.2047.00
> Source du mesage setup.rll
> ID du message 29561
> evtType
> sqlca\sqlrsguica.cpp@.CheckRSSetupRequirements@.CheckRSSetupRequirements@.x7379
> I try to install anyway reporting services via RSConfigTool
> Install seems ok . Reporting services start ok
> but http://mydomain/reports/Pages/folder.aspx give : Red cross Error
> and message : "The request failed with HTTP status 400: Bad Request."
> That we can find in C:\Program Files\Microsoft SQL
> Server\MSSQL.2\Reporting Services\LogFiles:
> ----
> w3wp!ui!1!17/02/2007-12:02:13:: e ERROR: The request failed with HTTP
> status 400: Bad Request.
> w3wp!ui!1!17/02/2007-12:02:13:: e ERROR: HTTP status code --> 500
> --Details--
> System.Net.WebException: The request failed with HTTP status 400: Bad
> Request.
> at
> Microsoft.SqlServer.ReportingServices2005.RSConnection.GetSecureMethods()
> at
> Microsoft.ReportingServices.UI.Global.RSWebServiceWrapper.GetSecureMethods()
> at
> Microsoft.SqlServer.ReportingServices2005.RSConnection.IsSecureMethod(String
> methodname)
> at
> Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection()
> at
> Microsoft.ReportingServices.UI.ReportingPage.EnsureHttpsLevel(HttpsLevel
> level)
> at
> Microsoft.ReportingServices.UI.ReportingPage.ReportingPage_Init(Object
> sender, EventArgs args)
> at System.EventHandler.Invoke(Object sender, EventArgs e)
> at System.Web.UI.Control.OnInit(EventArgs e)
> at System.Web.UI.Page.OnInit(EventArgs e)
> at System.Web.UI.Control.InitRecursive(Control namingContainer)
> at System.Web.UI.Page.ProcessRequestMain(Boolean
> includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
> w3wp!ui!1!17/02/2007-12:02:13:: e ERROR: Exception in ShowErrorPage:
> System.Threading.ThreadAbortException: Thread was being aborted.
> at System.Threading.Thread.AbortInternal()
> at System.Threading.Thread.Abort(Object stateInfo)
> at System.Web.HttpResponse.End()
> at System.Web.HttpServerUtility.Transfer(String path, Boolean
> preserveForm)
> at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String
> errMsg) at at System.Threading.Thread.AbortInternal()
> at System.Threading.Thread.Abort(Object stateInfo)
> at System.Web.HttpResponse.End()
> at System.Web.HttpServerUtility.Transfer(String path, Boolean
> preserveForm)
> at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String
> errMsg)
> -----
> Any idea '
> MERCI beaucoup
> Philippe
> C.I.A IT
>
>

Wednesday, March 28, 2012

install problems

My logs give the following:

Microsoft SQL Server 2005 Setup beginning at Sat Apr 07 19:09:17 2007
Process ID : 5896
g:\0c5b65e1ae1dee88a7a4639902\setup.exe Version: 2005.90.2047.0
Running: LoadResourcesAction at: 2007/3/7 19:9:17
Complete: LoadResourcesAction at: 2007/3/7 19:9:17, returned true
Running: ParseBootstrapOptionsAction at: 2007/3/7 19:9:17
Loaded DLL:g:\0c5b65e1ae1dee88a7a4639902\xmlrw.dll Version:2.0.3609.0
Complete: ParseBootstrapOptionsAction at: 2007/3/7 19:9:17, returned true
Running: ValidateWinNTAction at: 2007/3/7 19:9:17
Complete: ValidateWinNTAction at: 2007/3/7 19:9:17, returned true
Running: ValidateMinOSAction at: 2007/3/7 19:9:17
Complete: ValidateMinOSAction at: 2007/3/7 19:9:17, returned true
Running: PerformSCCAction at: 2007/3/7 19:9:17
Complete: PerformSCCAction at: 2007/3/7 19:9:17, returned true
Running: ActivateLoggingAction at: 2007/3/7 19:9:17
Complete: ActivateLoggingAction at: 2007/3/7 19:9:17, returned true
Delay load of action "DetectPatchedBootstrapAction" returned nothing. No action will occur as a result.
Action "LaunchPatchedBootstrapAction" will be skipped due to the following restrictions:
Condition "EventCondition: __STP_LaunchPatchedBootstrap__5896" returned false.
Running: PerformSCCAction2 at: 2007/3/7 19:9:17
Loaded DLL:J:\WINDOWS\system32\msi.dll Version:3.1.4000.3959
Product "{982DB00A-9C4E-436B-8707-18E113BAA44C}" versioned 9.00.1116 is not compatible with current builds of SQL Server.Expected at least version: 9.00.1399.00
The Product Name is "Microsoft SQL Server 2005 Analysis Services CTP"
Product "{63A5DC0D-1EDD-4D69-8F31-87FAEB1F7084}" versioned 9.00.1116 is not compatible with current builds of SQL Server.Expected at least version: 9.00.1399.00
The Product Name is "Microsoft SQL Server 2005 Notification Services CTP"
Product "{E0A41F96-7231-4AE8-A654-EEB34F935462}" versioned 9.00.1116 is not compatible with current builds of SQL Server.Expected at least version: 9.00.1399.00
The Product Name is "Microsoft SQL Server 2005 Data Transformation Services CTP"
Loaded DLL:J:\WINDOWS\system32\msi.dll Version:3.1.4000.3959
Error: Action "PerformSCCAction2" threw an exception during execution.
Return Code: 70032
Message displayed to user
SQL Server 2005 Setup has detected incompatible components from beta versions of Visual Studio, .NET Framework, or SQL Server 2005. Use Add or Remove Programs to remove these components, and then run SQL Server 2005 Setup again. For detailed instructions on uninstalling SQL Server 2005, see the SQL Server 2005 Readme.

Class not registered.
Delay load of action "UploadDrWatsonLogAction" returned nothing. No action will occur as a result.
Message pump returning: 70032

That is the core log;

When I type from the command line msiexec /x {E0A41F96-7231-4AE8-A654-EEB34F935462}

I get: am xmlrl error, fail to load xmlrl.dll, which I do not have in windows\system32

Please tell me how I can fix this problem?

Thank you

Dee

r u sure that there is no beta version of SQL SErver, visaul studio or .net framework on your machine. If exists , remove that and then install sql server

Madhu

|||

I removed all .net programs, sql, and even went through the registry. I even went through tin windows\installer and did some deletes.

I still keep getting the same message.

Dee

|||

Perhaps one of these articles will provide the clue you need. (You may wish to try the 'Clean Up Tool' first.)

Remove -Error message when you install SQL Server 2005: "Beta components detected"
http://support.microsoft.com/?kbid=919394

Remove -How do I remove previous versions of SQL Server 2005 / Whidbey?
http://www.aspfaq.com/sql2005/show.asp?id=15

Remove -How to manually remove SQL Server 2000 default, named, or virtual instance
http://support.microsoft.com/?kbid=290991

Remove -How to uninstall an instance of SQL Server 2005 manually
http://support.microsoft.com/?kbid=909967

Remove -How to Uninstall MSDE
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q290991

Remove -How to Uninstall SQL Server 2005 Beta
http://go.microsoft.com/?linkid=1396133

Remove -How to uninstall SQL Server Management Studio
http://support.microsoft.com/default.aspx?scid=kb;EN-US;909953

Remove -How to use the Add or Remove Programs item in Control Panel to add
or remove components for stand-alone installations and clustered
installations of SQL Server 2005 (KB: 922670)
http://support.microsoft.com/default.aspx?scid=kb;EN-US;922670

Remove -How to: Uninstall SQL Server Express
http://msdn2.microsoft.com/en-us/library/ms143505.aspx

Remove -The error is: Fatal error during installation"
http://support.microsoft.com/?kbid=919945

Remove -Uninstall Applications NOT in Install/Remove Programs List
http://blogs.msdn.com/astebner/archive/2005/10/30/487096.aspx

Remove –Windows Installer Clean-Up Tool
http://download.microsoft.com/download/E/9/D/E9D80355-7AB4-45B8-80E8-983A48D5E1BD/msicuu2.exe

|||

The log indicates that you have several pre-release products installed, specifically:

Product "{982DB00A-9C4E-436B-8707-18E113BAA44C}" versioned 9.00.1116 is not compatible with current builds of SQL Server.Expected at least version: 9.00.1399.00
The Product Name is "Microsoft SQL Server 2005 Analysis Services CTP"
Product "{63A5DC0D-1EDD-4D69-8F31-87FAEB1F7084}" versioned 9.00.1116 is not compatible with current builds of SQL Server.Expected at least version: 9.00.1399.00
The Product Name is "Microsoft SQL Server 2005 Notification Services CTP"
Product "{E0A41F96-7231-4AE8-A654-EEB34F935462}" versioned 9.00.1116 is not compatible with current builds of SQL Server.Expected at least version: 9.00.1399.00
The Product Name is "Microsoft SQL Server 2005 Data Transformation Services CTP"

These will all need to be removed prior to installing any RTM or post-RTM bits. Check for the Microsoft SQL Server 2005 entry in Add/Remove programs and remove it from there. If that does not exist, try removing the components manually using:

msiexec /x {product code}

Let us know how this turns out.

Mike

|||

As stated above I tried msiexec /x productcode as well as msiexec /uninstall and the name of the product. I keep getting an error regarding xmlrl.dll missing.

Dee

|||

I am still waiting for some help with this problem.

Thank you

Dee

|||

There are a few different solutions for removing SQL in this KB article, http://support.microsoft.com/default.aspx/kb/909967. See if this helps. Also, could you provide the exact text of the error you are getting when you attempt to run the msiexe /x command?

Mike

Addendum: I talked this over with the support team and they indicate that the KB article should solve you're problem, specifically the section about needing to install the setup support files that reads as below. One point to be warry of, you need to install SqlSupport.msi from the package that you originally installed the pre-release product from, hopefully you saved that.

Reinstall the Microsoft SQL Server Setup Support Files component (SqlSupport.msi) before you uninstall each component in the instance.

Temporarily refcount the SqlSupport.msi file to itself. To do this, follow these steps:

Obtain the GUID for the Microsoft SQL Server Setup Support Files component. To obtain the GUID, follow steps 1 and 2 from the "If you experience problems" section.

Use Registry Editor to create or to modify the following registry key with these values:

Key Name: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\90\Bootstrap\MSIRefCount
Value: Uninstall
Type: REG_SZ
Data: {11111111-1111-1111-1111-111111111111},{GUID}

Note GUID is a placeholder for the GUID of the SQL Server support files. For example, the GUID of the English x86 SQL Server support files is as follows:

Data: {11111111-1111-1111-1111-111111111111},{53F5C3EE-05ED-4830-994B-50B2F0D50FCE}

|||

I did not keep the original software that I did the install with. I used the SQL Server 2005 CTP. I am trying to use something called ttools.exe and getting no where with it eithers.

So far I have removed everthing but

Microsoft SQL Server 2005 Setup beginning at Wed Apr 11 14:36:59 2007
Process ID : 5796
g:\1b28209325f0716aec0cbbe1\setup.exe Version: 2005.90.3042.0
Running: LoadResourcesAction at: 2007/3/11 14:36:59
Complete: LoadResourcesAction at: 2007/3/11 14:36:59, returned true
Running: ParseBootstrapOptionsAction at: 2007/3/11 14:36:59
Loaded DLL:g:\1b28209325f0716aec0cbbe1\xmlrw.dll Version:2.0.3609.0
Complete: ParseBootstrapOptionsAction at: 2007/3/11 14:36:59, returned true
Running: ValidateWinNTAction at: 2007/3/11 14:36:59
Complete: ValidateWinNTAction at: 2007/3/11 14:36:59, returned true
Running: ValidateMinOSAction at: 2007/3/11 14:36:59
Complete: ValidateMinOSAction at: 2007/3/11 14:36:59, returned true
Running: PerformSCCAction at: 2007/3/11 14:36:59
Complete: PerformSCCAction at: 2007/3/11 14:36:59, returned true
Running: ActivateLoggingAction at: 2007/3/11 14:36:59
Complete: ActivateLoggingAction at: 2007/3/11 14:36:59, returned true
Delay load of action "DetectPatchedBootstrapAction" returned nothing. No action will occur as a result.
Action "LaunchPatchedBootstrapAction" will be skipped due to the following restrictions:
Condition "EventCondition: __STP_LaunchPatchedBootstrap__5796" returned false.
Running: PerformSCCAction2 at: 2007/3/11 14:36:59
Product "{982DB00A-9C4E-436B-8707-18E113BAA44C}" versioned 9.00.1116 is not compatible with current builds of SQL Server.Expected at least version: 9.00.1399.00
The Product Name is "Microsoft SQL Server 2005 Analysis Services CTP"
Error: Action "PerformSCCAction2" threw an exception during execution.
Return Code: 70032
Message displayed to user
SQL Server 2005 Setup has detected incompatible components from beta versions of Visual Studio, .NET Framework, or SQL Server 2005. Use Add or Remove Programs to remove these components, and then run SQL Server 2005 Setup again. For detailed instructions on uninstalling SQL Server 2005, see the SQL Server 2005 Readme.

Class not registered.
Delay load of action "UploadDrWatsonLogAction" returned nothing. No action will occur as a result.
Message pump returning: 70032

I get the following when I try to use msiexec /x

This action is only valid for products currently installed.

Dee

|||

Is there any one out there who can help with this problem. I do not want to re-install Windows 2003 server and I need to take my courses.

Dee

|||

You may be in one of those situations where the effort to wipe the disk and start over is less than the cummulative time and effort required to solve the problem.

It's like a go/no go decision point upon application rollout. There has to be a point where management makes the rollback decision EVEN though the developers keep saying it will be just a couple more minutes. And then a couple more, etc.

|||

Don't want to re-install have too many programs and web sites on the system.

Dee

|||

I suggest then, that you review the list of resources I (and Michael) previously posted, and be extremely meticulous removal of all vestiges of the previous SQL Server 2005 and Visual Studio 2005 (including beta and CTP) products. Something is being missed...

And I agree, it 'should not' be so darn difficult. But in your situation, it seems that is the case, you have are chosing to live with it.

|||

I went through Michaels entire post most of the tools I have already, the rest I tried. Neither worked. But now I am getting:

Microsoft SQL Server 2005 Setup beginning at Thu Apr 12 11:22:16 2007
Process ID : 5976
g:\583d966eff02c53f4a\setup.exe Version: 2005.90.3042.0
Running: LoadResourcesAction at: 2007/3/12 11:22:16
Complete: LoadResourcesAction at: 2007/3/12 11:22:16, returned true
Running: ParseBootstrapOptionsAction at: 2007/3/12 11:22:16
Loaded DLL:g:\583d966eff02c53f4a\xmlrw.dll Version:2.0.3609.0
Complete: ParseBootstrapOptionsAction at: 2007/3/12 11:22:16, returned true
Running: ValidateWinNTAction at: 2007/3/12 11:22:16
Complete: ValidateWinNTAction at: 2007/3/12 11:22:16, returned true
Running: ValidateMinOSAction at: 2007/3/12 11:22:16
Complete: ValidateMinOSAction at: 2007/3/12 11:22:16, returned true
Running: PerformSCCAction at: 2007/3/12 11:22:16
Complete: PerformSCCAction at: 2007/3/12 11:22:16, returned true
Running: ActivateLoggingAction at: 2007/3/12 11:22:16
Complete: ActivateLoggingAction at: 2007/3/12 11:22:16, returned true
Delay load of action "DetectPatchedBootstrapAction" returned nothing. No action will occur as a result.
Action "LaunchPatchedBootstrapAction" will be skipped due to the following restrictions:
Condition "EventCondition: __STP_LaunchPatchedBootstrap__5976" returned false.
Running: PerformSCCAction2 at: 2007/3/12 11:22:16
Product "{982DB00A-9C4E-436B-8707-18E113BAA44C}" versioned 9.00.1116 is not compatible with current builds of SQL Server.Expected at least version: 9.00.1399.00
The Product Name is "Microsoft SQL Server 2005 Analysis Services CTP"
Error: Action "PerformSCCAction2" threw an exception during execution.
Return Code: 70032
Message displayed to user
SQL Server 2005 Setup has detected incompatible components from beta versions of Visual Studio, .NET Framework, or SQL Server 2005. Use Add or Remove Programs to remove these components, and then run SQL Server 2005 Setup again. For detailed instructions on uninstalling SQL Server 2005, see the SQL Server 2005 Readme.

Class not registered.
Delay load of action "UploadDrWatsonLogAction" returned nothing. No action will occur as a result.
Message pump returning: 70032

Dee

|||

Product "{982DB00A-9C4E-436B-8707-18E113BAA44C}" versioned 9.00.1116 is not compatible with current builds of SQL Server.Expected at least version: 9.00.1399.00
The Product Name is "Microsoft SQL Server 2005 Analysis Services CTP"

You STILL have a beta/CTP product installed. It must be removed in order to reinstall SQL Server.