.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

Checking system configurtion while SQL setup in slent mode

Posted By:      Posted Date: September 07, 2010    Points: 0   Category :Sql Server
Hi all, There is a necessity to install SQL 2008 Server silently as a part of parent installation. Is system meets all requirements, setup finish successfully, but if there are some items to be checked (Computer restart, upgrading Visual Studio 2008 to SP1 etc) SQL Setup fails. To solve this it's necessary to check if system meets all requirements before starting the Setup. I found no way to run SCC without running whole setup, so to solve this I've chosen the next alternatives: 1) To create own checker which test all the items from {http://msdn.microsoft.com/en-us/library/cc646015.aspx} by itself; 2) To create parser for logs which SQL Setup writes about failed installation; 3) If it possible - somehow run SQL Setup SCC alone and receive its output. Which approach looks like to be the best? Thanks in advance. Sincerely, Ilya Sotin

View Complete Post

More Related Resource Links

visual studio tools for the office system 3.0 runtime setup

Hi, I downloaded "visual studio tools for the office system 3.0 runtime" and installed in my machine.Now when I try to re-install this I get the message asking for "Repair" and "Uninstall" ,but non of this options are selected.Generally "Repair" used to be the default selection on re-installation for any setup installation. Do we have any way to enable this. Thanks, Deb

.NET application crashes when computer system wakes up from sleep mode.


Need help in understanding this error message generated from mscorlib failing when using threading.  I know the problem is not the code written by me, as the application works fine until the computer system is left idle, say for 30mins and allowed to go into sleep mode then the error manifests itself, about a minute later when the computer wakes from sleep mode, the application will perform its tasks and then this error is generated.

This could be a problem with System.Net.NetworkInformation.NetworkChange.AddressChangeListener.AddressChangedCallback

Any information given about the error described below is greatly appreciated, and information on how to prevent such errors even more greatly appreciated, or traps and handles it successfully.


Kind Regards,


Details of the error given below:--


"The Undo operation encountered a context that is different from what was applied in the corresponding Set operation. The possible cause is that a context was Set on the thread and not reverted(undone)."

Source: "mscorlib"

StackTrace: "   at System.Threading.SynchronizationContextSwitcher.Undo()\r\n   at System.Threading.ExecutionContextSwitcher.Undo()\r\n   at System.Threading.ExecutionContext.run

Error message setting up System DSN: Setup routines not found. Please reinstall driver.



I'm running W2K3 SP1.  The MDAC Configuration Checker reports MDAC 2.8 SP2.  The only discrepancy is MSADCO.DLL, where the expected version is 2.82.1830.0 and my actual version is 2.82.2651.0 (svr03_sp1_gdr.060301-1546).

The error message I'm getting when I use the ODBC Administrator dialog to set up a new entry is: "The setup routines for the SQL Server ODBC driver could not be found.  Please reinstall the driver."

This is followed by a dialog titled: "Driver's ConfigDSN, ConfigDriver, or ConfigTranslator failed."  The body text of the dialog is "Component not found in the registry."

Does anyone have any idea how I can repair this?


Failing Connection String Environmental Variable, XML Variable, System Variable (SQL Server) Setup


We attempted to implement the Chapter 2 Framework from the Knight, Vermeen, Moss, Hackney book on SSIS 2008: Problem Design Solution. We see a couple of problem areas (at least) in our interpretation of the guidelines from the book.

1. We are attempting to have one connection string per server: dev/prod

2. We have set up environmental variables per server: dev/prod

3. We have set up XML Package Variables per server: dev/prod

4. We have set up System Variables per server in SQL Server: dev/prod

Problem 1:

We've had to manually key in the common connection string to all packages on a server environment in the component properties area (control flow; not data flow--ok there)

Shouldn't the connection property find the connection that we've instantiated and provide us with a pull down to select it?

The components are un-editable after we select the common connection string, but they still run properly in our SQL Server Agent Job.

Problem 2:

The dev server variable overlays the prod server variable information duringprod component editing

We are'nt sure if these problems are related.

Here is our package variable:



Here is our DTSconfig file; we have a few variations of this that we've tried.

System.IO.FileLoadException Mixed mode assembly || System.BadImageFormatException: Could not load fi


Im trying o build my WCF project and im developing on Visual Studio with x64


Ive trid every configuration and when i use the x64 dll's I get the following error:

System.IO.FileLoadException: Mixed mode assembly is built against version 'v2.0.50727' of the runtime and cannot be loaded in the 4.0 runtime without additional configuration information.


When i use the x86 dll's I get the following error:

System.BadImageFormatException: Could not load file or assembly 'StreamTools.NET, Version=, Culture=neutral, PublicKeyToken=d264bf7150202654' or one of its dependencies. An attempt was made to load a program with an incorrect format.


Anyone know how to fix this?

Setup a login account for system backup, but now allow accessing data


Dear All,

     My problem seem quite contradiction. Not sure it's possible to do. My question is we used a symmatic software to backup our SQL databases. It require an admin right SQL user account to perform it. However some of database is quite sensitive e.g HR data. I don't want to let the IT staff to make use of this privilege to read the data. Is there any solution on this?

Best Rdgs


Best practice setup for SharePoint 2010 Foundation in StandAlone mode


Question: What is the best practice configuration for StandAlone install? Here is my scenario: client does not own SQL Server therefore they want to use the OOB version in StandAlone mode. Most likely this will be fine for their goals for a couple years. 

Anyhow, so I install in as Server Farm - first option, then StandAlone - second option, and select the location to store the data files. It installs great. Now reading the best practices for a typical farm (non-standalone) install, a domain account should be used for the services. During the install of standalone it assignes the NETWORK SERVICE account to all of the services. 

Can I create the SP_Farm account - per best practices - and get this account to work for the Farm service in standalone setup? Do I have to add this account to SQL Server Express first, add it as a managed account in SharePoint, then assign it to the Farm service?

Curious if anyone has done this. Or is the best practice when using SharePoint Foundation 2010 standalone configuration, to use the default accounts and settings as it was setup?

Thank you any responses.


System Configuration Checker not checking in Sql Server 2008 2R

I am novice jumping in and attempting to install Sql Server 2008 2R locally.

I am following this installation video http://msdn.microsoft.com/en-us/library/dd299415%28SQL.100%29.aspx And I am trying to use the checker to see if there is any condition that will prevent an sucessful installation.

In the tutorial it appears that they are using an earlier version than my windows7. When I click on the System Configuration Checker I get “Browse for Sql Server 2008 2R Installation Media” which is not the same option as the video (2.02)

Not sure what to do as ultimately I would like to check that everything is in place first. Can anyone help me please.

MSXML6 Installer Error; MSDN SQL 2005 Setup Failure; "failed because a higher version"; "system admi


I had similar problem as above, but had to add an additional registry editing step (not listed).


Here's complete write up of the steps that worked on this pc... (Thanks to the tip for the first fix from Xiaochuan's spaces http://cid-c06fe3569bc575d9.spaces.live.com/)


Initial Problem: Error installing MSDN SQL 2005 on Windows XP pro SP 2, due to MSXML6 "Setup Failed"


After reading plenty of posts, determine failure is isolated to running msxml6.msi installer.


I had two different errors running the MSXML6 installer.


Error #1 - MSXML6 (msxlm6.msi) install fails because "the system administrator has set policies to prevent this installation ..."

Error #2 - "Installation of MSXML 6.0 Parser failed because a higher version is already exits on the machine. To proceed, uninstall the higher version and then run MSXML 6.0 Parser Setup again."


So here's the steps that fixed both, and allowed msxml6.mxi to be inastlled... and subsequently sql msdn...


Install #1 - Run msxml6.msi (you can get this off SQL install CD (in D:\ENGLISH\SQL200

Instal Problem: SQL Server Setup media is not supported on a X64 system


I recently purchased SQL Server 2008 R2 Developer. I am trying to install it on Windows 7 (64-bit Operating System). It is running on Parallels VM under MAC OS. When I click on setup.exe I get the following message:

"This SQL Server Setup media is not supported on a X64 system. To continue run the SQL Server Setup that matches your system. Is there another SQL Server Developer product that I should be using instead? I contacted the MS sales on Chat and was directed to MSDN forums.


System Development Life Cycle

The Systems Development Life Cycle (SDLC) is a conceptual model used in project management that describes the stages involved in an information system development project from an initial feasibility study through maintenance of the completed application. Various SDLC methodologies have been developed to guide the processes involved including the waterfall model (the original SDLC method), rapid application development (RAD), joint application development (JAD), the fountain model and the spiral model. Mostly, several models are combined into some sort of hybrid methodology

The Agile System Development Life Cycle (SDLC)

The goal of this article is to describe the agile system development life cycle (SDLC), putting it in context from what you may have heard about within the agile community and more importantly within the context of your overall IT efforts.

Performance Tests: Precise Run Time Measurements with System.Diagnostics.Stopwatch

Everybody who does performance optimization stumbles sooner or later over the Stopwatch class in the System.Diagnostics namespace. And everybody has noticed that the measurements of the same function on the same computer can differ 25% -30% in run time. This article shows how single threaded test programs must be designed to get an accuracy of 0.1% - 0.2% out of the Stopwatch class. With this accuracy, algorithms can be tested and compared.

How to setup a Mobile Browser Emulator in Windows Mobile 6:

In the following tutorial, I cover the process of Setting up Windows Mobile 6 for Mobile Browser Emulation using the Microsoft Device Emulator. This enables a user to experience Windows Mobile 6 on a PC via Emulation without even owning a Windows Mobile 6 product. It can be a great way to test drive Windows Mobile 6 before purchasing a product with it installed. In our case, it allowed us to Emulate Windows Mobile Browsing so that we could optimize our sites for the Mobile viewing audience. Installation and Emulation is simple and fairly straight forward.



hello i have the following problem

i have upload my content to hosting server but i get the following error

Security Exception

Description: The application attempted to perform an operation not allowed by the security policy.  To grant this application the required permission please contact your system administrator or change the application's trust level in the configuration file.

Exception Details: System.Security.SecurityException: Request for the permission of type 'System.Web.AspNetHostingPermission, System, Version=, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[SecurityException: Request for the permission of typ

Problem upgrading to MVC3 - System.Web.Routing



I'm trying to upgrade to .NET 4 and MVC 3.

When trying to compile my project, I get the error:

Error 1 The type or namespace name 'Routing' does not exist in the namespace 'System.Web' (are you missing an assembly reference?) C:\Users\spencer\Desktop\weblauncher\Common\MVCConfig.cs 4 18 Common

The type or namespace name 'Routing' does not exist in the namespace 'System.Web' (are you missing an assembly reference?)

I do have the System.Web.Routing in my references for the project.

BUT - when I try to view System.Web.Routing in the OBJECT BROWSER, nothing is inside!  The System.Web.Routing namespace is not in there - the entire thing is empty!  Could it that the dll is corrupted?  I tried to reinstall the .NET 4 and MVC 3 stuff, but its still empty!

The dll is coming from here:

C:\Program Files (x86)\Reference Assemblies\Microsoft\Framework\.NETFramework\v4.0\System.Web.Routing.dll

and the runti

How to turn off optimistic concurrency checking?


I have run into a problem with optimistic concurrency in my dynamic data application (where all relevant settings are at their default values); when I try to update or delete one of my tables, I see the following error:

 Exception type: ChangeConflictException
 Exception message: Row not found or changed.

I am the only user of my database at the moment, so I can guarantee that the data both exists and has not been changed outside the application!

Various forums have suggested that the way to deal with this is to set the column attributes so that the concurrency checking is disabled; i.e.

[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_PropSurname", DbType="NVarChar(255)", UpdateCheck=UpdateCheck.Never)]

However, to do this manually through the Visual Studio designer will take me hours (I have a lot of tables) and if I then change the schema of one of the tables in the DB, won't I then have to do it all again?  I've tried editing the .designer.cs file directly but my changes are subsequently overwritten (as expected).

All suggestions gratefully received!

Ed Graham

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