bootstraper for SQl express
sajidqureshi
My installation works fine. but isuues is that. if one instance with the same name is already installed then its again ask me to run the sql express.this issues is also on uninstall of the setup.
I want to know how i put some condition that if sql express instance with the same name is not installed on the m/c then only it ask for installting the sql express otherwise bypass it. plz help me
EggHeadCafe - .NET Developer Portal of Choice
http://www.eggheadcafe.com/default.aspx?ref=ng
eliza
[VB.NET CODE STARTS HERE]
' Need to add System.Management reference
Imports System.Management
' Check if SQL express is already installed in the destination machine
Public Shared Function isExpressInstalled() As Boolean
Const edition As String = "Express Edition"
Const instance As String = "MSSQL$SQLEXPRESS"
Const spLevel As Integer = 1
Dim fCheckEdition As Boolean = False
Dim fCheckSpLevel As Boolean = False
Try
Dim getSqlExpress As ManagementObjectSearcher = New ManagementObjectSearcher("root\Microsoft\SqlServer\ComputerManagement", "select * from SqlServiceAdvancedProperty where SQLServiceType = 1 and ServiceName = '" + instance + "' and (PropertyName = 'SKUNAME' or PropertyName = 'SPLEVEL')")
If getSqlExpress.Get.Count = 0 Then
Return False
End If
For Each sqlEngine As ManagementObject In getSqlExpress.Get
If sqlEngine("ServiceName").ToString.Equals(instance) Then
Select Case sqlEngine("PropertyName").ToString
Case "SKUNAME"
fCheckEdition = sqlEngine("PropertyStrValue").ToString.Contains(edition)
Case "SPLEVEL"
fCheckSpLevel =
http://www.mindfiresolutions.com/Check-if-SQL-express-is-installed-on-target-machine-229.php
Morri wrote:
How can I have SQL 2005 express or SQL prerequisite in a deploymen
04-Apr-07
In VS .net 2005 I'm building an install package for a website that requires
SQL server or SQL express to operate. In the deployment package's Project
properties I specified SQL 2005 express as a prerequisite in a bootstrap
deployment for the website.
The deployment works correctly if there is no SQL server on the target
machine and first installs SQL 2005 Express. But on a system that is already
running SQL 2005 (not express but full version) the install package tries to
install SQL 2005 express. Should SQL 2005 satisfy the SQL 2005 Express
prerequisite? Or how can I specify that SQL 2005 or SQL 2005 Express both
satisfy the prerequisite?
--
Thanks
Morris
Previous Posts In This Thread:
On Wednesday, April 04, 2007 10:36 PM
Morri wrote:
How can I have SQL 2005 express or SQL prerequisite in a deploymen
In VS .net 2005 I'm building an install package for a website that requires
SQL server or SQL express to operate. In the deployment package's Project
properties I specified SQL 2005 express as a prerequisite in a bootstrap
deployment for the website.
The deployment works correctly if there is no SQL server on the target
machine and first installs SQL 2005 Express. But on a system that is already
running SQL 2005 (not express but full version) the install package tries to
install SQL 2005 express. Should SQL 2005 satisfy the SQL 2005 Express
prerequisite? Or how can I specify that SQL 2005 or SQL 2005 Express both
satisfy the prerequisite?
--
Thanks
Morris
On Thursday, April 05, 2007 4:30 AM
stchen wrote:
Hi Morris,As for the SQL Express BootStrapper package, it simply install an
Hi Morris,
As for the SQL Express BootStrapper package, it simply install an SQL
Server express edition instance with the instance name as "SQLExpress" on
the target machine. Thus, no matter whether there is SQL Server Full
edition installed on the box or not, the SQL Express bootstrapper package
just check whether there is any existing SQL server 2005 instance with
instance name as "SQLEXPRESS" on the box, if not, it will install the SQL
Express instance.
For your scenario, if you want to do some other customized checking to
control the installation of SQLExpress bootstrapper package, you can
consider add some custom "install check" logic. You can refer to the
following MSDN article for detailed info:
http://msdn2.microsoft.com/en-us/library/aa730839(VS.80).aspx
Also, all those existing VS 2005 setup bootstrapper packages are under the
following location(include the SQLExpress ):
C:\Program Files\Microsoft Visual Studio 8\SDK\v2.0\BootStrapper\Packages
You can simply find the SQL Express one and customize it(the xml configure
file ot if) or copy it and build a new bootstrapper package based on it.
Hope this helps. If you have any other questions on this, please feel free
to post here.
Sincerely,
Steven Cheng
Microsoft MSDN Online Support Lead
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
On Thursday, April 05, 2007 5:10 PM
Morri wrote:
Thanks for that info.
Thanks for that info.
Can you tell me just what I need to add to test for an SQL server installed
on the target system?
That atricle is helpfull but Is there a reference for all the elements and
attributes in the Product.xml and package.xml? and what about all the product
codes at least for Microsoft products? Without this info the article is just
interesting info but not useful.
What about SqlExpressChk.exe what does that do and return? Are there other
Chk.exe programs that check for other programs?
--
Thanks
Morris
"Steven Cheng[MSFT]" wrote:
On Friday, April 06, 2007 5:37 AM
stchen wrote:
Thanks for your reply Morris,For checking whether the bootstrapper package has
Thanks for your reply Morris,
For checking whether the bootstrapper package has already been installed,
the xml package file provide the <InstallChecks> setting(also mentioned in
the previous article I mentioned), you have several choice of property
source, such as "msiProductInfo", "registry info", "file path info" or use
custom exe program to do the check:
http://msdn2.microsoft.com/ru-ru/library/ms229432(VS.80).aspx
The SQLExpress built-in bootstrapper use a custom exe "SqlExpressChk.exe"
to do the checking. I'm not sure on its exact code, but I think it could
use the windows registry or WMI interface to checking the SQL Express
installation info.
For windows registry, you can simply check the following registry key since
it is exsting after you installed the SQL Express instance:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\SQLEXPRESS
There is also a blog article introducing a WMI approach for detecting SQL
2005 instance since registry means is not quite documented which may vary
from different version:
http://blogs.msdn.com/sqlexpress/archive/2006/07/29/682254.aspx
Hope this helps further.
Sincerely,
Steven Cheng
Microsoft MSDN Online Support Lead
This posting is provided "AS IS" with no warranties, and confers no rights.
On Tuesday, April 10, 2007 10:25 AM
stchen wrote:
Hi Morris,Does the information in my last reply helps some?
Hi Morris,
Does the information in my last reply helps some? If you have any further
questions, please feel free to let me know.
Sincerely,
Steven Cheng
Microsoft MSDN Online Support Lead
This posting is provided "AS IS" with no warranties, and confers no rights.
On Saturday, January 17, 2009 1:45 AM
sajid qureshi wrote:
bootstraper for SQl express
hi,I have develope one installer using .net 2.0. I have use silent installation of Sql express with authentication mode=sql & some pwd.
My installation works fine. but isuues is that. if one instance with the same name is already installed then its again ask me to run the sql express.this issues is also on uninstall of the setup.
I want to know how i put some condition that if sql express instance with the same name is not installed on the m/c then only it ask for installting the sql express otherwise bypass it. plz help me
Submitted via EggHeadCafe - Software Developer Portal of Choice
SharePoint - Managing Unused or Archive sites automatically
http://www.eggheadcafe.com/tutorials/aspnet/96bf1f1c-ab6f-43f1-9a5b-a2a8deb60cad/sharepoint--managing-unu.aspx