.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

Detect SQL Express 2008 installed on machine

Posted By:      Posted Date: October 08, 2010    Points: 0   Category :.NET Framework

Hello all,

How cal I detect if SQL Express is installed on may machine through C#.





View Complete Post

More Related Resource Links

Express 2008 R2 performance dire on VM vs Physical Machine

Like a lamb to the slaughter we upgraded a 2005 Express VM to 2008 R2 at first it seemed fine, then the users compained of poor performance. The database was now above 4GB so no going back. Performance was degrading, we noted the VM only had 512 ram, reconfiguered to 3GB and the machine ground to a halt  Literally - more than 1 user could not log on. A simple query would MAX the processor to 100% for 2 or 3 seconds. No stored proceedure was a standout as a bad performer. Only one user could log in at a time. All indexes were rebuilt (took 4 hours!) still unusable performance. Move the machine to a single processor xp with 2GB ram and 8 users can now log on simutaneously CPU bumps along at 5-20%. Is SQL 2008 R2 Express a no no on VMware? Should we recommend against SQL 2008 R2 upgrades?

Can't get SQL 2008 Express installed


Hope some one can help me. I am trying to install 2008 Express version and I constantly get the following error. I have tried pretty much all flavors of express and get the same thing. I uninstalled several time and reinstall but keep getting the same exception error. Can someone help me out. Here is the error:

See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.Configuration.ConfigurationErrorsException: An error occurred creating the configuration section handler for userSettings/Microsoft.SqlServer.Configuration.LandingPage.Properties.Settings: Could not load file or assembly 'System, Version=, Culture=neutral, PublicKeyToken=b77a5c561934e089' or one of its dependencies. The system cannot find the file specified. (C:\Documents and Settings\Jocelyn\Local Settings\Application Data\Microsoft_Corporation\LandingPage.exe_StrongName_ryspccglaxmt4nhllj5z3thycltsvyyx\\user.config line 5) ---> System.IO.FileNotFoundException: Could not load file or assembly 'System, Version=, Culture=neutral, PublicKeyToken=b77a5c561934e089' or one of its dependencies. The system cannot find the file specified.
File name: 'System, Version=, Culture=neutral, PublicKeyToken=b77a5c561934e089'
   at System.Configur

I installed SQL Server 2008 Express 64-bit, but I can't install SQL Server 2008 Management Studio E

I installed SQL Server 2008 Express 64-bit Runtime succesfully on my Windows Server 2008 Enterprise SP2 64-bit. However when I start the setup to install SQL Server 2008 Management Studio Express (SSMSE) 64-bit Edition, I get the following error message:

SQLManagementStudio_x64_ENU.exe is not a valid Win32 application. OK.

Conclusion: I can't install this Management Tool for SQL Express server. I don't understand the error message. All is 64-bit. Does the message mean that I have to install the 32-bit version? Why? That doesn't make sense, as everything is running in 64-bit.

Any resolution to this issue?

installing SQL Server 2008 R2 Express on a PC that has MSDE installed


Hi - My PC has MSDE installed on it and I'd like to install Express to take advantage of some new functionality in Express.  The PC runs Windows XP Home Edition.  Here are my questions:

1. Is it possible to have both MSDE & Express on one PC without causing problems?

2. How do I move databases from MSDE over to Express?

3. How will my query editor (Toad) know which SQL Server version to point to?

4. When setting up ODBCs will the two different SQL Servers appear there?

I have a hunch that this is a fairly basic thing so if there are any useful threads or websites on this topic that anyone knows about, please do post the links.  Of course, any answers to the specific questions listed above would be greatly appreciated.

Thanks, knot

Sql Server 2008 Express Will Not Install on My XP SP3 machine


I have tried installing Sql Sever 2008 express multiple times manually and through other software that require it as a prerequisite.  It just fails to install and tells me to check the Install log.  The install log is below:


The following properties have been set:

Property: [AdminUser] = true {boolean}

Property: [InstallMode] = HomeSite {string}

Property: [ProcessorArchitecture] = Intel {string}

Property: [VersionNT] = 5.1.3 {version}

