Re: SQLExpress Config in Setup/Deployment package
- From: "Plamen Ratchev" <Plamen@xxxxxxxxxxxxx>
- Date: Sun, 14 Jan 2007 00:15:01 -0500
You have different options to configure those options:
1). Use the command line options when installing SQL Server 2005 Express
2). Use an ini file to specify the same options
3). Use a bootstrapper and add those parameters to the product manifest (in
the <Command> tag)
For 1). and 2). see more details here:
http://blogs.msdn.com/sqlexpress/archive/2006/09/20/configuring-sql-express-during-installation.aspx
http://msdn2.microsoft.com/en-us/library/ms144259.aspx
For 3). here:
http://msdn.microsoft.com/msdnmag/issues/04/10/bootstrapper/
The options that you need are:
1). Install to a specific instance: INSTANCENAME
2). Enable TCP/IP: DISABLENETWORKPROTOCOLS (0 - All protocols are enabled;
2 - Shared Memory and TCP/IP are enabled)
3). Set security mode to SQL: SECURITYMODE (note that when you use
SECURITYMODE=SQL to switch to SQL Security you have to provide a strong
password with the SAPWD option)
Regards,
Plamen Ratchev
http://www.SQLStudio.com
"Matt F" <mfielderREMOVECAPS@xxxxxxxxxxxxx> wrote in message
news:%23s0h7mnNHHA.2028@xxxxxxxxxxxxxxxxxxxxxxx
I have a setup/deployment package that I've included SQL Express, .Net
Framework 2.0, and MSI installer as pre-requisites. The project is created
in Visual Studio 2K5, Professional if that matters.
There are several options for SQL Express that I need to handle.
1: Install to a specific instance.
2: Enable TCP/IP
3: Set security mode to SQL
I've looked around and just can't seem to find what I need to do in order
to handle these items. Any help would be greatly appreciated.
.
- References:
- SQLExpress Config in Setup/Deployment package
- From: Matt F
- SQLExpress Config in Setup/Deployment package
- Prev by Date: sql server 2005 setup fails at the step of starting the sql server
- Next by Date: dbo.systypes
- Previous by thread: SQLExpress Config in Setup/Deployment package
- Next by thread: sql server 2005 setup fails at the step of starting the sql server
- Index(es):
Relevant Pages
|
Loading
