Question Installation SQL Server 2008R2

Laurent Dardenne écrit:

De mon côté, et dans un premier temps, je recherche une installation automatique du produit que j'aimerais couplé à une génération de base réalisé sour PowerAMC.
As-ton avis ce script peut-il être utilisé avec une version 2008 R2 express ?

Tout à fait, prend la version Advanced Express comme ça tu auras les outils Management Studio et de par la même occasion les modules powershell qui vont bien.

Il faudra juste que tu vires les comptes pour SSIS et SSAS ainsi que les services associés dans les différents tableaux du script.

J'ai une version pour 2008R2 Express au boulot, je te posterais ça demain<br><br>Message édité par: benduru, à: 17/04/12 00:07

Voilà le script qu'on utilise pour la version 2008R2 Express with advanced Services.

[code:1]
param([string]$managed,[string]$AdminPassword,[string]$UserAccount,[string]$UserPassword,[string]$DBName)

#############################
# #
# Main variables definition #
# #
#############################

$logfile = \&quot;C:\log\SQL2K8R2InstallAdvancedExpress.log\&quot; # Log file

if ($hostname.length -gt 15)
{
$computer = $hostname
} else {
$computer = $env:computername
}

# Directories

$sourcesdir = \&quot;C:\Temp\SQL\EXP\sources\\&quot; # This is the directory where SQL Server install binaries are stored
$scriptdir = \&quot;C:\Temp\SQL\EXP\scripts\\&quot; # This is the directory where the script Powsershell, sc.exe &amp; ntrights.exe are located.
$data_disk = \&quot;D:\\&quot;

# SQL Instance

$instanceName = \&quot;MSSQLSERVER\&quot; # The name you want the instance have

# The password for services account

$SVC_Pwd = \&quot;zAqw2008!\&quot;

# HKLM path where TCP/IP port is stored

$HKML_IPall = \&quot;HKLM:\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQLServer\SuperSocketNetLib\Tcp\IPAll\&quot;

# SQL Requests

$QueryMaxMemory = \&quot;EXEC sp_configure 'show advanced options', '1'
RECONFIGURE WITH OVERRIDE

EXEC sp_configure 'min server memory', '0'
EXEC sp_configure 'max server memory', ' + CAST(@Memory AS nvarchar) + '
RECONFIGURE WITH OVERRIDE

EXEC sp_configure 'show advanced options', '0'
RECONFIGURE WITH OVERRIDE\&quot;
$QueryMaxMeroySetted = \&quot;select value FROM sys.configurations where Name = 'max server memory (MB«»)'\&quot;
$TempDBadd = \&quot;USE [master]
GO
DECLARE @cpu_count int,
@file_count int,
@logical_name sysname,
@file_name nvarchar(520),
@physical_name nvarchar(520),
@size int,
@max_size int,
@growth int,
@alter_command nvarchar(max)

SELECT @physical_name = physical_name,
@size = size / 128,
@max_size = max_size / 128,
@growth = growth / 128
FROM tempdb.sys.database_files
WHERE name = 'tempdev'

SELECT @file_count = COUNT(*)
FROM tempdb.sys.database_files
WHERE type_desc = 'ROWS'

SELECT @cpu_count = cpu_count
FROM sys.dm_os_sys_info