Running checks for package 'Windows Installer 3.1', phase BuildList

The following properties have been set for package 'Windows Installer 3.1':

Running checks for command 'WindowsInstaller3_1\WindowsInstaller-KB893803-v2-x86.exe'

Result of running operator 'VersionGreaterThanOrEqualTo' on property 'VersionMsi' and value '3.1': true

Result of checks for command 'WindowsInstaller3_1\WindowsInstaller-KB893803-v2-x86.exe' is 'Bypass'

'Windows Installer 3.1' RunCheck result: No Install Needed

Running checks for package 'Windows Installer 4.5', phase BuildList

Looking up path for special folder 'WindowsFolder'

Running check with folder 'C:\WINDOWS\System32' and file 'msi.dll'

Attempting to find file 'C:\WINDOWS\System32\msi.dll'

File version is '4.5.6001.22299'

Setting val

import/export wizard crashes on SQL Express 2008 R2 installed on Windows 7 (32-bit)


I have been getting "Unexpected Unrecoverable Error; Abort, Retry, Ignore" when using the SQL Import/Export Wizard in the following scenarios (these are the only two ways I have tried using the Wizard):

1) Source Advantage OLE DB Provider, destination SQL Server, copy tables

2) Source Microsoft Excel, destination SQL Server, copy tables, show report if there were any failures

I have run the SQL Setup Repair and still get the same behavior.  Are there known issues with SQL Express 2008 R2 on Windows 7 for Import/Export?

Thanks, David

Express Editions: Get a Lean, Mean Dev Machine with the Express Editions of Visual Basic and SQL Ser


The Express Editions of Visual Basic and SQL Server 2005 have lots of the features of the full-sized versions, but with a lot less of the overhead. Professional developer features such as full IntelliSense support, local debugger, Add Web Reference, and the improved Visual Data Tools will all be available in the Express products, so you don't have to leave your favorite features behind. In this article the author introduces you to these express editions and builds a sample app to get you started.

Brian A. Randell

MSDN Magazine September 2004

FLV file in Visual Web Developer Express 2008


I'm trying to embed a flv in my web page and I don't have a clue how to do it.

I downloded and installed ASPNetFlashVideo and the tools do not appear in my toolbox.

So if anyone has a work around it would be greatly appreciated.

How can Install Office 2007 on Windows server 2008 R2 64 bit machine in WSS 3.0

I have  64 bit machine  and Windows server 2008 R2 has installed. i have successfully install WSS 3.0  , but  when i tried to install  office 2007 ,  one  error  has  come  "OS is not compatible "  i thought  it was asking  for 64 bit office  2007   and i go through the  google and R&d find no 64 bit office is available ,  i have used   excel .dll in my custom code  so my problem is that   how can  install office 2007  on 64 bot OS 2008 r2  machine .  if anyone can help   me  , please let me know . thanks in advance

CSS support in visual studio 2008 express edition


I have several css style sheets I want to work with.  I have copied them into the appropriate directory structure in my project.  The styles are applied correctly.

But the manage CSS styles tool bar on the left margin doesn't seem to work correctly.  At one point I had generated a style sheet and worked with it there, but now it not only can't find the one it generated, but the attach style sheet link doesn't respond at all, nor does anything in this bar.  Same deadness with the CSS Properties bar.  With or without a style sheet loaded in the editor -- a style sheet that is active in the project such that when I run it, the styles are applied.

VB version of studio, running on Vista home basic.

PS, the design mode works a lot better than the professional version I use in my day job on XP and server 2003.

Need help uninstalling incomplete Visual Web Developer 2008 Express Edition with SP1


I need to get a list of programs/files that were installed when I was trying to install VWD 2008 so I can go through and remove them.  The installation did not actually install the main part of the program so I can't start with removing Microsoft VWD 2008 (a folder was created in Program files but it is empty.  I found this (below) but I'm not sure that it applies. I don't want to remove programs/files that are being used by other programs. (I can't just try to install again because there is not enough room on my hard drive)

Uninstalling Previous Versions of Visual Studio 2008

