Sql server R2 instance Creation,

See more:

.NET2.0

VB

.NET

I created the Sql Server R2 instance using Following bacth file.
Its created the Sql Server ,and Sql server Agent (Check Sql server Configuration manager).but the Sqlserver did not start . Its showing Some error when i manually started that Service in Sql Server Configuration.

My Question is
1.Dont want to install the Sql Server Agent , Only install Sql server New instance.
2.Start the Sql server service , when i created the Instance.


Regards,
Saran.t

*********************************************************************
@echo off
rem 	Performs SQL Desktop Engine Setup


cls

echo *
echo     Unattended SQL DESKTOP ENGINE starting.
echo *
echo *
echo     Waiting for DESKTOP ENGINE Setup to finish...

rem =================================
rem What Platform?
rem =================================

@echo on
start /wait ServicePack\SQLEXPRWT_x86_ENU.exe /QS /ACTION=Install /IACCEPTSQLSERVERLICENSETERMS /ERRORREPORTING=0 /FEATURES=SQLEngine /INSTANCENAME=NewINSTANCENAME /BROWSERSVCSTARTUPTYPE=Disabled /SECURITYMODE=SQL /SAPWD=PWD /SQLSVCACCOUNT="NT AUTHORITY\SYSTEM" /SQLSVCSTARTUPTYPE=Automatic /TCPENABLED=1 /SQLSYSADMINACCOUNTS="Everyone" /AGTSVCACCOUNT="NT AUTHORITY\SYSTEM" /AGTSVCSTARTUPTYPE=Disabled

@echo off
:END
:DONE
********************************************************************