@echo off
if "%3" == "" ( 
	echo " USAGE: install-plesk-with-mssqlexpress.cmd <distrib path> <installation path> <mode> [<MSSQLEXPRESS password>]"
	echo " where <mode> can be: 
	echo " complete - Complete Plesk installation
	echo " typical - Typical Plesk installation
	echo " {comp_list} - Complete Plesk installation without specified components (use a comma to separate the components)
	exit /b 1
)
 
set plesk_distrib_dir=%~1
 
set plesk_dir=%~2
 
set plesk_non_typical=KasperskyAV,PDFDoc,Python,JDK,Tomcat
 
if "%3" == "complete" set plesk_exclude=MSDE,MSSQLEXPRESS
 
if "%3" == "typical" set plesk_exclude=MSDE,MSSQLEXPRESS,%plesk_non_typical%
 
if "%plesk_exclude%" == "" set plesk_exclude=MSDE,MSSQLEXPRESS,%~3
 
set mssqlexpress_pwd=1q2w3e4R
 
if "%~4" NEQ "" set mssqlexpress_pwd=%4
 
@echo on
 
set sql_server_exe=%plesk_distrib_dir%\sql_server_2005_express_edition_sp2_x32.EXE
 
If "%PROCESSOR_ARCHITECTURE%" NEQ "x86" set sql_server_exe=%plesk_distrib_dir%\sql_server_2005_express_edition_sp2_x64.EXE
 
@echo SQL SERVER Installer path: "%sql_server_exe%"
 
"%sql_server_exe%" /qb ADDLOCAL=ALL DISABLENETWORKPROTOCOLS=0 SECURITYMODE=SQL REBOOT=ReallySuppress INSTALLSQLDIR="%plesk_dir%\Databases\MSSQL\" INSTALLSQLDATADIR="%plesk_dir%\Databases\MSSQL\" INSTALLSQLSHAREDDIR="%plesk_dir%\Databases\MSSQL\" INSTALLASDATADIR="%plesk_dir%\Databases\MSSQL\" INSTANCENAME=MSSQLSERVER
 
If "%ERRORLEVEL%" NEQ "0" exit /b %ERRORLEVEL%
 
set osql_exe=%plesk_dir%\Databases\MSSQL\90\Tools\Binn\OSQL.EXE
 
If "%PROCESSOR_ARCHITECTURE%" NEQ "x86" set osql_exe=%plesk_dir%\Databases\MSSQL (x86)\90\Tools\Binn\OSQL.EXE
 
@echo OSQL.EXE path: "%osql_exe%" 
 
"%osql_exe%" -E -Q "ALTER LOGIN sa WITH PASSWORD='%mssqlexpress_pwd%'; ALTER LOGIN sa ENABLE"
 
If "%ERRORLEVEL%" NEQ "0" exit /b %ERRORLEVEL%
 
reg ADD "HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer" /v LoginMode /d 2 /t REG_DWORD /f 
 
net stop MSSQLSERVER /Y
 
net start MSSQLSERVER /Y
 
"%plesk_distrib_dir%\SetupPlesk.exe" /qn MSSQL_HOST=localhost MSSQL_ADMIN_NAME=sa MSSQL_ADMIN_PASSWD="%mssqlexpress_pwd%" INSTALLDIR="%plesk_dir%" ADDLOCAL=ALL REMOVE=%plesk_exclude% /l*v "%plesk_dir%\plesk-install.log"
 
If "%ERRORLEVEL%" NEQ "0" exit /b %ERRORLEVEL%

install-plesk-with-mssqlexpress.cmd "C:\Plesk\Install" "C:\Plesk" complete [MSSQLpassword]