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

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

SQL 2008 R2 setup failover error

Posted By:      Posted Date: September 01, 2010    Points: 0   Category :Sql Server
Hi, I try to setup setup an SQL 2008 R2 failover cluster on two Windows 2008 R2 servers with clustering enabled. In the setup wizard I have selected to install all options. After that the installation process is running, but after 5 minutes I receive an error windows with the tekst below. The following error has accourred: An error occourred during the installation of assembly 'Microsoft.DataTransformationServices.Controls,fileVersion="10.50.1600.1",version='",c ulture="neutral",publicKeyToken="89845DCD8080CC91",prosessorArchitecture="MSIL", The signature or catalog could not be verified or is not valid. In the SQL setup windows I can see that everything is installed exept the Database Engine Services, the SQL Server Replication and Full-Tekst Search Can you give me some advice how to solve this issue. Thanks in advance. Kind Regards, hensl

View Complete Post

More Related Resource Links

SQL Server 2008 Express Setup failure: Unknown Property Error

I am trying to install SQL server 2008 on windows 7 but it returns the following error when almost done with installation: TITLE: SQL Server Setup failure. ------------------------------ SQL Server Setup has encountered the following error: Unknown property. . ------------------------------ BUTTONS: OK ------------------------------   Can someone please assist me with this, I have tried for more than a week to go around it. I have also searched online for solutions but in vain. Looking into the log files, I see these: 2010-09-05 21:04:41 Slp: Running Action: Install_SqlBrowser_Cpu32_Action 2010-09-05 21:04:41 Slp: Target package: "C:\Softwares\Database and Management\SQLEXPRADV_x86_ENU\x86\setup\sqlbrowser.msi" 2010-09-05 21:04:46 Slp: InstallPackage: MsiInstallProduct returned the result code 0. 2010-09-05 21:04:46 Slp: RunMsiCore succeeded. 2010-09-05 21:04:46 Slp: Checkpoint: INSTALL_SQLBROWSER_CPU32_ACTION 2010-09-05 21:04:46 Slp: Completed Action: Install_SqlBrowser_Cpu32_Action, returned True 2010-09-05 21:04:46 Slp: ---------------------------------------------------------------------- 2010-09-05 21:04:46 Slp: Running Action: Install_SqlSqmShared_Cpu32_Action 2010-09-05 21:04:47 Slp: Error: Action "Install_SqlSqmShared_Cpu32_Action" threw an exception during execution. 2010-09-05 21:04:47 Slp: Microsoft.SqlServer.Setup.Chainer.Workflow.ActionExec

Setup error installing SQL 2008 Developer on Windows 7 RTM

When trying to install SQL 2008 on Windows 7 (RTM), I get a dialog after launching setup with:Invoke or BeginInvoke cannot be called on a control until the window handle has been created.I rebooted and tried a second time with same results.The Bootstrap log contains this Detail_LandingPage.txt file.Any ideas?Detail_LandingPage.txt2009-08-09 19:31:00 Slp: Log provider 'Microsoft.SqlServer.Chainer.Infrastructure.LogProviderFile' has been registered2009-08-09 19:31:00 Slp: Log provider 'Microsoft.SqlServer.Chainer.Infrastructure.LogProviderStatus' has been registered2009-08-09 19:31:00 Slp: Reading XML resource 'Microsoft.SQL.Chainer.PackageData.Package.xml'2009-08-09 19:31:00 Slp: Reading schema resource 'Microsoft.SQL.Chainer.Package.Package.xsd'2009-08-09 19:31:01 Slp: Document 'Microsoft.SQL.Chainer.PackageData.Package.xml' validated with schema 'Microsoft.SQL.Chainer.Package.Package.xsd' has been successfuly loaded into datastore path '/Datastore/Package'2009-08-09 19:31:01 Slp: ----------------------------------------------------------------------2009-08-09 19:31:01 Slp: Running Action: ReadProductXML2009-08-09 19:31:02 Slp: Reading XML resource 'Microsoft.SQL.Chainer.Product.Product.xml'2009-08-09 19:31:02 Slp: Reading schema resource 'Microsoft.SQL.Chainer.Product.Product.xsd'2009-08-09 19:31:02 Slp: Document 'Microsoft.SQL.Chainer.Product.Product.xml'

Error occurred while SQL Server 2008 R2 Setup

