ClickOnce Deployment: Customizing SQL Server Express: ASP Alliance

Print Add To Favorites Email To Friend Rate This Article
ClickOnce Deployment: Customizing SQL Server Express

page 3 of 3

by Terry Voss
Feedback

Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days): 29615/ 44

Article Contents:

Summary

For the install of your Visual Studio 2005 Windows Forms application, using .NET Framework 2.0 and SQL Server Express, the user sees a fairly seamless install that looks like one smooth install with no reboots required. It is impressive that two projects, the custom application and the publishing source website, can work together so automatically not just for the initial install, but for version upgrades as well. It is well worth the time to get to know this technology, since I feel ClickOnce Deployment will have a big impact, but also since manifest files are going to be used everywhere in future Microsoft products.

Links

Deploying Applications: User-Initiated Updates with ClickOnce (this is a PDF download that takes a while, but provides a valuable introduction to ClickOnce Deployment)

Use the Visual Studio 2005 Bootstrapper to Kick-Start Your Installation

« (Page 2)

View Entire Article

User Comments

Title: plz tell me
Name: Sajid
Date: 2009-01-17 3:45:22 AM
Comment:
hi i want to say that if i start that web setup project then after installation of the instanace it will again ask for installtion of tghe instance how we bypass it. plz reply soon

Title: Re: Small doubt in ClickOnce
Name: Nilesh
Date: 2008-12-09 3:48:23 PM
Comment:
Hi Rohan,

check this link
http://www.codeproject.com/KB/install/RestoreDBthenInstall.aspx

Title: Small doubt in ClickOnce
Name: Rohan
Date: 2008-08-19 10:53:45 PM
Comment:
Dear Terry,
Thanks for the great article. Just the solution I was looking for. I just have 2 small doubts about click-once deployment still.

1. If my application uses SQL Express, how can I include and attach my .mdf / .bak files with my project so that the database gets attached to the new instance of SQL.

2. Can I included 2 executing projects in a single click-once application. ie.. Can I have a Windows Form application and another Windows Service application install in a single instanc using the same click-once project ??

Thanks again for the article,
Regard,
Rohan Wadiwala

Title: ClickOnce Deployment: Customizing SQL Server Express Problem
Name: Satish C
Date: 2007-08-03 4:04:47 AM
Comment:
Getting the following error while installation
Could you please tell whats the problem here?

++++++++++++++++++++++++++++++++++++++
Process exited with code 28001
Status of package 'Windows Installer 3.1' after install is 'InstallSucceeded'
Status of package 'SQL Server 2005 Express Edition' after install is 'InstallFailed'
++++++++++++++++++++++++++++++++++++++

Thanks in anticipation
Satish

Title: ClickOnce Deployment: Customizing SQL Server Express
Name: Jei G
Date: 2006-09-05 9:41:48 AM
Comment:
Why can't I only set SECURITYMODE only without setting the sa password? I tried to exclude sapwd= attribute the sql express setup failed. Or is it possible to just disable sa login or supply a blank password?

Title: ClickOnce Deployment: Customizing SQL Server Express
Name: Jei G
Date: 2006-09-05 9:36:07 AM
Comment:
This is definitely a better solution than Microsoft article that suggest modifying registry settings especially to those of us who regard the registry as sacred. Still, I wonder why Microsoft could not come up with a command line way, say through the sqlcmd utility, to change the authentication mode. Thanks

Title: Re: Jerry Kasten's Question
Name: JLS
Date: 2006-03-24 3:38:28 PM
Comment:
> How does modifying the manifest on my machine affect
> the deployment if SQL Server Express is downloaded
> from Microsoft

The manifest gets compiled into the setup.exe that you (the developer) will deploy. It doesn't stay on your local machine. Then, during the install, setup.exe downloads the SQL Express package from MS if it needs it. The contents of the manifest control whether or not the package is downloaded and how it is launched but obviously (I hope) the actual package from MS is not modified.

Title: ClickOnce Deployment: Customizing SQL Server Express
Name: Jerry Kasten
Date: 2006-03-20 8:07:29 AM
Comment:
How does modifying the manifest on my machine affect the deployment if SQL Server Express is downloaded from Microsoft, as you suggest?

Product Spotlight