WHILE @file_count &lt; @cpu_count -- Add * 0.25 here to add 1 file for every 4 cpus, * .5 for every 2 etc.
BEGIN
SELECT @logical_name = 'tempdev' + CAST(@file_count AS nvarchar)
SELECT @file_name = REPLACE(@physical_name, 'tempdb.mdf', @logical_name + '.ndf')
SELECT @alter_command = 'ALTER DATABASE [tempdb] ADD FILE ( NAME =N''' + @logical_name + ''', FILENAME =N''' + @file_name + ''', SIZE = ' + CAST(@size AS nvarchar) + 'MB, MAXSIZE = ' + CAST(@max_size AS nvarchar) + 'MB, FILEGROWTH = ' + CAST(@growth AS nvarchar) + 'MB )'
PRINT @alter_command
EXEC sp_executesql @alter_command
SELECT @file_count = @file_count + 1
END\&quot;
$TempDBmodify = \&quot;ALTER DATABASE tempdb MODIFY FILE ( NAME = N'tempdev', SIZE = 256MB, MAXSIZE = 512MB, FILEGROWTH = 64MB )\&quot;
$TempLogDBmodify = \&quot;ALTER DATABASE tempdb MODIFY FILE ( NAME = N'templog', SIZE = 256MB, MAXSIZE = 512MB, FILEGROWTH = 64MB )\&quot;
$SelectTempDB = \&quot;SELECT max_size FROM tempdb.sys.database_files WHERE name = 'tempdev'\&quot;
$SelectTempLogDB = \&quot;SELECT max_size FROM tempdb.sys.database_files WHERE name = 'templog'\&quot;
$CountTempDBFiles = \&quot;SELECT COUNT(*) as numcpu FROM tempdb.sys.database_files where type_desc = 'ROWS'\&quot;
$CpuCount = \&quot;SELECT cpu_count FROM sys.dm_os_sys_info\&quot;

#############################
# #
# Main functions definition #
# #
#############################

# This function write on the ouput is $silent is not activated
# Three level of log are recorded, INFO, ERROR, WARNING.

Function Write-Log {
param([int] $level=0,
[string] $message=$null)

$timestamp = Get-Date -format \&quot;yyyyMMdd_HH:mm:«»ss\&quot;

switch($level) {
0 {Write-Output \&quot;$timestamp : INFO : $message\&quot; }
1 {Write-Output \&quot;$timestamp : WARNING : $message\&quot; }
2 {Write-Output \&quot;$timestamp : ERROR : $message\&quot; }
}
}


# This function Write an error on Host.

function GetError {
param ([string]$text = $null,
[int]$ExitNb = $null)

Write-Host \&quot;$text FAILED: ERROR $ExitNb\&quot;
Exit $ExitNb

}

# This function inform on the ouput

Function Create-LogInfo {

param([string] $Libelle =$null,
[string] $Status =$null)

$currentDate = date -Format \&quot;dd/MM/yyyy - HH:mm:«»ss - \&quot;

if ($libelle.length -lt \&quot;7\&quot;«»)
{
\&quot;$currentDate $Libelle\&quot; + \&quot;`t`t: $Status\&quot; &gt;&gt; $logfile
}
else
{
\&quot;$currentDate $Libelle\&quot; + \&quot;`t: $Status\&quot; &gt;&gt; $logfile
}
if ($error) {
$error &gt;&gt; $logfile
$error.clear()
}
}

# This function create an array for paths

function Add-Path {
param([string]$Path,[string]$label)
$d = New-Object PSObject
$d | Add-Member -Name Path -MemberType NoteProperty -Value $Path
$d | Add-Member -Name Label -MemberType NoteProperty -Value $label
return $d
}

# This function create an array for Rights

function Add-Rights {
param([string]$wmi,[string]$name)
$d = New-Object PSObject
$d | Add-Member -Name wmi -MemberType NoteProperty -Value $wmi
$d | Add-Member -Name name -MemberType NoteProperty -Value $name
return $d
}

# This function create an array for account

function Add-Account {
param([string]$account,[string]$label,[string]$desc)
$d = New-Object PSObject
$d | Add-Member -Name account -MemberType NoteProperty -Value $account
$d | Add-Member -Name desc -MemberType NoteProperty -Value $desc
return $d
}

# function create an array for Services

function Add-Service {
param([string]$name,[string]$shortname,[string]$desc,[string]$startup)
$d = New-Object PSObject
$d | Add-Member -Name name -MemberType NoteProperty -Value $name
$d | Add-Member -Name shortname -MemberType NoteProperty -Value $shortname
$d | Add-Member -Name desc -MemberType NoteProperty -Value $desc
$d | Add-Member -Name startup -MemberType NoteProperty -Value $startup
return $d
}

# Create User function

Function Create-LocalUser {
param([string]$user,[string]$password,[string]$desc)
$objOu = [ADSI]\&quot;WinNT://localhost\&quot;
$objUser = $objOU.Create(\&quot;User\&quot;, $user)
#$objGrp = [ADSI](\&quot;WinNT://localhost/Administrators\&quot;«»)
$objUser.setpassword($password)
$objUser.SetInfo()
$objUser.description = \&quot;$desc\&quot;
$objUser.SetInfo()
#$objGroup.PSBase.Invoke(\&quot;Add\&quot;,$objUser.PSBase.Path)
}

# Account array

$listofaccounts = @()
$listofaccounts += Add-Account -account \&quot;svc_sqls_fcp\&quot; -label \&quot;\&quot; -desc \&quot;Service account for SQL Server\&quot;
$listofaccounts += Add-Account -account \&quot;svc_sqlb_fcp\&quot; -label \&quot;\&quot; -desc \&quot;Service account for SQL Server Browser\&quot;
$listofaccounts += Add-Account -account \&quot;svc_sqlrs_fcp\&quot; -label \&quot;\&quot; -desc \&quot;Service account for SQL Server Reporting Service\&quot;
$listofaccounts += Add-Account -account \&quot;svc_sqlft_fcp\&quot; -label \&quot;\&quot; -desc \&quot;Service account for SQL Server Full Text Search\&quot;

# SQL Paths // Warning if you change Path here do not forget to change them in $CreateDB var.... !!!!!

$ListOfPaths = @()
$ListOfPaths += Add-Path -path \&quot;D:\system_db\&quot; -label \&quot;System Files\&quot;
$ListOfPaths += Add-Path -path \&quot;D:\system_db_x86\&quot; -label \&quot;Shared System Files\&quot;
$ListOfPaths += Add-Path -path \&quot;D:\backup_db\&quot; -label \&quot;Backup directory\&quot;
$ListOfPaths += Add-Path -path \&quot;D:\config_db\&quot; -label \&quot;Config Directory\&quot;
$ListOfPaths += Add-Path -path \&quot;D:\user_db\&quot; -label \&quot;Data for SQL Server instance\&quot;
$ListOfPaths += Add-Path -path \&quot;D:\log_db\&quot; -label \&quot;Log for SQL Server instance\&quot;
$ListOfPaths += Add-Path -path \&quot;D:\temp_db\&quot; -label \&quot;Temp database for SQL Server instance\&quot;
$ListOfPaths += Add-Path -path \&quot;D:\temp_log_db\&quot; -label \&quot;Log of TempDB for SQL Server instance\&quot;

# Local policies

$localrights = @()
$localrights += Add-Rights -wmi \&quot;SeTcbPrivilege\&quot; -name \&quot;Act as part of the operating system\&quot;
$localrights += Add-Rights -wmi \&quot;SeIncreaseQuotaPrivilege\&quot; -name \&quot;Adjust memory quotas for a process\&quot;
$localrights += Add-Rights -wmi \&quot;SeCreateTokenPrivilege\&quot; -name \&quot;Create a token object\&quot;
$localrights += Add-Rights -wmi \&quot;SeImpersonatePrivilege\&quot; -name \&quot;Impersonate a client after authentication\&quot;
$localrights += Add-Rights -wmi \&quot;SeBatchLogonRight\&quot; -name \&quot;Log on as a batch job\&quot;
$localrights += Add-Rights -wmi \&quot;SeServiceLogonRight\&quot; -name \&quot;Log on as a service\&quot;
$localrights += Add-Rights -wmi \&quot;SeAssignPrimaryTokenPrivilege\&quot; -name \&quot;Replace a process level token\&quot;
$localrights += Add-Rights -wmi \&quot;SeManageVolumeNamePrivilege\&quot; -name \&quot;Perform volume maintenance tasks\&quot;
$localrights += Add-Rights -wmi \&quot;SeLockMemoryPrivilege\&quot; -name \&quot;Lock pages in memory\&quot;
$localrights += Add-Rights -wmi \&quot;SeChangeNotifyPrivilege\&quot; -name \&quot;Bypass traverse checking\&quot;

# This function set privileges for account services

function Set-SePrivilege {
param ([string]$path=$null)

$setup = ($scriptdir+\&quot;ntrights.exe\&quot;«»)

foreach ($acc in $listofaccounts)
{
[string]$account = $acc.account
[string]$desc = $acc.desc
Create-LogInfo \&quot;Set Privileges for $desc\&quot; \&quot;START\&quot;

foreach ($right in $localrights) {

[string]$wmi = $right.wmi
[string]$desc = $right.name
$i = $setup + \&quot; +r $wmi -u $account\&quot;
Invoke-Expression $i

Create-LogInfo \&quot;Give $desc right for $account\&quot; \&quot;SUCCESS\&quot;

}
if ( $account -match \&quot;svc_sqls_\&quot; ) {

net localgroup Administrators $account /ADD

Create-LogInfo \&quot;Modify ACLs\&quot; \&quot;START\&quot;

$set_Right = cscript ($scriptdir+\&quot;xcacls.vbs\&quot;«») $data_disk /E /G $env:computername\`\&quot;$account`\&quot;:F /SPEC B

if ($set_right) {
Create-LogInfo \&quot;Give Full control on $data_disk for $account\&quot; \&quot;SUCCESS\&quot;
$errorcode++
} else {
Create-LogInfo \&quot;Give Full control on $data_disk for $account\&quot;; GetError \&quot;Error Giving Full control on $data_disk for $account\&quot; $errorcode
}
}
}
}

$ServicesList = @()
$ServicesList += Add-Service -name \&quot;SQL Server (MSSQLSERVER)\&quot; -shortname \&quot;MSSQLSERVER\&quot; -desc \&quot;Provides storage, processing and controlled access of data, and rapid transaction processing.\&quot; -startup \&quot;Automatic\&quot;
$ServicesList += Add-Service -name \&quot;SQL Server Browser\&quot; -shortname \&quot;SQLBrowser\&quot; -desc \&quot;Provides SQL Server connection information to client computers.\&quot; -startup \&quot;Automatic\&quot;
$ServicesList += Add-Service -name \&quot;SQL Server Reporting Services (MSSQLSERVER)\&quot; -shortname \&quot;ReportServer\&quot; -desc \&quot;Manages, executes, renders, schedules and delivers reports.\&quot; -startup \&quot;Automatic\&quot;
$ServicesList += Add-Service -name \&quot;SQL Full-text Filter Daemon Launcher (MSSQLSERVER)\&quot; -shortname \&quot;MSSQLFDLauncher\&quot; -desc \&quot;Service to launch full-text filter daemon process which will perform document filtering and word breaking for SQL Server full-text search. Disabling this service will make full-text search features of SQL Server unavailable.\&quot; -startup \&quot;Automatic\&quot;

#########################################
#########################################
# #
# Do not edit anything after this point #
# #
#########################################

# clean previous Errors

if ($error) { $error.clear() }

$errorcode = 300

# Create log dir
if (!(Test-Path \&quot;C:\log\\&quot;«»)) {
New-Item -path \&quot;C:\log\&quot; -itemType \&quot;Directory\&quot;
}

# Create Directories

Create-LogInfo \&quot;Create Folders\&quot; \&quot;START\&quot;

Foreach ($dir in $ListOfPaths) {
[string]$name = $dir.label
if (New-Item -path $dir.path -itemType \&quot;Directory\&quot; -force) {
Create-LogInfo \&quot;Create Folder for $name\&quot; \&quot;SUCCESS\&quot;
$errorcode++
} else {
Create-LogInfo \&quot;Create Folder for $name\&quot; \&quot;ERROR\&quot;; GetError \&quot;Can't create folder for $name\&quot; $errorcode
}
}


# Add Firewall features and ports

Create-LogInfo \&quot;Configure Firewall\&quot; \&quot;START\&quot;

if ((netsh firewall set opmode enable) -and (netsh firewall add portopening TCP 1433 \&quot;SQLServer($instanceName)\&quot; enable subnet) -and (netsh firewall add portopening UDP 1434 \&quot;SQLBrowser($instanceName)\&quot; enable subnet) -and (netsh firewall set service fileandprint enable)) {
Create-LogInfo \&quot;Configure Firewall\&quot; \&quot;SUCCESS\&quot;
$errorcode++
} else {
Create-LogInfo \&quot;Configure Firewall\&quot; \&quot;ERROR\&quot;; GetError \&quot;Error Configuring Firewall\&quot; $errorcode
}

# Add users

create-LogInfo \&quot;Create accounts\&quot; \&quot;START\&quot;

foreach ($account in $listofaccounts) {
[string]$a = $account.account
[string]$b = $account.desc
if (Create-LocalUser -user $account.account -password $SVC_Pwd -desc $account.desc) {
$errorcode++
Create-LogInfo \&quot;Create $b\&quot; \&quot;SUCCESS\&quot;
$acc = Get-WmiObject Win32_UserAccount -computername \&quot;.\&quot; -filter \&quot;LocalAccount=True AND` Name='$a'\&quot;
$acc.PasswordChangeable=$false
$acc.PasswordExpires=$false
if ($acc.put()) {
$errorcode++
Create-LogInfo \&quot;Modify $b\&quot; \&quot;SUCCESS\&quot;
} else {
Create-LogInfo \&quot;Modify $b\&quot; \&quot;ERROR\&quot;; GetError \&quot;Error modify the $b\&quot; $errorcode
}
} else {
Create-LogInfo \&quot;Create $b\&quot; \&quot;ERROR\&quot;; GetError \&quot;The account $b is not created\&quot; $errorcode
}
}


$GetSVC = gwmi Win32_UserAccount -computername \&quot;.\&quot; -filter \&quot;LocalAccount=True\&quot; | ?{ $_.name -match \&quot;svc_\&quot; }

if ($GetSVC.length -eq $listofaccounts.count) {
Create-LogInfo \&quot;Create accounts\&quot; \&quot;SUCCESS\&quot;
$errorcode++
} else {
Create-LogInfo \&quot;Create accounts\&quot; \&quot;ERROR\&quot;; GetError \&quot;All accounts not created\&quot; $errorcode
}

# Give correct privileges

Create-LogInfo \&quot;Set Privileges\&quot; \&quot;START\&quot;
if (Set-SePrivilege $scriptdir) {
Create-LogInfo \&quot;Set Privileges\&quot; \&quot;SUCCESS\&quot;
$errorcode++
} else {
Create-LogInfo \&quot;Set Privileges\&quot; \&quot;ERROR\&quot;; GetError \&quot;Error Seting Privileges\&quot; $errorcode
}


###########################
# #
# SQL Server installation #
# #
###########################

Create-LogInfo \&quot;SQL Installation\&quot; \&quot;START\&quot;

$inv = $sourcesdir + \&quot;setup.exe /SAPWD=\&quot; + $AdminPassword + \&quot; /CONFIGURATIONFILE=\&quot; + $scriptdir + \&quot;config.ini\&quot;
invoke-expression $inv

if (ps | ?{$_.name -eq \&quot;sqlservr\&quot;})
{
Create-LogInfo \&quot;Install SQL\&quot; \&quot;SUCCESS\&quot;
$errorcode++
}
else
{
Create-LogInfo \&quot;Install SQL\&quot; \&quot;ERROR\&quot;; GetError \&quot;Install SQL\&quot; $errorcode
}

############################
# #
# SQL Server Configuration #
# #
############################

# Network configuration

Create-LogInfo \&quot;TCP/IP Configuration\&quot; \&quot;START\&quot;

$HKML_IPall = \&quot;HKLM:\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQLServer\SuperSocketNetLib\Tcp\IPAll\&quot;
Set-ItemProperty $HKML_IPall -name \&quot;TcpPort\&quot; -value \&quot;1433\&quot;
Set-ItemProperty $HKML_IPall -name \&quot;TcpDynamicPorts\&quot; -value \&quot;\&quot;

$Get_TcpPort = (Get-ItemProperty $HKML_IPall).TcpPort
$Get_TcpDynamicPorts = (Get-ItemProperty $HKML_IPall).TcpDynamicPorts

if (($Get_TcpPort -eq 1433) -and ($Get_TcpDynamicPorts -eq \&quot;\&quot;«»)) {
Create-LogInfo \&quot;Configuring TCP Port\&quot; \&quot;SUCCESS\&quot;
$errorcode++
} else {
Create-LogInfo \&quot;Configuring TCP Port\&quot; \&quot;ERROR\&quot;; GetError \&quot;Error Configuring TCP Port\&quot; $errorcode
}

# Load SQL CMDLETS

add-pssnapin sqlserverprovidersnapin100
add-pssnapin sqlservercmdletsnapin100

# Configuration of TempDB

Create-LogInfo \&quot;Configure TempDB File\&quot; \&quot;START\&quot;

Invoke-Sqlcmd -Query $TempDBmodify -Serverinstance .

$tempdbmaxsize = Invoke-Sqlcmd -Query $SelectTempDB -Serverinstance .

if ($tempdbmaxsize.max_size -eq 65536)
{
Create-LogInfo \&quot;Configure TempDB File\&quot; \&quot;SUCCESS\&quot;
$errorcode++
} else {
Create-LogInfo \&quot;Configure TempDB File\&quot; \&quot;ERROR\&quot;; GetError \&quot;Error Configure TempDB File\&quot; $errorcode
}

Create-LogInfo \&quot;Configure TempDB Log File\&quot; \&quot;START\&quot;

Invoke-Sqlcmd -Query $TempLogDBmodify -Serverinstance .

$templogdbmaxsize = Invoke-Sqlcmd -Query $SelectTempLogDB -Serverinstance .

if ($templogdbmaxsize.max_size -eq 65536)
{
Create-LogInfo \&quot;Configure TempDB Log File\&quot; \&quot;SUCCESS\&quot;
$errorcode++
} else {
Create-LogInfo \&quot;Configure TempDB Log File\&quot; \&quot;ERROR\&quot;; GetError \&quot;Error Configure TempDB Log File\&quot; $errorcode
}

Create-LogInfo \&quot;Auto-Configure TempDB\&quot; \&quot;START\&quot;

Invoke-Sqlcmd -Query $TempDBadd -Serverinstance .

$NumberTempDBFiles = Invoke-Sqlcmd -Query $CountTempDBFiles -Serverinstance .
$NumberCPU = Invoke-Sqlcmd -Query $CpuCount -Serverinstance .

if ($NumberTempDBFiles.numcpu -eq $NumberCPU.cpu_count)
{
Create-LogInfo \&quot;Auto-Configure TempDB\&quot; \&quot;SUCCESS\&quot;
$errorcode++
} else {
Create-LogInfo \&quot;Auto-Configure TempDB\&quot; \&quot;ERROR\&quot;; GetError \&quot;Error Auto-Configure TempDB\&quot; $errorcode
}

# Configure accounts for SQL Server Services

Create-LogInfo \&quot;Configure SQL Services\&quot; \&quot;START\&quot;

$i = 0
Foreach ($service in $ServicesList) {
$account = $listofaccounts[$i].account
[string]$servname = $service.shortname
$exec = C:\Temp\SQL\EXP\scripts\sc.exe config $servname obj= .\$account password= $SVC_Pwd
$i++
if ($exec -match \&quot;SUCCESS\&quot;«») {
Create-LogInfo \&quot;Configure SQL Service ($servname) \&quot; \&quot;SUCCESS\&quot;
$errorcode++
Stop-Service -name $servname -force
Start-Service -name $servname
$FullService = Get-Service -Name $servname
if ($FullService.Status -eq \&quot;Running\&quot;«»){
Create-LogInfo \&quot;Restart SQL Service ($servname) \&quot; \&quot;SUCCESS\&quot;
$errorcode++
} else {
Create-LogInfo \&quot;Restart SQL Service ($servname)\&quot; \&quot;ERROR\&quot;; GetError \&quot;Error Restart SQL Service ($servname)\&quot; $errorcode
}
} else {
Create-LogInfo \&quot;Configure SQL Service ($servname)\&quot; \&quot;ERROR\&quot;; GetError \&quot;Error Configure SQL Service ($servname)\&quot; $errorcode
}

}

Create-LogInfo \&quot;Configure SQL Services\&quot; \&quot;SUCCESS\&quot;

exit 0[/code:1]

Et le fichier de réponse pour l'installation:
[code:1];SQLSERVER2008 Configuration File
[SQLSERVER2008]

; Instance Name
INSTANCEID=\&quot;MSSQLSERVER\&quot;
INSTANCENAME=\&quot;MSSQLSERVER\&quot;

; Silent Install
ACTION=\&quot;Install\&quot;
FEATURES=SQLENGINE,REPLICATION,FULLTEXT,RS,BIDS,SSMS,SNAC_SDK,OCS,SSMS,ADV_SSMS
INDICATEPROGRESS=\&quot;False\&quot;
QUIET=\&quot;True\&quot;
QUIETSIMPLE=\&quot;False\&quot;

; Options
HELP=\&quot;False\&quot;
X86=\&quot;False\&quot;
ENU=\&quot;True\&quot;
ERRORREPORTING=\&quot;False\&quot;
SQMREPORTING=\&quot;False\&quot;
SQLCOLLATION=\&quot;French_CI_AS\&quot;
FARMADMINPORT=\&quot;0\&quot;
FILESTREAMLEVEL=\&quot;0\&quot;
ENABLERANU=\&quot;False\&quot;
TCPENABLED=\&quot;1\&quot;
NPENABLED=\&quot;0\&quot;
RSINSTALLMODE=\&quot;DefaultNativeMode\&quot;
IAcceptSQLServerLicenseTerms

; Directories
INSTALLSHAREDDIR=\&quot;D:\system_db\&quot;
INSTALLSHAREDWOWDIR=\&quot;D:\system_db_x86\&quot;
INSTANCEDIR=\&quot;D:\system_db\&quot;
SQLBACKUPDIR=\&quot;D:\backup_db\&quot;
SQLUSERDBDIR=\&quot;D:\user_db\&quot;
SQLUSERDBLOGDIR=\&quot;D:\log_db\&quot;
SQLTEMPDBDIR=\&quot;D:\temp_db\&quot;
SQLTEMPDBLOGDIR=\&quot;D:\temp_log_db\&quot;

; Accounts service
AGTSVCACCOUNT=\&quot;NT AUTHORITY\NETWORK SERVICE\&quot;
ISSVCACCOUNT=\&quot;NT AUTHORITY\NETWORK SERVICE\&quot;
SQLSVCACCOUNT=\&quot;NT AUTHORITY\NETWORK SERVICE\&quot;
RSSVCACCOUNT=\&quot;NT AUTHORITY\NETWORK SERVICE\&quot;
FTSVCACCOUNT=\&quot;NT AUTHORITY\LOCAL SERVICE\&quot;

; Service configuration
AGTSVCSTARTUPTYPE=\&quot;Automatic\&quot;
ISSVCSTARTUPTYPE=\&quot;Automatic\&quot;
SQLSVCSTARTUPTYPE=\&quot;Automatic\&quot;
BROWSERSVCSTARTUPTYPE=\&quot;Automatic\&quot;
RSSVCSTARTUPTYPE=\&quot;Automatic\&quot;

; Security
SQLSYSADMINACCOUNTS=\&quot;Administrator\&quot;
SECURITYMODE=\&quot;SQL\&quot;
[/code:1]<br><br>Message édité par: benduru, à: 17/04/12 09:56

Bonjour

Merci pour ce poste
Cela m'a permis de faire un script d'installation dans la journée
Jeeps64

De rien, c'est là pour ça