I already have sql server 2005 running on my computer (Win XP SP2) and I have been trying to install the Sql server 2008 R2 version. (I've downloaded in last week.)   While I'm installing, I got the following msg box : The following eror has occurred: The service did not respond to the start or control request in a timely fashion. Click 'Retry' to retry the failed action, or click 'Cancel' to cancel this action and continue setup.   At that time, Installation progress show "ASConfigAction_install_postmsi_Cpu32". So I assumed something is wrong in SSAS installation.   I just click "Cancel" in the above msg box as I have no choice.   After completed, it show "Failed" in "Analysis Services".   Then I restarted my PC. When I try to start SSAS service manually, I got the following msg box.   The SQL Server Analysis Services (Instance_Name) service failed to start due to the following error:  Error 1053 : The service did not respond to the start or control request in a timely fashion.    Actually I just want to try CUBE in this version. (my deadline is coming friday.)  :(   Please advise & thanks in advance.

Error during SQL Server 2008 setup on windows 7 home premium



I have Windows 7 home Premium on 64 bit machine. I have installed Visual Studio 2008 sucessfully and SQL Server 2008 installer also shows "successful" installation. However when I try to login thru Sql mgmt Studio, I get error " No process is on the other end of the pipe". I checked SQL Server configuration and Named Pipes configuration, that seems all right. When I checked event log, it had following msg:

The Tabular Data Stream (TDS) version 0x730a0003 of the client library used to open the connection is unsupported or unknown. The connection has been closed.

on googling, some of posts suggest to download .Net f/w 2.0 SP1. I downloaded the same from MS site, but on instllation, I get msg "this version is not supported on windows vista".

Please suggest any solution/workaround, i have been struggling with this for sometime now.

thanks in advance


Setup error installing "SQL Server 2008 Developer" on Windows7 (32bit)

I had downloaded SQL Server 2008 Developer from DREAMSPARK.
When i ran the setup, a dialog box said, it has known compatibilty issues and that i'll have to run Service Pack 1 or above, after completing the installation and before running the software.


But the installation doesnt proceed AT ALL when i click Run Program....
It gives the following error:

TITLE: SQL Server Setup failure.

SQL Server Setup has encountered the following error:

Invoke or BeginInvoke cannot be called on a control until the window handle has been created..



Is there a way around this problem???
If so, please gimme a solution asap, as i need to use the software for my project.

Error During Install Sql Server 2008 "Sql Server Setup requires .Net Framework 3.5"


I Want install SQL Server 2008 Server on Windows Server 2008 64 bit, but when i start exe file the error generate " Sql Server Setup requires .Net Framework 3.5"

.Net Framework 3.5 SP1 already installed.

Kindly help me my work is stuck for this error.

SQL Server 2008 r2 - Setup support files - Install error / reading from file


I'm installing SQL server 2008 r2 on a Win2003 R2 x86 system.

After i start the setup, the "setup support files" box begins installing, after a while i get this error:

"Error reading from file f:\1033_ENU_LP\x86\setup\sqlsupport_msi\PFiles\SqlServr\100\Setup\ewbfphdh\x86\Patch\rs2000.msp verify that the file exists and that you can access it."

I've tried another DVD, i've tried a mounted share on another machine...no go....i've tried an ISO file mounted on this server... same error.

Is there any way i can install this "setup support files" from another location? (download)

Is there a switch soo it won't install reporting services? (...i think this file rs2000.msp is from reporting services)





Error Changing Default Backup and Log locations on 2 Node SQL 2008 Failover Cluster


My setup is a SAN providing iSCSI targets for a 2 node SQL 2008 Failover cluster on Windows Server 2008.  With the SAN volumes created, MPIO and iSCSI targets defined on each node, I installed the SQL Server cluster with a single iSCSI target, and therefore assigned database files, log files and backup files to be on that single volume.

I have since added a separate volume for both log files and backup files.  All 3 volumes are online in the SQL Resource Group of the cluster and active on the SQL Server active node of the cluster, and all the volumes are accessible from Windows Explorer on both cluster nodes.

Through SQL Mgmt Studio, I changed the default location of the log files, and I changed the default backup location in the registry for each node.

When I try to create a new database, I get an error saying I do not have permission to access the log file volume.  When I try to restore a database, I get the same error when SQL Mgmt Studio tries to access and display the specified backup volume. The text of the error in each case is:

"Cannot access the specified path or file on the server.  Verify that you have the necessary security privileges and that the path or file exists.

If you know that the services account can access a specified file, type in the full path for the file in the File Name con

Error occurred while SQL Server 2008 R2 Setup at Windows 7



I try setup

RTM-version Microsoft SQL Server2008 R2 Express with Advanced Services X64 

on  Windows 7.

In setup check common components placed on disk C:

and named instance of data baseTEST on disk D:

During installation process occurred error:

SQL Server Setup failed to modify security permissions on file D:\MS SQL Server 2008 R2\Base TEST\MSSQL10_50.TEST1\MSSQL\ for user PAVEL. To proceed, verify that the account and domain running SQL Server Setup exist, that the account running SQL Server Setup has administrator privileges, and that  exists on the destination drive.

User PAVEL has admin's priveleges.

Setup lanche "as from admin name"

Disks C and D at home computer.


Error upgrading SQL Server 2008


i was normally using VS2005 and SQL server 2005...

i upgraded to SQL Server 2008... and then...

i could not build my project anymore... because of this error:

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. 
Exception Details: System.IO.FileNotFoundException: The specified module could not be found. (Exception from HRESULT: 0x8007007E)
Source Error: 

Proper setup using Infopath and Custom Workflow using VS 2008



I have been struggling for a couple of days, trying to set up a decent
structure for an Infopath project using a custom workflow using Visual Studio 2008.

I had a solution with two projects:

1) Sharepoint 2007 Workflow

2) Infopath 2007 form w/code-behind.

