Hi,
Besides just checking it in the prerequisites list, what else I have to do to properly install the SQL server. I have somehow :
- specify instance name
- set authenfication to "SQL"
- setup users
- configure network protocols
- etc
I have found information how to configure the server through command line, etc. But can not find anything how to do it during ClickOnce installation.
Thanks
One more question to MS guys: I have impression that it is legal to distribute "MS SQL Server Management Studio Express" along with MS SQL Server Express.
Am I correct
If so, how to include it to the prerequisites list
How to install SQL Server Express as a prerequisite?
Jsmith4892002
David,
if you know the answer - plase respond. I have no idea where to look at for "Package/Product.xml files". Link to MSDN or article or sample/example will be appretiated.
murali-indian
Matt,
Thank you very much!
Felipe Levin
So I have to change this file everytime I work on a different project. This seems like a very poor work around at best.
Surely there is a better way, I can't believe the development team was so short-sighted as to not make the settings project related.
tamccann
No, the way this is organised is very extensible, you only have to change this per project and create an new prerequisite directory for that project if you want.
There is a UI for this functionality called "Bootstrapper Manifest Generator" this can be found on GotDotNet.
http://www.gotdotnet.com/workspaces/workspace.aspx id=ddb4f08c-7d7c-4f44-a009-ea19fc812545
LA_Zi
You need to edit the bootstrapper's Package/Product.xml files to update the command line arguments section of the document to get the specific settings you want.
OwenG
What are the "Package/Product.xml files"
Where are they located
enki
C:\Program Files\Microsoft Visual Studio 8\SDK\v2.0\BootStrapper\Packages\SqlExpress\en
edit the file package.xml and change both lines (yes there are 2) that start with <Command PackageFile="sqlexpr32.exe" and add your command line option here eg:
Arguments='-q /norebootchk /qn reboot=ReallySuppress addlocal=all instancename=SQLEXPRESS sapwd=mystrongpassword securitymode=SQL SQLAUTOSTART=1'
HTH Matt