Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
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
********************************************************************
Posted 11-Feb-11 19:07pm
Edited 11-Feb-11 19:21pm
(no name)498.6K
v2
Comments
Sandeep Mewara at 12-Feb-11 0:21am
   
Use PRE tags to format code part. It makes the question readable.
Dave Kreskowiak at 12-Feb-11 10:16am
   
So you got an error when you did this. You know, that message where the computer tells you there's a specific problem. That message that gives vital clues to what went wrong. You didn't think that was important enough to include in a post that asks "What's my problem? Where did I go wrong?"

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 OriginalGriff 490
1 Maciej Los 305
2 Richard MacCutchan 270
3 Mathew Soji 220
4 BillWoodruff 210
0 OriginalGriff 8,834
1 Sergey Alexandrovich Kryukov 7,477
2 DamithSL 5,689
3 Maciej Los 5,329
4 Manas Bhardwaj 4,986


Advertise | Privacy | Mobile
Web01 | 2.8.1411028.1 | Last Updated 12 Feb 2011
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100