This article applies to pre-Release versions of Microsoft Visual Studio 2008. For 2005 version of this document, see Uninstalling Previous Versions of Visual Studio 2005.

For best results, Visual Studio 2008 should b

How to connect to local instance of SQL Server 2008 Management Studio Express ?


I just installed SQL Server 2008 Management studio Express on my Vista machine.

i tried connecting to local machine using :

.\sqlexpress, (local)\sqlexpress, or .\SQLExpress, MyPCNAME\SQLExpress

nothing is working, getting this error:

Cannot connect to PC-NAME\SQLEXPRESS. A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

guide to uninstall sql express 2008 and install sql express with managment studio

i have installed sql express 2008 and i need to install sql express 2008 with management studio what steps do i have to follow ? I have downloaded the 3 variances of sql1.sql express 2. sql express with management studio . 3.sql express with advanced servicesHow can i completely uninstall sql 2008 express and install it with management studio?Thank you for your timeAlex

Can't Create ODBC to Local SQL Server Express 2008

Hello. I have SQL Server Express 2008 SP1 LOCALLY on my Windows XP Professional SP3 box. I have databases already created in Access 2007 that I imported into SQL. Now I want to keep the front end Access forms for data entry but have them connect to the databases in SQL. What I can't seem to do is connect from Access to the SQL db's because I can't create the ODBC connection. When I try to connect, I get the following two 'Connection failed' errors: 1. SQLState: '08001' SQL Server Error: 10061 [Microsoft][SQL Server Native Client 10.0]TCP Provider: No connection could be made because the target machine actively refused it. 2. SQLState: 'HYT00' SQL Server Error: 0 [Microsoft][SQL Server Native Client 10.0]Login timeout expired Additionally, this information may help. 1. Windows firewall is turned off. 2. In SQL Server Configuration Manager > SQL Server Network Configuration > Protocols for SQLEXPRESS, Shared Memory, Named Pipes and TCP/IP are all 'Enabled'. The order is Shared Memory (1), Named Pipes (2) and TCP/IP (3). 3. In SQL Server Configuration Manager > SQL Native Client 10.0 Configuration > Client Protocols, the above three are also 'Enabled'. The order is Shared Memory (1), Named Pipes (2) and TCP/IP (3). Double-clicking TCP/IP tells me that the default port is 1433. 4. Running "netstat -ano", I see no entries for [myIPaddress]:1433.

Deploying problem with SQL Express 2008 R2

Scientific software package works fine with SQL Express 2008 R2 on developing (mother) PC and Admin login mode, but difficulties are found elsewhere during installing and deploying on the client PCs.  We have used from year 2000 BDE (Borland Database Engine), which worked fine until now, but recently customers had been installing problems with Vista, Windows 7 and the local administration rights or permissions.   Thus I thought to test NT AUTHORITY\NETWORK SERVICE authentication, as this system is hopefully working again decades with coming new Windows versions. As not need to touch databases, ADO and authentication matters during last decade, I’m newbie with those topics.  Worked now few days with this problem, installed and unistalled SQL servers according to instructions, tested different connecting strings and now cannot found correction.  Solution is maybe and hopefully simple.   Attached is log data cut from (old and many times corrected) the main mother XP platform in Admin and Client (Guest) modes.  Same tests are done also with fresh XP installation on VirtualBox.  Used connecting strings are presented inside log files:           Main mother XP at Admin login:   2010-08-20 08:24:45.82 Server      Server local connection provider is ready to accept connection on [ \\.\pip

SQL express 2008 r2 on windows server 2003

install ends with the following error : "MsiEnumRelatedProducts failed to enumerate products with UpgradeCode='{1B117BA7-5BC1-419E-820E-7D4F3F412C7B}'. Error code: 1610."

How I can remove The Microsoft SQL Server 2008 Express installation manually.

How I can remove The Microsoft SQL Server 2008 Express installation manually ?   Other components uninstalled via Add/Remove but i cant remove SQL Server 2008 Express     From Add/Remove the following is installed:Microsoft SQL Server 2008   I have attempted to uninstall it via the Add/Remove method and this also failed.
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