I included the xsn, in the VS solution, but after a day or two,
something went wrong, and I lost some work. I still do not know what
happened, but I could not get my changes to persist afterthat  Doing research I have read that this
stucture, using Infopath xsn, within VS does not work correctly with Source
Control. I am using VSS.

So I since made a change to the set-up so that the .xsn (form template) is separate from
Visual Studio. However, I need to leave the code-behind in VS, since I need to debug

This is my latest problem. I have been unable to attach to the correct
process, as VS generates cachse files, and who knows what else.

My question is simple. What is the supported method for debugging InfoPath
code/behind, which uses a Sharepiont Workflow?

I just also want to say that one should not have
to spend a few days just trying to setup a working development environment.

This should be trouble-free, but it is far from being so. I

Server 2008 R2 -> Failed to decrypt using provider 'RsaProtectedConfigurationProvider'. Error mess


So I am using the aspnet_regiis.exe tool to encrypt sections of the web.config in my asp.net applications and services.  I have done this for years successfully on Windows Server 2003 (IIS 6).  However I just moved some apps over to Windows Server 2008 R2 (with IIS 7.5) and I am now receiving the following error at runtime:

"Server was unable to process request. ---> Failed to decrypt using provider 'RsaProtectedConfigurationProvider'. Error message from the provider: Bad Data."

Now I am quite familiar with this process and am stumped at what I have missed this time around.  I have done ALL of the following which typically suffices for the process on the server. PLEASE READ ALL AND DO NOT PROVIDE RESPONSES OR LINKS FOR THINGS I HAVE ALREADY DONE Thanks!!  Wink

  1. Imported the keys to the server using aspnet_regiis -pi  Result: Success
  2. Given FULL permission (using -full switch) using aspnet_regiis -pa to ALL of the following accounts  Result: Success
    1. VS 2008 Install - Windows Mobile 5.0 SDK R2 for Pocket PC: [2] Error: Installation failed for compon



      I am trying to install VS2008 on my Windows XP machine. I have MS Office 2003 and SP2. Disabled the Norton Anti-Virus. I am getting the following error. I appreciate if some one can help me.

      [08/26/10,07:04:36] Windows Mobile 5.0 SDK R2 for Pocket PC: [2] Error: Installation failed for component Windows Mobile 5.0 SDK R2 for Pocket PC. MSI returned error code 30
      [08/26/10,07:04:39] VS70pgui: [2] DepCheck indicates Windows Mobile 5.0 SDK R2 for Pocket PC is not installed.
      [08/26/10,07:04:39] VS70pgui: [2] DepCheck indicates Windows Mobile 5.0 SDK R2 for Smartphone was not attempted to be installed.
      [08/26/10,07:04:39] VS70pgui: [2] DepCheck indicates Microsoft Device Emulator version 3.0 was not attempted to be installed.
      [08/26/10,07:04:39] VS70pgui: [2] DepCheck indicates Microsoft SQL Server 2005 Express Edition (x86) was not attempted to be installed.
      [08/26/10,07:04:39] VS70pgui: [2] DepCheck indicates Crystal Reports Basic for Visual Studio 2008 was not attempted to be installed.
      [08/26/10,07:04:39] VS70pgui: [2] DepCheck indicates Microsoft Windows SDK for Visual Studio 2008 Tools (x86) was not attempted to be installed.
      [08/26/10,07:04:40] VS70pgui: [2] DepCheck indicates Microsoft Windows SDK for Visual Studio 2008 Headers and Libraries (x86) was not attempted to be installed.
      [08/26/10,07:04:40] VS70pgui: [2] DepCheck indicates Microsoft

How to overcome .net download error during setup

Hello All,We have a .NET 3.5 SP1 WPF application that we deploy to our costumers using a setup and deployment project in Visual Studio.In order to make things easier to our costumers, we provide in a specifc URL path for the setup.exe file and the .msi file.As the .net 3.5 is a prerequisite for the app to run, the setup.exe properly detects when it is missing form the costumer PC and ask to start the instalation.This works fine for most of our costumer, but, for some of them, the download fails with the following message:An error occurred downloading the following resource:http://go.microsoft.com/fwlink/?LinkId=37283 (something similar to this path).I suspect that some costumer have firewalls or anti-virus programs that block file download trought a non autorized program.Most of our costumer have dificulties to install the application and they actually don´t know anything about internet security or deployment process, so they expect the installtion to be an easy process.I would like top hear from you could be really causing this and how do you suggest to workaround this issue, so the user don't have to bother about prerequisites instalation.Kindly Regards,Igor.Project Manager at INOVATIVA Tecnologia www.inovativatec.com

Net Framework 1.0 Error 1904 during setup mscoree.dll H-result 2146232576

I cleaned off all my .Net framework files with the .Net framework cleaner. I then started at 3.5, installed it, went well, installed 3.0, went well, installed 2.0, went well, installed 1.1, went well, then, tried to install 1.0 redistribution package for my windows xp home and it stopped at almost the very end saying ERROR installing 1.0 ERROR 1904 system32\mscoree.dll failed to register. H-result 2146232576. I tried renaming it and installing the 1.0 again but still get the same error. i tried using the IGNORE option, it said it installed but i know the mscoree.dll isn't working. i used the installer cleanup tool also to no avail. i deleted the URTTemp folder and tried a reinstall. This didn't work either. Anyone know what I might can do to get this corrected? I have not done anything myself in the registry. I have used RegCure and registry mechanic but Net Framework 1.0 still gave the error when I tried to install. Any help appreciated. I did read something about 1.1, 2.0,3.0 or 3.5 might have a newer mscoree.dll file and that night be why I can't register the one I have. I need the 1.0 version 3705 though as one of my programs uses it. Also, i am now not able to put any of the updates on my computer. it downloads them but they fail to install. Example, net framework 2.o service pack 2, net framework 3.5 service pack 1, and net framework 3.5 family update. Thanks....

ssrs 2008 R2 - report parameter with no default set throws java script error

We have recently upgraded from SQL Server 2008 to SQL Server 2008 R2....I am experiencing a problem with my report parameters on my SSRS reports. It seems that my report parameters that I do not have a specified 'default' value throws a java script error when I try and run/render the report under R2.  As soon as I put a 'default' value on the report param, everything is fine.  However, that is not the behavior we need for our reports...the user needs to pick their selection. Can anyone shed some light on this, it seems to be an AJAX problem...I need to be able to have report parameters with a list of values, but no 'default' value on the parameter.

[SSRS 2008 R2]Report Builder Access error-The remote server returned an error: (401) Unauthorized.

Hello,        I am able to login Web Service URL and report manager using computer name and report builder is also working fine.  http://RPTSRV/reportserver   (RPTSRV is report server name. web service url working fine. all accessible) http://RPTSRV/reports  (report manager working fine and all accessible ,report builder too) It means I am able to access everything locally right? http://rs.test.abc.com/reportserver  (web service url working fine. all accessible)  http://rs.test.abc.com/reports    (Report manager working fine and all accessible accept report builder)(I carefully checked the link and its taking rs.test.abc.com/reportserver.....)     when I click on reportbuilder button in report manager it shows me error dialog box with following error log!! I tried from local and remote computer too but gives the same error both side. I am not sure but I am just thinking is this double hop kerberos security issue? Please help me to solve this problem. I am finding solution from last 4 days. Reporting Service configuratin tool settings Web Serivice URL -  all set to default Report Manager URL - all set to default Environment - Distributed deployment Server1(report_srv) --Windows server 2003, Installed sql server 2008R2 reporting service,
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